public void Create(ProductWarehouseLogDetailModel model) { string sql = string.Format(@" insert into ProductWarehouseLogDetail (WarehouseNumber,DocumentNumber,ProductNumber,Version, RowNumber,OrdersNumber,Qty,InventoryQty,Remark,CustomerProductNumber) values('{0}','','{1}','{2}','','',{3},0,'{4}','{5}') ", model.WarehouseNumber, model.ProductNumber, model.Version, model.Qty, model.Remark, model.CustomerProductNumber); SqlHelper.ExecuteSql(sql); }
public ProductWarehouseLogDetailModel Get(string guid) { ProductWarehouseLogDetailModel model = new ProductWarehouseLogDetailModel(); string sql = string.Format(@"select top 1 * from ProductWarehouseLogDetail where guid='{0}'", guid); DataTable dt = SqlHelper.GetTable(sql); if (dt != null && dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; model.Guid = guid; model.WarehouseNumber = dr["WarehouseNumber"] == null ? string.Empty : dr["WarehouseNumber"].ToString(); model.ProductNumber = dr["ProductNumber"] == null ? string.Empty : dr["ProductNumber"].ToString(); model.Version = dr["Version"] == null ? string.Empty : dr["Version"].ToString(); model.CustomerProductNumber = dr["CustomerProductNumber"] == null ? string.Empty : dr["CustomerProductNumber"].ToString(); model.Remark = dr["Remark"] == null ? string.Empty : dr["Remark"].ToString(); model.Qty = dr["Qty"] == null ? 0 : Convert.ToInt32(dr["Qty"].ToString()); } return(model); }