Блог

У меня есть две таблицы в базе данных SQL клиенты и заказы. у клиента есть несколько заказов, которые я хочу, если я нажму на TR, между этим TR и следующим TR появится новая таблица. Что происходит, так это то, что TR, который следует за TR(который содержит внутреннюю таблицу), не является частью структуры таблицы, как это должно быть. вот мои таблицы

 CREATE TABLE [dbo].[customer_list]( [customer_id] [int] NOT NULL, [ContactName] [varchar](255) NOT NULL, [phone] [varchar](255) NOT NULL, [address] [varchar](255) NOT NULL, [city] [varchar](255) NOT NULL, [postalcode] [varchar](255) NOT NULL ) ON [PRIMARY]  CREATE TABLE [dbo].[order_list]( [OrderId] [int] NOT NULL, [customer_id] [int] NOT NULL, [OrderDate] [date] NULL, [ShipDate] [date] NULL, [address] [varchar](255) NOT NULL, [ShipName] [varchar](255) NOT NULL, [postalcode] [varchar](255) NOT NULL ) ON [PRIMARY]  

класс модели

 using System; using System.Collections.Generic; using System.Linq; using System.Web;  namespace WebApplication7.Models { public class Customer {  public string Name { get; set; }  public string phone { get; set; }  public string address { get; set; }  public string city { get; set; }  } public class Orders {  public int OrderID { get; set; }  public int CustomerId { get; set; }  public DateTime OrderDate { get; set; }  public DateTime ShipDate { get; set; }  public string address { get; set; }  public string ShipName { get; set; }  public string PostalCode { get; set; } } public class MasterDetails {  public Listlt;Customergt; CustPersonal { get; set; }  public Listlt;Ordersgt; CustRegions { get; set; }  } }  

Хранилище

 using System; using System.Collections.Generic; using System.Linq; using System.Web; using Dapper; using WebApplication7.Models; using System.Drawing; using System.Data.SqlClient; using System.Configuration; using System.Data;  namespace WebApplication7.Repository {  public class CustomerRepo  {  //To Handle connection related activities   SqlConnection con;  private void connection()  {  string constr = ConfigurationManager.ConnectionStrings["SqlConn"].ToString();  con = new SqlConnection(constr);  }  /// lt;summarygt;   /// Get Multiple Table details   /// lt;/summarygt;   /// lt;returnsgt;lt;/returnsgt;   public IEnumerablelt;MasterDetailsgt; GetMasterDetails()  {  connection();  con.Open();  var objDetails = SqlMapper.QueryMultiple(con, "GetMasterDetails", commandType: CommandType.StoredProcedure);  MasterDetails ObjMaster = new MasterDetails();   //Assigning each Multiple tables data to specific single model class   ObjMaster.CustPersonal = objDetails.Readlt;Customergt;().ToList();  ObjMaster.CustRegions = objDetails.Readlt;Ordersgt;().ToList();   Listlt;MasterDetailsgt; CustomerObj = new Listlt;MasterDetailsgt;();  //Add list of records into MasterDetails list   CustomerObj.Add(ObjMaster);  con.Close();   return CustomerObj;   }  }   }  

controller

 using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.Mvc; using WebApplication7.Models; using WebApplication7.Repository;  namespace WebApplication7.Controllers {  public class CustomerController : Controller  {  public ActionResult MasterDetail()  {  CustomerRepo objDet = new CustomerRepo();  MasterDetails CustData = new MasterDetails();   Listlt;MasterDetailsgt; MasterData = objDet.GetMasterDetails().ToList();   CustData.CustPersonal = MasterData[0].CustPersonal;  CustData.CustRegions = MasterData[0].CustRegions;    return View(CustData);  }  } }  

Вид

 @model IEnumerablelt;WebApplication7.Models.MasterDetailsgt;  @{  ViewBag.Title = "MasterDetail"; }  @using (Html.BeginForm()) {  lt;div class="form-horizontal"gt;  lt;hr /gt;  lt;div class="form-group"gt;  lt;h5 class="btn btn-primary"gt;Customer Type Masterlt;/h5gt;  lt;div class="col-md-12"gt;  lt;table class="table table-hover col-md-3"gt;   lt;trgt;  lt;thgt;  Contact Name  lt;/thgt;  lt;thgt;  Phone  lt;/thgt;  lt;thgt;  Address  lt;/thgt;   lt;thgt;  City  lt;/thgt;  lt;thgt;  Postal Code  lt;/thgt;  lt;/trgt;    @{  //To make unique Id  int i = 0;  foreach (var item in Model.CustPersonal)  {   lt;trgt;  lt;tdgt;    @Html.EditorFor(o =gt; o.CustPersonal[i].name, new { @id = "Name_"   i })  lt;/tdgt;  lt;tdgt;  @Html.EditorFor(o =gt; o.CustPersonal[i].phone, new { @id = "NCustomerType_"   i })    lt;/tdgt;  lt;tdgt;  @Html.EditorFor(o =gt; o.CustPersonal[i].address, new { @id = "Gender_"   i })  lt;/tdgt;   lt;tdgt;  @Html.EditorFor(o =gt; o.CustPersonal[i].city, new { @id = "Gender_"   i })  lt;/tdgt;   lt;/trgt;  i  ;  }  }  lt;/tablegt;  lt;/divgt;  lt;/divgt;   lt;div class="form-group"gt;  lt;h5 class="btn btn-primary"gt;Customer Orderslt;/h5gt;  lt;div class="col-md-12"gt;  lt;table class="table table-condensed table-hover col-md-3"gt;  lt;trgt;  lt;thgt;  Order ID  lt;/thgt;  lt;thgt;  Order Date  lt;/thgt;  lt;thgt;  Ship Date  lt;/thgt;  lt;thgt;  Ship Name  lt;/thgt;  lt;thgt;  address  lt;/thgt;   lt;thgt;  Postal Code  lt;/thgt;   lt;/trgt;  @{  //To make unique Id  int j = 0;  foreach (var item in Model.CustRegions)  {   lt;trgt;  lt;tdgt;    @Html.EditorFor(o =gt; o.CustRegions[j].OrderID, new { @id = "OrderID_"   j })  lt;/tdgt;  lt;tdgt;  @Html.EditorFor(o =gt; o.CustRegions[j].OrderDate, new { @id = "OrderDate_"   j })    lt;/tdgt;  lt;tdgt;  @Html.EditorFor(o =gt; o.CustRegions[j].ShipDate, new { @id = "ShipDate_"   j })  lt;/tdgt;   lt;tdgt;  @Html.EditorFor(o =gt; o.CustRegions[j].ShipName, new { @id = "ShipName_"   j })  lt;/tdgt;   lt;tdgt;  @Html.EditorFor(o =gt; o.CustRegions[j].address, new { @id = "address_"   j })  lt;/tdgt;  lt;tdgt;  @Html.EditorFor(o =gt; o.CustRegions[j].PostalCode, new { @id = "PostalCode_"   j })  lt;/tdgt;   lt;/trgt;  j  ;  }  }  lt;/tablegt;  lt;/divgt;  lt;/divgt;   lt;/divgt;  }   

вот изображение, которое я ожидаю получить на выходе