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);
}
