public Page_Orders_Product(Model.ProductOrderModelForDataGrid d) { InitializeComponent(); this.dForDataGrid = d; this.Guid = dForDataGrid.Guid; isNew = false; FillData(); }
internal bool MarkDelete(Model.ProductOrderModelForDataGrid d) { bool flag = true; string sql = "Update T_Orders_Product Set DeleteMark='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "' Where GUID='" + d.Guid + "'"; flag = new Helper.SQLite.DBHelper().SingleExecution(sql); return(flag); }
internal bool ReadList(out List <Model.ProductOrderModelForDataGrid> data) { bool flag = true; Guid LastOrderGuid = new Guid(); data = new List <Model.ProductOrderModelForDataGrid>(); string sql = " SELECT " + " a.Guid,a.OrderNumber,c.Name as CustomerName,a.DeliveryDate,a.OrderDate, " + " d.Name as ProductName,b.NumberOfItems,b.Quantity,b.Unit,b.Remark " + " FROM " + " T_Orders_Product a " + " LEFT JOIN T_Orders_ProductDetails b ON a.Guid = b.OrderID " + " LEFT JOIN T_UserInfo_Customer c ON a.CustomerID=c.GUID " + " LEFT JOIN T_ProductInfo_Product d ON d.GUID=b.ProductID " + " WHERE a.DeleteMark IS NULL " + " ORDER BY a.OrderNumber,b.rowid "; DataSet ds = new DataSet(); flag = new Helper.SQLite.DBHelper().QueryData(sql, out ds); if (flag) { int id = 1; Model.ProductOrderModelForDataGrid d = new Model.ProductOrderModelForDataGrid(); foreach (DataRow dr in ds.Tables[0].Rows) { if (LastOrderGuid == (Guid)dr["GUID"]) { d.ProductName += "\n" + dr["ProductName"].ToString(); d.NumberOfItems += "\n" + dr["NumberOfItems"].ToString(); d.Quantity += "\n" + dr["Quantity"].ToString(); d.Unit += "\n" + dr["Unit"].ToString(); d.Remark += "\n" + dr["Remark"].ToString(); } else { if (LastOrderGuid != new Guid()) { data.Add(d); } d = new Model.ProductOrderModelForDataGrid(); d.Guid = (Guid)dr["GUID"]; d.OrderNumber = dr["OrderNumber"].ToString(); d.CustomerName = dr["CustomerName"].ToString(); d.DeliveryDate = (Convert.ToDateTime(dr["DeliveryDate"]).Year < 10) ? "" : Convert.ToDateTime(dr["DeliveryDate"]).ToString("yyyy-MM-dd"); d.OrderDate = Convert.ToDateTime(dr["OrderDate"]).ToString("yyyy-MM-dd"); d.Id = id++; d.ProductName = dr["ProductName"].ToString(); d.NumberOfItems = dr["NumberOfItems"].ToString(); d.Quantity = dr["Quantity"].ToString(); d.Unit = dr["Unit"].ToString(); d.Remark = dr["Remark"].ToString(); } LastOrderGuid = (Guid)dr["GUID"]; } if (LastOrderGuid != new Guid()) { data.Add(d); } } return(flag); }