/// <summary> /// 增加一条数据 /// </summary> public int Add(FishEntity.LoadingDetailEntity model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into t_loadingdetail("); strSql.Append("mid,productid,productcode,product,specification,shipname,billofgoods,tons,packages,remark,unitprice,contractid,contractno,contractseq,contractdetailid)"); strSql.Append(" values ("); strSql.Append("@mid,@productid,@productcode,@product,@specification,@shipname,@billofgoods,@tons,@packages,@remark,@unitprice,@contractid,@contractno,@contractseq,@contractdetailid);"); strSql.Append("select LAST_INSERT_ID();"); MySqlParameter[] parameters = { new MySqlParameter("@mid", MySqlDbType.Int32, 11), new MySqlParameter("@productid", MySqlDbType.Int32, 11), new MySqlParameter("@productcode", MySqlDbType.VarChar, 45), new MySqlParameter("@product", MySqlDbType.VarChar, 50), new MySqlParameter("@specification", MySqlDbType.VarChar, 45), new MySqlParameter("@shipname", MySqlDbType.VarChar, 50), new MySqlParameter("@billofgoods", MySqlDbType.VarChar, 45), new MySqlParameter("@tons", MySqlDbType.Decimal, 12), new MySqlParameter("@packages", MySqlDbType.Int32, 11), new MySqlParameter("@remark", MySqlDbType.VarChar, 255), new MySqlParameter("@unitprice", MySqlDbType.Decimal, 12), new MySqlParameter("@contractid", MySqlDbType.Int32, 8), new MySqlParameter("@contractno", MySqlDbType.VarChar, 45), new MySqlParameter("@contractseq", MySqlDbType.Int32, 10), new MySqlParameter("@contractdetailid", MySqlDbType.Int32, 10) }; parameters[0].Value = model.mid; parameters[1].Value = model.productid; parameters[2].Value = model.productcode; parameters[3].Value = model.product; parameters[4].Value = model.specification; parameters[5].Value = model.shipname; parameters[6].Value = model.billofgoods; parameters[7].Value = model.tons; parameters[8].Value = model.packages; parameters[9].Value = model.remark; parameters[10].Value = model.unitprice; parameters[11].Value = model.contractid; parameters[12].Value = model.contractno; parameters[13].Value = model.contractseq; parameters[14].Value = model.contractdetailid; int id = MySqlHelper.ExecuteSqlReturnId(strSql.ToString(), parameters); return(id); }
/// <summary> /// 得到一个对象实体 /// </summary> public FishEntity.LoadingDetailEntity GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select id,mid,productid,productcode,product,specification,shipname,billofgoods,tons,packages,remark,unitprice,contractid,contractno,contractseq,contractdetailid from t_loadingdetail "); strSql.Append(" where id=@id"); MySqlParameter[] parameters = { new MySqlParameter("@id", MySqlDbType.Int32) }; parameters[0].Value = id; FishEntity.LoadingDetailEntity model = new FishEntity.LoadingDetailEntity(); DataSet ds = MySqlHelper.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(FishEntity.LoadingDetailEntity model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(FishEntity.LoadingDetailEntity model) { return(dal.Add(model)); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(FishEntity.LoadingDetailEntity model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update t_loadingdetail set "); strSql.Append("mid=@mid,"); strSql.Append("productid=@productid,"); strSql.Append("productcode=@productcode,"); strSql.Append("product=@product,"); strSql.Append("specification=@specification,"); strSql.Append("shipname=@shipname,"); strSql.Append("billofgoods=@billofgoods,"); strSql.Append("tons=@tons,"); strSql.Append("packages=@packages,"); strSql.Append("remark=@remark,"); strSql.Append("unitprice=@unitprice,"); strSql.Append("contractid=@contractid,"); strSql.Append("contractno=@contractno,"); strSql.Append("contractseq=@contractseq,"); strSql.Append("contractdetailid=@contractdetailid"); strSql.Append(" where id=@id"); MySqlParameter[] parameters = { new MySqlParameter("@mid", MySqlDbType.Int32, 11), new MySqlParameter("@productid", MySqlDbType.Int32, 11), new MySqlParameter("@productcode", MySqlDbType.VarChar, 45), new MySqlParameter("@product", MySqlDbType.VarChar, 50), new MySqlParameter("@specification", MySqlDbType.VarChar, 45), new MySqlParameter("@shipname", MySqlDbType.VarChar, 50), new MySqlParameter("@billofgoods", MySqlDbType.VarChar, 45), new MySqlParameter("@tons", MySqlDbType.Decimal, 12), new MySqlParameter("@packages", MySqlDbType.Int32, 11), new MySqlParameter("@remark", MySqlDbType.VarChar, 255), new MySqlParameter("@unitprice", MySqlDbType.Decimal, 12), new MySqlParameter("@contractid", MySqlDbType.Int32, 12), new MySqlParameter("@contractno", MySqlDbType.VarChar, 45), new MySqlParameter("@contractseq", MySqlDbType.Int32, 12), new MySqlParameter("@contractdetailid", MySqlDbType.Int32, 11), new MySqlParameter("@id", MySqlDbType.Int32, 11) }; parameters[0].Value = model.mid; parameters[1].Value = model.productid; parameters[2].Value = model.productcode; parameters[3].Value = model.product; parameters[4].Value = model.specification; parameters[5].Value = model.shipname; parameters[6].Value = model.billofgoods; parameters[7].Value = model.tons; parameters[8].Value = model.packages; parameters[9].Value = model.remark; parameters[10].Value = model.unitprice; parameters[11].Value = model.contractid; parameters[12].Value = model.contractno; parameters[13].Value = model.contractseq; parameters[14].Value = model.contractdetailid; parameters[15].Value = model.id; int rows = MySqlHelper.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public FishEntity.LoadingDetailEntity DataRowToModel(DataRow row) { FishEntity.LoadingDetailEntity model = new FishEntity.LoadingDetailEntity(); if (row != null) { if (row["id"] != null && row["id"].ToString() != "") { model.id = int.Parse(row["id"].ToString()); } if (row["mid"] != null && row["mid"].ToString() != "") { model.mid = int.Parse(row["mid"].ToString()); } if (row["productid"] != null && row["productid"].ToString() != "") { model.productid = int.Parse(row["productid"].ToString()); } if (row["productcode"] != null) { model.productcode = row["productcode"].ToString(); } if (row["product"] != null) { model.product = row["product"].ToString(); } if (row["specification"] != null) { model.specification = row["specification"].ToString(); } if (row["shipname"] != null) { model.shipname = row["shipname"].ToString(); } if (row["billofgoods"] != null) { model.billofgoods = row["billofgoods"].ToString(); } if (row["tons"] != null && row["tons"].ToString() != "") { model.tons = decimal.Parse(row["tons"].ToString()); } if (row["packages"] != null && row["packages"].ToString() != "") { model.packages = int.Parse(row["packages"].ToString()); } if (row["unitprice"] != null && row["unitprice"].ToString() != "") { model.unitprice = decimal.Parse(row["unitprice"].ToString()); } if (row["remark"] != null) { model.remark = row["remark"].ToString(); } if (row["contractid"] != null && row["contractid"].ToString() != "") { model.contractid = int.Parse(row["contractid"].ToString()); } if (row["contractno"] != null) { model.contractno = row["contractno"].ToString(); } if (row["contractseq"] != null && row["contractseq"].ToString() != "") { model.contractseq = int.Parse(row["contractseq"].ToString()); } if (row["contractdetailid"] != null && row["contractdetailid"].ToString() != "") { model.contractdetailid = int.Parse(row["contractdetailid"].ToString()); } } return(model); }
protected void AddProducts(int billId, bool isAdd) { List <FishEntity.LoadingDetailEntity> listNews = GetDetails(billId); List <FishEntity.LoadingDetailEntity> listsource = null; FishBll.Bll.LoadingDetailBll detailBll = new FishBll.Bll.LoadingDetailBll(); FishBll.Bll.ProductBll productBll = new FishBll.Bll.ProductBll(); if (isAdd == false) { listsource = detailBll.GetDetailOfBill(billId); if (listsource != null) { foreach (FishEntity.LoadingDetailEntity item in listsource) { bool isExist = listNews.Exists((i) => { return(i.id == item.id); }); if (isExist == false) { UpdateProductCount(item.productid, -item.tons, -item.packages); UpdateContract(item.contractid, item.contractdetailid, -item.tons, -item.packages); bool isDelte = detailBll.Delete(item.id); } } } } foreach (FishEntity.LoadingDetailEntity item in listNews) { if (item.id == 0) { int detailId = detailBll.Add(item); if (detailId > 0) { UpdateProductCount(item.productid, -item.tons, -item.packages); UpdateContract(item.contractid, item.contractdetailid, item.tons, item.packages); item.id = detailId; } } else { decimal sWeight = 0; int sPackage = 0; if (listsource != null) { FishEntity.LoadingDetailEntity sRecord = listsource.Find((i) => { return(i.id == item.id); }); if (sRecord != null) { sWeight = sRecord.tons; sPackage = sRecord.packages; } } decimal dWeight = item.tons; int dPackage = item.packages; decimal weight = dWeight - sWeight; int package = dPackage - sPackage; UpdateProductCount(item.productid, weight, package); UpdateContract(item.contractid, item.contractdetailid, weight, package); detailBll.Update(item); } } SetDetail(listNews); }
protected List <FishEntity.LoadingDetailEntity> GetDetails(int billId) { dataGridView1.EndEdit(); List <FishEntity.LoadingDetailEntity> listNews = new List <FishEntity.LoadingDetailEntity>(); foreach (DataGridViewRow row in dataGridView1.Rows) { if (row.IsNewRow) { continue; } FishEntity.LoadingDetailEntity product = new FishEntity.LoadingDetailEntity(); product.billofgoods = row.Cells["billofgoods"].Value == null ? string.Empty : row.Cells["billofgoods"].Value.ToString().Trim(); product.mid = billId; int did = 0; if (row.Cells["id"].Value != null) { int.TryParse(row.Cells["id"].Value.ToString(), out did); } product.id = did; int packageInt = 0; if (row.Cells["packages"].Value != null) { int.TryParse(row.Cells["packages"].Value.ToString(), out packageInt); } product.packages = packageInt; product.product = row.Cells["productname"].Value == null ? string.Empty : row.Cells["productname"].Value.ToString(); product.productcode = row.Cells["code"].Value == null ? string.Empty : row.Cells["code"].Value.ToString(); int pid = 0; if (row.Cells["productid"].Value != null) { int.TryParse(row.Cells["productid"].Value.ToString(), out pid); } product.productid = pid; product.remark = row.Cells["remark"].Value == null ? string.Empty : row.Cells["remark"].Value.ToString(); product.shipname = row.Cells["shipno"].Value == null ? string.Empty : row.Cells["shipno"].Value.ToString(); product.specification = row.Cells["specification"].Value == null ? string.Empty : row.Cells["specification"].Value.ToString(); decimal tonsDec = 0; if (row.Cells["tons"].Value != null) { decimal.TryParse(row.Cells["tons"].Value.ToString(), out tonsDec); } product.tons = tonsDec; decimal unitpriceDec = 0.00M; if (row.Cells["unitprice"].Value != null) { decimal.TryParse(row.Cells["unitprice"].Value.ToString(), out unitpriceDec); } product.unitprice = unitpriceDec; int contractid = 0; if (row.Cells["contractid"].Value != null) { int.TryParse(row.Cells["contractid"].Value.ToString(), out contractid); } product.contractid = contractid; //product.contractno = row.Cells["contractno"].Value.ToString(); int no = 0; if (row.Cells["no"].Value != null) { int.TryParse(row.Cells["no"].Value.ToString(), out no); } product.contractseq = no; int detailid = 0; if (row.Cells["contractdetailid"].Value != null) { int.TryParse(row.Cells["contractdetailid"].Value.ToString(), out detailid); } product.contractdetailid = detailid; listNews.Add(product); } return(listNews); }