public override int Query() { UIForms.PurchaseApplicationCondition form = new UIForms.PurchaseApplicationCondition(this.Text + "查询"); this.panel1.Enabled = true; if (form.ShowDialog() == DialogResult.OK) { _model = new FishEntity.PurchaseApplicationEntity(); _bll = new FishBll.Bll.PurchaseApplicationBll(); strWhere = form.getStrWhere; _model = _bll.getModel(strWhere); if (_model == null) { MessageBox.Show("请重新查询"); this.panel1.Enabled = false; return(0); } setValue(); //if (string.IsNullOrEmpty(_model.codeNum)) // return 0; //List<FishEntity.PurchaseFishInfo> listFishInfo = _bll.getFishInfoList(_model.codeNum); //if (listFishInfo != null && listFishInfo.Count > 0) // setValueFishInfo(listFishInfo); //List<FishEntity . PurchaseOtherInfo> listOtherInfo = _bll . getOtherInfoList ( _model . codeNum ); //if ( listOtherInfo != null && listOtherInfo . Count > 0 ) // setValueOtherInfo ( listOtherInfo ); } return(base.Query()); }
void QueryOne(string operate, string orderBy) { string whereEx = string.Empty; if (string.IsNullOrEmpty(strWhere)) { whereEx = "1=1"; } else { whereEx = strWhere; } if (_model != null) { whereEx = whereEx + " AND codeNum " + operate + orderBy; } _model = _bll.getModel(whereEx); if (_model == null) { MessageBox.Show("已经没有记录了"); return; } setValue( ); }
private void FormPurchaseApplication_Load(object sender, EventArgs e) { this.tmiPrevious.Visible = false; this.tmiNext.Visible = false; if (Megres.oddNum != "") { _model = new FishEntity.PurchaseApplicationEntity(); _bll = new FishBll.Bll.PurchaseApplicationBll(); _fishInfo = new FishEntity.PurchaseFishInfo(); _otherInfo = new FishEntity.PurchaseOtherInfo(); strWhere = " codeNum='" + Megres.oddNum + "'"; _model = _bll.getModel(strWhere); if (_model == null) { MessageBox.Show("请重新查询"); this.panel1.Enabled = false; return; } setValue(); //if (string.IsNullOrEmpty(_model.codeNum)) // return ; //List<FishEntity.PurchaseFishInfo> listFishInfo = _bll.getFishInfoList(_model.codeNum); //if (listFishInfo != null && listFishInfo.Count > 0) // setValueFishInfo(listFishInfo); this.panel1.Enabled = true; } else { strWhere = string.Empty; } //权限控制功能。 Megres.oddNum = string.Empty; }
public FormPurchaseApplication( ) { InitializeComponent( ); _model = new FishEntity.PurchaseApplicationEntity( ); _bll = new FishBll.Bll.PurchaseApplicationBll( ); this.txtprice.LostFocus += txtprice_LostFocus; this.txtpriceMY.LostFocus += txtpriceMY_LostFocus; }
private void txtcodeNum_DoubleClick(object sender, EventArgs e) { FormPurchaseApplication form = new FormPurchaseApplication( ); if (form.ShowDialog( ) == DialogResult.OK) { FishEntity.PurchaseApplicationEntity model = form.getModel; txtcodeNum.Text = model.codeNum; txtcodeNumContract.Text = model.codeNumContract; } }
private void txtsupply_Click(object sender, EventArgs e) { FormCompanyList form = new FormCompanyList(); if (form.ShowDialog() == DialogResult.OK) { FishEntity.PurchaseApplicationEntity _model = new FishEntity.PurchaseApplicationEntity(); _model = form.getModel; txtsupply.Text = _model.buyer; } }
//采购方 private void txtpurchase_DoubleClick(object sender, EventArgs e) { FormCompanyList form = new FormCompanyList(); if (form.ShowDialog() == DialogResult.OK) { _model = form.getModel; txtpurchase.Text = _model.buyer; //txtpurchaseAbb.Text = _model.buyerAbb; txtpurchaseUser.Text = _model.buyerUser; } }
private void txtdeliveryLast_Click(object sender, EventArgs e) { FormCompanyList form = new FormCompanyList(); FishEntity.PurchaseApplicationEntity get1 = new FishEntity.PurchaseApplicationEntity(); if (form.ShowDialog() == DialogResult.OK) { get1 = form.getModel; txtdeliveryLast.Text = get1.buyer; txtdeliveryLastUse.Text = get1.buyerUser; } }
private void txtCodeNum_DoubleClick(object sender, EventArgs e) { FormPurchaseApplication form = new FormPurchaseApplication( ); if (form.ShowDialog( ) == DialogResult.OK) { FishEntity.PurchaseApplicationEntity _model = form.getModel; List <FishEntity.PurchaseOtherInfo> getOtherInfo = form.getOtherInfo; List <FishEntity.PurchaseFishInfo> getFishInfo = form.getFishInfo; setValue(_model, getOtherInfo, getFishInfo); } }
//供方 private void txtsupplier_DoubleClick(object sender, EventArgs e) { FormCompanyList form = new FormCompanyList(); if (form.ShowDialog() == DialogResult.OK) { _model = form.getModel; txtsupplier.Text = _model.buyer; //txtsupplierAbb.Text = _model.buyerAbb; txtsupplierUser.Text = _model.buyerUser; txtaccount.Text = form.getModel.account.ToString(); txtBank.Text = form.getModel.Bank.ToString(); } }
public override int Query( ) { UIForms.PurchaseApplicationCondition form = new UIForms.PurchaseApplicationCondition( ); if (form.ShowDialog( ) == DialogResult.OK) { strWhere = form.getStrWhere; _model = _bll.getModel(strWhere); if (_model == null) { MessageBox.Show("请重新查询"); return(0); } setValue( ); } return(base.Query( )); }
void QueryOne(string operate, string orderBy) { string whereEx = string.Empty; if (string.IsNullOrEmpty(strWhere)) { whereEx = "1=1"; } else { whereEx = strWhere; } if (_model != null) { whereEx = whereEx + " AND a.id " + operate + orderBy; } if (operate != "" && orderBy != "") { _model = new FishEntity.PurchaseApplicationEntity(); _bll = new FishBll.Bll.PurchaseApplicationBll(); _model = _bll.getModel(whereEx); } else { _model = _bll.getModel(strWhere); } if (_model == null) { MessageBox.Show("已经没有记录了"); this.panel1.Enabled = false; return; } setValue(); //if (string.IsNullOrEmpty(_model.codeNum)) // return; //List<FishEntity.PurchaseFishInfo> listFishInfo = _bll.getFishInfoList(_model.codeNum); //if (listFishInfo != null && listFishInfo.Count > 0) // setValueFishInfo(listFishInfo); this.panel1.Enabled = true; whereEx = string.Empty; //List<FishEntity . PurchaseOtherInfo> listOtherInfo = _bll . getOtherInfoList ( _model . codeNum ); //if ( listOtherInfo != null && listOtherInfo . Count > 0 ) // setValueOtherInfo ( listOtherInfo ); }
public override int Add( ) { panel1.Enabled = true; ControlClear( ); //txtcodeNumContract . Text = _bll . getCodeNum ( ); if (getname != "" && getname != null) { FishEntity.PurchaseApplicationEntity fish = new FishEntity.PurchaseApplicationEntity(); FishBll.Bll.PurchaseApplicationBll _Addbll = new FishBll.Bll.PurchaseApplicationBll(); fish = _Addbll.getModel(" codeNum='" + getname + "' "); if (fish != null) { yincang(fish.choise); jincang = fish.choise; txtCodeNum.Text = fish.codeNum; txtsupplier.Text = fish.supplier; txtsupplierUser.Text = fish.supplierUser; txtbuyer.Text = fish.buyer; txtbuyerUser.Text = fish.buyerUser; txtsigndate.Text = fish.signDate.ToString(); txtsignAdd.Text = fish.signAdd; txtpurchase.Text = fish.purchase; txtpurchaseUser.Text = fish.purchaseUser; txtvarieties.Text = fish.varieties; txtheight.Text = fish.Weight.ToString(); txtMoney.Text = fish.AmountOfMoney.ToString(); txtUnitPrice.Text = fish.danjia.ToString(); txtDollar.Text = fish.priceMY.ToString(); txtMoneyMJ.Text = fish.Dollarjine.ToString(); txtproName.Text = fish.proName; //FishBll.Bll.PurchaseApplicationBll bll = new FishBll.Bll.PurchaseApplicationBll(); //List<FishEntity.PurchaseOtherInfo> listOtherInfo = bll.getOtherInfoList(_model.codeNum); //if (listOtherInfo != null && listOtherInfo.Count > 0) // setValue(listOtherInfo); //List<FishEntity.PurchaseContractFishInfo> listFishInfo = _bll.getFishInfoList(_model.codeNum); //if (listFishInfo != null && listFishInfo.Count > 0) // setValue(listFishInfo); } } return(base.Add( )); }
void setValue(FishEntity.PurchaseApplicationEntity _model, List <FishEntity.PurchaseOtherInfo> listOtherInfo, List <FishEntity.PurchaseFishInfo> getFishInfo) { txtsupplier.Text = _model.supplier; txtsupplierUser.Text = _model.supplierUser; txtbuyer.Text = _model.buyer; txtbuyerUser.Text = _model.buyerUser; txtCodeNum.Text = _model.codeNum; txtsignAdd.Text = _model.signAdd; txtsigndate.Text = _model.signDate.ToString( ); txtvarieties.Text = _model.varieties; txtheight.Text = Convert.ToDecimal(_model.height).ToString("f2"); txtMoney.Text = Convert.ToDecimal(_model.price).ToString("f2"); txtMoneyMJ.Text = Convert.ToDecimal(_model.billNum).ToString("f2"); txtdateshipDate.Text = _model.shipDate.ToString( ); txtdatedeliveryDate.Text = _model.deliveryDate.ToString( ); txtdeliveryAdd.Text = _model.deliveryAdd; jincang = _model.choise; txtconDAS.Text = _model.conDAS; txtconFFA.Text = _model.conFFA; txtconHF.Text = _model.conHF; txtconLAS.Text = _model.conLAS; txtconProtein.Text = _model.conProtein; txtconS.Text = _model.conS; txtconSF.Text = _model.conSF; txtconSHY.Text = _model.conSHY; txtconSJ.Text = _model.conSJ; txtconTVN.Text = _model.conTVN; txtconZA.Text = _model.conZA; txtconZF.Text = _model.conZF; txtpurchase.Text = _model.purchase; txtpurchaseUser.Text = _model.purchaseUser; yincang(_model.choise); //dataGridView2 . Rows . Clear ( ); //foreach ( FishEntity . PurchaseOtherInfo otherInfo in listOtherInfo ) //{ // int idx = dataGridView2 . Rows . Add ( ); // DataGridViewRow row = dataGridView2 . Rows [ idx ]; // row . Cells [ "idx" ] . Value = otherInfo . id; // row . Cells [ "brands" ] . Value = otherInfo . brand; // row . Cells [ "moneys" ] . Value = otherInfo . money; // row . Cells [ "nums" ] . Value = otherInfo . num; //} //dataGridView1 . Rows . Clear ( ); //foreach ( FishEntity . PurchaseFishInfo fishInfo in getFishInfo ) //{ // int idx = dataGridView1 . Rows . Add ( ); // DataGridViewRow row = dataGridView1 . Rows [ idx ]; // row . Cells [ "id" ] . Value = fishInfo . id; // row . Cells [ "fishId" ] . Value = fishInfo . fishId; // row . Cells [ "price" ] . Value = fishInfo . price; // row . Cells [ "weight" ] . Value = fishInfo . weight; // row . Cells [ "priceUSA" ] . Value = fishInfo . priceUSA; // row . Cells [ "specifications" ] . Value = fishInfo . specifications; // row . Cells [ "brand" ] . Value = fishInfo . brand; // row . Cells [ "country" ] . Value = fishInfo . country; // row . Cells [ "shipName" ] . Value = fishInfo . shipName; // row . Cells [ "billName" ] . Value = fishInfo . billName; // row . Cells [ "money" ] . Value = fishInfo . price * fishInfo . weight; // row . Cells [ "moneyUSA" ] . Value = fishInfo . priceUSA * fishInfo . weight; //} //int index = this . dataGridView1 . Rows . Add ( ); //dataGridView1 . Rows [ index ] . Cells [ "fishId" ] . Value = string . Empty; //dataGridView1 . Rows [ index ] . Cells [ "price" ] . Value = string . Empty; //dataGridView1 . Rows [ index ] . Cells [ "weight" ] . Value = string . Empty; //dataGridView1 . Rows [ index ] . Cells [ "priceUSA" ] . Value = string . Empty; //dataGridView1 . Rows [ index ] . Cells [ "specifications" ] . Value = string . Empty; //dataGridView1 . Rows [ index ] . Cells [ "brand" ] . Value = string . Empty; //dataGridView1 . Rows [ index ] . Cells [ "country" ] . Value = string . Empty; //dataGridView1 . Rows [ index ] . Cells [ "shipName" ] . Value = string . Empty; //dataGridView1 . Rows [ index ] . Cells [ "billName" ] . Value = string . Empty; //dataGridView1 . Rows [ index ] . Cells [ "money" ] . Value = string . Empty; //dataGridView1 . Rows [ index ] . Cells [ "moneyUSA" ] . Value = string . Empty; }
/// <summary> /// 编辑数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Edit(FishEntity.PurchaseApplicationEntity model) { StringBuilder strSql = new StringBuilder( ); strSql.Append("update t_purchaseapplication set "); strSql.Append("codeNum=@codeNum,"); strSql.Append("codeNumContract=@codeNumContract,"); strSql.Append("supplier=@supplier,"); strSql.Append("supplierAbb=@supplierAbb,"); strSql.Append("supplierUser=@supplierUser,"); strSql.Append("buyer=@buyer,"); strSql.Append("buyerAbb=@buyerAbb,"); strSql.Append("buyerUser=@buyerUser,"); strSql.Append("signDate=@signDate,"); strSql.Append("signAdd=@signAdd,"); strSql.Append("proName=@proName,"); strSql.Append("bondPro=@bondPro,"); strSql.Append("varieties=@varieties,"); strSql.Append("quaSpe=@quaSpe,"); strSql.Append("height=@height,"); strSql.Append("price=@price,"); strSql.Append("priceMY=@priceMY,"); strSql.Append("conutry=@conutry,"); strSql.Append("brand=@brand,"); strSql.Append("shipName=@shipName,"); strSql.Append("billNum=@billNum,"); strSql.Append("shipDate=@shipDate,"); strSql.Append("arriveDate=@arriveDate,"); strSql.Append("deliveryDate=@deliveryDate,"); strSql.Append("SGSDB=@SGSDB,"); strSql.Append("SGSTVN=@SGSTVN,"); strSql.Append("SGSZA=@SGSZA,"); strSql.Append("SGSZF=@SGSZF,"); strSql.Append("SGSSF=@SGSSF,"); strSql.Append("SGSSHY=@SGSSHY,"); strSql.Append("SGSS=@SGSS,"); strSql.Append("SGSSJ=@SGSSJ,"); strSql.Append("SGSHF=@SGSHF,"); strSql.Append("deliveryAdd=@deliveryAdd,"); strSql.Append("deliveryLast=@deliveryLast,"); strSql.Append("fishId=@fishId,"); strSql.Append("conProtein=@conProtein,"); strSql.Append("conTVN=@conTVN,"); strSql.Append("conZA=@conZA,"); strSql.Append("conFFA=@conFFA,"); strSql.Append("conZF=@conZF,"); strSql.Append("conSF=@conSF,"); strSql.Append("conSHY=@conSHY,"); strSql.Append("conS=@conS,"); strSql.Append("conSJ=@conSJ,"); strSql.Append("conHF=@conHF,"); strSql.Append("conLAS=@conLAS,"); strSql.Append("conDAS=@conDAS,"); strSql.Append("remark=@remark "); strSql.Append(" where id=@id"); MySqlParameter [] parameters = { new MySqlParameter("@codeNum", MySqlDbType.VarChar, 30), new MySqlParameter("@codeNumContract", MySqlDbType.VarChar, 30), new MySqlParameter("@supplier", MySqlDbType.VarChar, 50), new MySqlParameter("@supplierAbb", MySqlDbType.VarChar, 50), new MySqlParameter("@supplierUser", MySqlDbType.VarChar, 50), new MySqlParameter("@buyer", MySqlDbType.VarChar, 50), new MySqlParameter("@buyerAbb", MySqlDbType.VarChar, 50), new MySqlParameter("@buyerUser", MySqlDbType.VarChar, 50), new MySqlParameter("@signDate", MySqlDbType.DateTime), new MySqlParameter("@signAdd", MySqlDbType.VarChar, 100), new MySqlParameter("@proName", MySqlDbType.VarChar, 100), new MySqlParameter("@bondPro", MySqlDbType.Decimal, 18), new MySqlParameter("@varieties", MySqlDbType.VarChar, 50), new MySqlParameter("@quaSpe", MySqlDbType.VarChar, 50), new MySqlParameter("@height", MySqlDbType.Decimal, 18), new MySqlParameter("@price", MySqlDbType.Decimal, 18), new MySqlParameter("@priceMY", MySqlDbType.Decimal, 18), new MySqlParameter("@conutry", MySqlDbType.VarChar, 30), new MySqlParameter("@brand", MySqlDbType.VarChar, 30), new MySqlParameter("@shipName", MySqlDbType.VarChar, 50), new MySqlParameter("@billNum", MySqlDbType.VarChar, 50), new MySqlParameter("@shipDate", MySqlDbType.DateTime), new MySqlParameter("@arriveDate", MySqlDbType.DateTime), new MySqlParameter("@deliveryDate", MySqlDbType.DateTime), new MySqlParameter("@SGSDB", MySqlDbType.VarChar, 50), new MySqlParameter("@SGSTVN", MySqlDbType.VarChar, 50), new MySqlParameter("@SGSZA", MySqlDbType.VarChar, 50), new MySqlParameter("@SGSZF", MySqlDbType.VarChar, 50), new MySqlParameter("@SGSSF", MySqlDbType.VarChar, 50), new MySqlParameter("@SGSSHY", MySqlDbType.VarChar, 50), new MySqlParameter("@SGSS", MySqlDbType.VarChar, 50), new MySqlParameter("@SGSSJ", MySqlDbType.VarChar, 50), new MySqlParameter("@SGSHF", MySqlDbType.VarChar, 50), new MySqlParameter("@deliveryAdd", MySqlDbType.VarChar, 50), new MySqlParameter("@deliveryLast", MySqlDbType.DateTime), new MySqlParameter("@fishId", MySqlDbType.VarChar, 50), new MySqlParameter("@conProtein", MySqlDbType.VarChar, 50), new MySqlParameter("@conTVN", MySqlDbType.VarChar, 50), new MySqlParameter("@conZA", MySqlDbType.VarChar, 50), new MySqlParameter("@conFFA", MySqlDbType.VarChar, 50), new MySqlParameter("@conZF", MySqlDbType.VarChar, 50), new MySqlParameter("@conSF", MySqlDbType.VarChar, 50), new MySqlParameter("@conSHY", MySqlDbType.VarChar, 50), new MySqlParameter("@conS", MySqlDbType.VarChar, 50), new MySqlParameter("@conSJ", MySqlDbType.VarChar, 50), new MySqlParameter("@conHF", MySqlDbType.VarChar, 50), new MySqlParameter("@conLAS", MySqlDbType.VarChar, 50), new MySqlParameter("@conDAS", MySqlDbType.VarChar, 50), new MySqlParameter("@remark", MySqlDbType.VarChar, 255), new MySqlParameter("@id", MySqlDbType.Int32, 11) }; parameters [0].Value = model.codeNum; parameters [1].Value = model.codeNumContract; parameters [2].Value = model.supplier; parameters [3].Value = model.supplierAbb; parameters [4].Value = model.supplierUser; parameters [5].Value = model.buyer; parameters [6].Value = model.buyerAbb; parameters [7].Value = model.buyerUser; parameters [8].Value = model.signDate; parameters [9].Value = model.signAdd; parameters [10].Value = model.proName; parameters [11].Value = model.bondPro; parameters [12].Value = model.varieties; parameters [13].Value = model.quaSpe; parameters [14].Value = model.height; parameters [15].Value = model.price; parameters [16].Value = model.priceMY; parameters [17].Value = model.conutry; parameters [18].Value = model.brand; parameters [19].Value = model.shipName; parameters [20].Value = model.billNum; parameters [21].Value = model.shipDate; parameters [22].Value = model.arriveDate; parameters [23].Value = model.deliveryDate; parameters [24].Value = model.SGSDB; parameters [25].Value = model.SGSTVN; parameters [26].Value = model.SGSZA; parameters [27].Value = model.SGSZF; parameters [28].Value = model.SGSSF; parameters [29].Value = model.SGSSHY; parameters [30].Value = model.SGSS; parameters [31].Value = model.SGSSJ; parameters [32].Value = model.SGSHF; parameters [33].Value = model.deliveryAdd; parameters [34].Value = model.deliveryLast; parameters [35].Value = model.fishId; parameters [36].Value = model.conProtein; parameters [37].Value = model.conTVN; parameters [38].Value = model.conZA; parameters [39].Value = model.conFFA; parameters [40].Value = model.conZF; parameters [41].Value = model.conSF; parameters [42].Value = model.conSHY; parameters [43].Value = model.conS; parameters [44].Value = model.conSJ; parameters [45].Value = model.conHF; parameters [46].Value = model.conLAS; parameters [47].Value = model.conDAS; parameters [48].Value = model.remark; parameters [49].Value = model.id; return(MySqlHelper.ExecuteSql(strSql.ToString( ), parameters)); }
private FishEntity.PurchaseApplicationEntity getModel(DataRow row) { FishEntity.PurchaseApplicationEntity model = new FishEntity.PurchaseApplicationEntity( ); if (row != null) { if (row ["id"] != null && row ["id"].ToString( ) != "") { model.id = int.Parse(row ["id"].ToString( )); } if (row["process"] != null) { model.Process = row["process"].ToString(); } if (row["Money"] != null) { model.Money = row["Money"].ToString(); } if (row["Dollarjine"] != null && row["Dollarjine"].ToString() != "") { model.Dollarjine = decimal.Parse(row["Dollarjine"].ToString()); } if (row["choise"] != null) { model.choise = row["choise"].ToString(); } if (row ["codeNum"] != null) { model.codeNum = row ["codeNum"].ToString( ); } if (row ["codeNumContract"] != null) { model.codeNumContract = row ["codeNumContract"].ToString( ); } if (row ["supplier"] != null) { model.supplier = row ["supplier"].ToString( ); } if (row ["supplierAbb"] != null) { model.supplierAbb = row ["supplierAbb"].ToString( ); } if (row ["supplierUser"] != null) { model.supplierUser = row ["supplierUser"].ToString( ); } if (row ["buyer"] != null) { model.buyer = row ["buyer"].ToString( ); } if (row ["buyerAbb"] != null) { model.buyerAbb = row ["buyerAbb"].ToString( ); } if (row ["buyerUser"] != null) { model.buyerUser = row ["buyerUser"].ToString( ); } if (row ["purchase"] != null) { model.purchase = row ["purchase"].ToString( ); } if (row ["purchaseAbb"] != null) { model.purchaseAbb = row ["purchaseAbb"].ToString( ); } if (row ["purchaseUser"] != null) { model.purchaseUser = row ["purchaseUser"].ToString( ); } if (row ["danjia"] != null && row ["danjia"].ToString( ) != "") { model.danjia = decimal.Parse(row ["danjia"].ToString( )); } if (row ["weight"] != null && row ["weight"].ToString( ) != "") { model.Weight = decimal.Parse(row ["weight"].ToString( )); } if (row["EexchangeRate"] != null && row["EexchangeRate"].ToString() != "") { model.EexchangeRate = decimal.Parse(row["EexchangeRate"].ToString()); } if (row ["fishId"] != null) { model.FishId = row ["fishId"].ToString( ); } if (row ["rebate"] != null && row ["rebate"].ToString( ) != "") { model.rebate = decimal.Parse(row ["rebate"].ToString( )); } if (row ["brands"] != null) { model.brands = row ["brands"].ToString( ); } if (row ["country"] != null) { model.conutry = row ["country"].ToString( ); } if (row ["proName"] != null) { model.proName = row ["proName"].ToString( ); } if (row ["bondPro"] != null && row ["bondPro"].ToString( ) != "") { model.bondPro = decimal.Parse(row ["bondPro"].ToString( )); } if (row ["varieties"] != null) { model.varieties = row ["varieties"].ToString( ); } if (row ["signDate"] != null && row ["signDate"].ToString( ) != "") { model.signDate = DateTime.Parse(row ["signDate"].ToString( )); } if (row ["signAdd"] != null) { model.signAdd = row ["signAdd"].ToString( ); } if (row ["amountOfMoney"] != null && row ["amountOfMoney"].ToString( ) != "") { model.AmountOfMoney = decimal.Parse(row ["amountOfMoney"].ToString( )); } if (row ["priceMY"] != null && row ["priceMY"].ToString( ) != "") { model.priceMY = decimal.Parse(row ["priceMY"].ToString( )); } if (row ["remark"] != null) { model.remark = row ["remark"].ToString( ); } if (row["account"] != null) { model.account = row["account"].ToString(); } if (row["Bank"] != null) { model.Bank = row["Bank"].ToString(); } if (row ["createUser"] != null) { model.createUser = row ["createUser"].ToString( ); } if (row ["createDate"] != null && row ["createDate"].ToString( ) != "") { model.createDate = DateTime.Parse(row ["createDate"].ToString( )); } if (row ["modifyUser"] != null) { model.modifyUser = row ["modifyUser"].ToString( ); } if (row ["modifyDate"] != null && row ["modifyDate"].ToString( ) != "") { model.modifyDate = DateTime.Parse(row ["modifyDate"].ToString( )); } return(model); } else { return(null); } }
/// <summary> /// 新怎数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Add(FishEntity.PurchaseApplicationEntity model) { return(dal.Add(model)); }
/// <summary> /// 编辑数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Edit(FishEntity.PurchaseApplicationEntity model) { StringBuilder strSql = new StringBuilder( ); strSql.Append("update t_purchaseapplication set "); strSql.Append("codeNum=@codeNum,"); strSql.Append("codeNumContract=@codeNumContract,"); strSql.Append("supplier=@supplier,"); strSql.Append("supplierAbb=@supplierAbb,"); strSql.Append("supplierUser=@supplierUser,"); strSql.Append("buyer=@buyer,"); strSql.Append("buyerAbb=@buyerAbb,"); strSql.Append("buyerUser=@buyerUser,"); strSql.Append("purchase=@purchase,"); strSql.Append("purchaseAbb=@purchaseAbb,"); strSql.Append("purchaseUser=@purchaseUser,"); strSql.Append("danjia=@danjia,"); strSql.Append("weight=@weight,"); strSql.Append("fishId=@fishId,"); strSql.Append("rebate=@rebate,"); strSql.Append("brands=@brands,"); strSql.Append("country=@country,"); strSql.Append("proName=@proName,"); strSql.Append("bondPro=@bondPro,"); strSql.Append("choise=@choise,"); strSql.Append("varieties=@varieties,"); strSql.Append("signDate=@signDate,"); strSql.Append("signAdd=@signAdd,"); strSql.Append("amountOfMoney=@amountOfMoney,"); strSql.Append("priceMY=@priceMY,"); strSql.Append("remark=@remark,"); strSql.Append("modifyUser=@modifyUser,"); strSql.Append("process=@process,"); strSql.Append("Money=@Money,"); strSql.Append("Dollarjine=@Dollarjine,"); strSql.Append("EexchangeRate=@EexchangeRate,"); strSql.Append("account=@account,"); strSql.Append("Bank=@Bank,"); strSql.Append("modifyDate=@modifyDate"); strSql.Append(" where id=@id"); MySqlParameter [] parameters = { new MySqlParameter("@codeNum", MySqlDbType.VarChar, 30), new MySqlParameter("@codeNumContract", MySqlDbType.VarChar, 30), new MySqlParameter("@supplier", MySqlDbType.VarChar, 50), new MySqlParameter("@supplierAbb", MySqlDbType.VarChar, 50), new MySqlParameter("@supplierUser", MySqlDbType.VarChar, 50), new MySqlParameter("@buyer", MySqlDbType.VarChar, 50), new MySqlParameter("@buyerAbb", MySqlDbType.VarChar, 50), new MySqlParameter("@buyerUser", MySqlDbType.VarChar, 50), new MySqlParameter("@purchase", MySqlDbType.VarChar, 45), new MySqlParameter("@purchaseAbb", MySqlDbType.VarChar, 45), new MySqlParameter("@purchaseUser", MySqlDbType.VarChar, 45), new MySqlParameter("@danjia", MySqlDbType.Decimal, 18), new MySqlParameter("@weight", MySqlDbType.Decimal, 18), new MySqlParameter("@fishId", MySqlDbType.VarChar, 45), new MySqlParameter("@rebate", MySqlDbType.Decimal, 18), new MySqlParameter("@brands", MySqlDbType.VarChar, 45), new MySqlParameter("@country", MySqlDbType.VarChar, 45), new MySqlParameter("@proName", MySqlDbType.VarChar, 100), new MySqlParameter("@bondPro", MySqlDbType.Decimal, 18), new MySqlParameter("@varieties", MySqlDbType.VarChar, 50), new MySqlParameter("@signDate", MySqlDbType.DateTime), new MySqlParameter("@signAdd", MySqlDbType.VarChar, 100), new MySqlParameter("@amountOfMoney", MySqlDbType.Decimal, 18), new MySqlParameter("@priceMY", MySqlDbType.Decimal, 18), new MySqlParameter("@remark", MySqlDbType.VarChar, 255), new MySqlParameter("@modifyUser", MySqlDbType.VarChar, 50), new MySqlParameter("@modifyDate", MySqlDbType.DateTime), new MySqlParameter("@id", MySqlDbType.Int32, 11), new MySqlParameter("@process", MySqlDbType.VarChar, 45), new MySqlParameter("@choise", MySqlDbType.VarChar, 45), new MySqlParameter("@EexchangeRate", MySqlDbType.VarChar, 45), new MySqlParameter("@Money", MySqlDbType.VarChar, 45), new MySqlParameter("@Dollarjine", MySqlDbType.VarChar, 45), new MySqlParameter("@account", MySqlDbType.VarChar, 200), new MySqlParameter("@Bank", MySqlDbType.VarChar, 200) }; parameters [0].Value = model.codeNum; parameters [1].Value = model.codeNumContract; parameters [2].Value = model.supplier; parameters [3].Value = model.supplierAbb; parameters [4].Value = model.supplierUser; parameters [5].Value = model.buyer; parameters [6].Value = model.buyerAbb; parameters [7].Value = model.buyerUser; parameters [8].Value = model.purchase; parameters [9].Value = model.purchaseAbb; parameters [10].Value = model.purchaseUser; parameters [11].Value = model.danjia; parameters [12].Value = model.Weight; parameters [13].Value = model.FishId; parameters [14].Value = model.rebate; parameters [15].Value = model.brands; parameters [16].Value = model.conutry; parameters [17].Value = model.proName; parameters [18].Value = model.bondPro; parameters [19].Value = model.varieties; parameters [20].Value = model.signDate; parameters [21].Value = model.signAdd; parameters [22].Value = model.AmountOfMoney; parameters [23].Value = model.priceMY; parameters [24].Value = model.remark; parameters [25].Value = model.modifyUser; parameters [26].Value = model.modifyDate; parameters [27].Value = model.id; parameters[28].Value = model.Process; parameters[29].Value = model.choise; parameters[30].Value = model.EexchangeRate; parameters[31].Value = model.Money; parameters[32].Value = model.Dollarjine; parameters[33].Value = model.account; parameters[34].Value = model.Bank; return(MySqlHelper.ExecuteSql(strSql.ToString( ), parameters)); }
/// <summary> /// 新增数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Add(FishEntity.PurchaseApplicationEntity model) { // StringBuilder strSql = new StringBuilder( ); strSql.Append("insert into t_purchaseapplication("); strSql.Append("codeNum,codeNumContract,supplier,supplierAbb,supplierUser,buyer,buyerAbb,buyerUser,purchase,purchaseAbb,purchaseUser,danjia,weight,fishId,rebate,brands,country,proName,bondPro,varieties,signDate,signAdd,amountOfMoney,priceMY,remark,createUser,createDate,modifyUser,modifyDate,Process,choise,EexchangeRate,Money,Dollarjine,account,Bank)"); strSql.Append(" values ("); strSql.Append("@codeNum,@codeNumContract,@supplier,@supplierAbb,@supplierUser,@buyer,@buyerAbb,@buyerUser,@purchase,@purchaseAbb,@purchaseUser,@danjia,@weight,@fishId,@rebate,@brands,@country,@proName,@bondPro,@varieties,@signDate,@signAdd,@amountOfMoney,@priceMY,@remark,@createUser,@createDate,@modifyUser,@modifyDate,@Process,@choise,@EexchangeRate,@Money,@Dollarjine,@account,@Bank);select last_insert_id();"); MySqlParameter [] parameters = { new MySqlParameter("@codeNum", MySqlDbType.VarChar, 30), new MySqlParameter("@codeNumContract", MySqlDbType.VarChar, 30), new MySqlParameter("@supplier", MySqlDbType.VarChar, 50), new MySqlParameter("@supplierAbb", MySqlDbType.VarChar, 50), new MySqlParameter("@supplierUser", MySqlDbType.VarChar, 50), new MySqlParameter("@buyer", MySqlDbType.VarChar, 50), new MySqlParameter("@buyerAbb", MySqlDbType.VarChar, 50), new MySqlParameter("@buyerUser", MySqlDbType.VarChar, 50), new MySqlParameter("@purchase", MySqlDbType.VarChar, 45), new MySqlParameter("@purchaseAbb", MySqlDbType.VarChar, 45), new MySqlParameter("@purchaseUser", MySqlDbType.VarChar, 45), new MySqlParameter("@danjia", MySqlDbType.Decimal, 18), new MySqlParameter("@weight", MySqlDbType.Decimal, 18), new MySqlParameter("@fishId", MySqlDbType.VarChar, 45), new MySqlParameter("@rebate", MySqlDbType.Decimal, 18), new MySqlParameter("@brands", MySqlDbType.VarChar, 45), new MySqlParameter("@country", MySqlDbType.VarChar, 45), new MySqlParameter("@proName", MySqlDbType.VarChar, 100), new MySqlParameter("@bondPro", MySqlDbType.Decimal, 18), new MySqlParameter("@varieties", MySqlDbType.VarChar, 50), new MySqlParameter("@signDate", MySqlDbType.DateTime), new MySqlParameter("@signAdd", MySqlDbType.VarChar, 100), new MySqlParameter("@amountOfMoney", MySqlDbType.Decimal, 18), new MySqlParameter("@priceMY", MySqlDbType.Decimal, 18), new MySqlParameter("@remark", MySqlDbType.VarChar, 255), new MySqlParameter("@createUser", MySqlDbType.VarChar, 50), new MySqlParameter("@createDate", MySqlDbType.DateTime), new MySqlParameter("@modifyUser", MySqlDbType.VarChar, 50), new MySqlParameter("@modifyDate", MySqlDbType.DateTime), new MySqlParameter("@Process", MySqlDbType.VarChar, 45), new MySqlParameter("@choise", MySqlDbType.VarChar, 45), new MySqlParameter("@EexchangeRate", MySqlDbType.VarChar, 45), new MySqlParameter("@Money", MySqlDbType.VarChar, 45), new MySqlParameter("@Dollarjine", MySqlDbType.VarChar, 45), new MySqlParameter("@account", MySqlDbType.VarChar, 200), new MySqlParameter("@Bank", MySqlDbType.VarChar, 200) }; parameters [0].Value = model.codeNum; parameters [1].Value = model.codeNumContract; parameters [2].Value = model.supplier; parameters [3].Value = model.supplierAbb; parameters [4].Value = model.supplierUser; parameters [5].Value = model.buyer; parameters [6].Value = model.buyerAbb; parameters [7].Value = model.buyerUser; parameters [8].Value = model.purchase; parameters [9].Value = model.purchaseAbb; parameters [10].Value = model.purchaseUser; parameters [11].Value = model.danjia; parameters [12].Value = model.Weight; parameters [13].Value = model.FishId; parameters [14].Value = model.rebate; parameters [15].Value = model.brands; parameters [16].Value = model.conutry; parameters [17].Value = model.proName; parameters [18].Value = model.bondPro; parameters [19].Value = model.varieties; parameters [20].Value = model.signDate; parameters [21].Value = model.signAdd; parameters [22].Value = model.AmountOfMoney; parameters [23].Value = model.priceMY; parameters [24].Value = model.remark; parameters [25].Value = model.createUser; parameters [26].Value = model.createDate; parameters [27].Value = model.modifyUser; parameters [28].Value = model.modifyDate; parameters[29].Value = model.Process; parameters[30].Value = model.choise; parameters[31].Value = model.EexchangeRate; parameters[32].Value = model.Money; parameters[33].Value = model.Dollarjine; parameters[34].Value = model.account; parameters[35].Value = model.Bank; return(MySqlHelper.ExecuteSqlReturnId(strSql.ToString( ), parameters)); }
/// <summary> /// 编辑数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Edit(FishEntity.PurchaseApplicationEntity model) { return(dal.Edit(model)); }
private FishEntity.PurchaseApplicationEntity getModel(DataRow row) { FishEntity.PurchaseApplicationEntity model = new FishEntity.PurchaseApplicationEntity( ); if (row != null) { if (row ["id"] != null && row ["id"].ToString( ) != "") { model.id = int.Parse(row ["id"].ToString( )); } if (row ["codeNum"] != null) { model.codeNum = row ["codeNum"].ToString( ); } if (row ["codeNumContract"] != null) { model.codeNumContract = row ["codeNumContract"].ToString( ); } if (row ["supplier"] != null) { model.supplier = row ["supplier"].ToString( ); } if (row ["supplierAbb"] != null) { model.supplierAbb = row ["supplierAbb"].ToString( ); } if (row ["supplierUser"] != null) { model.supplierUser = row ["supplierUser"].ToString( ); } if (row ["buyer"] != null) { model.buyer = row ["buyer"].ToString( ); } if (row ["buyerAbb"] != null) { model.buyerAbb = row ["buyerAbb"].ToString( ); } if (row ["buyerUser"] != null) { model.buyerUser = row ["buyerUser"].ToString( ); } if (row ["signDate"] != null && row ["signDate"].ToString( ) != "") { model.signDate = DateTime.Parse(row ["signDate"].ToString( )); } if (row ["signAdd"] != null) { model.signAdd = row ["signAdd"].ToString( ); } if (row ["proName"] != null) { model.proName = row ["proName"].ToString( ); } if (row ["bondPro"] != null && row ["bondPro"].ToString( ) != "") { model.bondPro = decimal.Parse(row ["bondPro"].ToString( )); } if (row ["varieties"] != null) { model.varieties = row ["varieties"].ToString( ); } if (row ["quaSpe"] != null) { model.quaSpe = row ["quaSpe"].ToString( ); } if (row ["height"] != null && row ["height"].ToString( ) != "") { model.height = decimal.Parse(row ["height"].ToString( )); } if (row ["price"] != null && row ["price"].ToString( ) != "") { model.price = decimal.Parse(row ["price"].ToString( )); } if (row ["priceMY"] != null && row ["priceMY"].ToString( ) != "") { model.priceMY = decimal.Parse(row ["priceMY"].ToString( )); } if (row ["conutry"] != null) { model.conutry = row ["conutry"].ToString( ); } if (row ["brand"] != null) { model.brand = row ["brand"].ToString( ); } if (row ["shipName"] != null) { model.shipName = row ["shipName"].ToString( ); } if (row ["billNum"] != null) { model.billNum = row ["billNum"].ToString( ); } if (row ["shipDate"] != null && row ["shipDate"].ToString( ) != "") { model.shipDate = DateTime.Parse(row ["shipDate"].ToString( )); } if (row ["arriveDate"] != null && row ["arriveDate"].ToString( ) != "") { model.arriveDate = DateTime.Parse(row ["arriveDate"].ToString( )); } if (row ["deliveryDate"] != null && row ["deliveryDate"].ToString( ) != "") { model.deliveryDate = DateTime.Parse(row ["deliveryDate"].ToString( )); } if (row ["SGSDB"] != null) { model.SGSDB = row ["SGSDB"].ToString( ); } if (row ["SGSTVN"] != null) { model.SGSTVN = row ["SGSTVN"].ToString( ); } if (row ["SGSZA"] != null) { model.SGSZA = row ["SGSZA"].ToString( ); } if (row ["SGSZF"] != null) { model.SGSZF = row ["SGSZF"].ToString( ); } if (row ["SGSSF"] != null) { model.SGSSF = row ["SGSSF"].ToString( ); } if (row ["SGSSHY"] != null) { model.SGSSHY = row ["SGSSHY"].ToString( ); } if (row ["SGSS"] != null) { model.SGSS = row ["SGSS"].ToString( ); } if (row ["SGSSJ"] != null) { model.SGSSJ = row ["SGSSJ"].ToString( ); } if (row ["SGSHF"] != null) { model.SGSHF = row ["SGSHF"].ToString( ); } if (row ["deliveryAdd"] != null) { model.deliveryAdd = row ["deliveryAdd"].ToString( ); } if (row ["deliveryLast"] != null && row ["deliveryLast"].ToString( ) != "") { model.deliveryLast = DateTime.Parse(row ["deliveryLast"].ToString( )); } if (row ["fishId"] != null) { model.fishId = row ["fishId"].ToString( ); } if (row ["conProtein"] != null) { model.conProtein = row ["conProtein"].ToString( ); } if (row ["conTVN"] != null) { model.conTVN = row ["conTVN"].ToString( ); } if (row ["conZA"] != null) { model.conZA = row ["conZA"].ToString( ); } if (row ["conFFA"] != null) { model.conFFA = row ["conFFA"].ToString( ); } if (row ["conZF"] != null) { model.conZF = row ["conZF"].ToString( ); } if (row ["conSF"] != null) { model.conSF = row ["conSF"].ToString( ); } if (row ["conSHY"] != null) { model.conSHY = row ["conSHY"].ToString( ); } if (row ["conS"] != null) { model.conS = row ["conS"].ToString( ); } if (row ["conSJ"] != null) { model.conSJ = row ["conSJ"].ToString( ); } if (row ["conHF"] != null) { model.conHF = row ["conHF"].ToString( ); } if (row ["conLAS"] != null) { model.conLAS = row ["conLAS"].ToString( ); } if (row ["conDAS"] != null) { model.conDAS = row ["conDAS"].ToString( ); } if (row ["remark"] != null) { model.remark = row ["remark"].ToString( ); } } return(model); }
/// <summary> /// 新增数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Add(FishEntity.PurchaseApplicationEntity model) { StringBuilder strSql = new StringBuilder( ); strSql.Append("insert into t_purchaseapplication("); strSql.Append("codeNum,codeNumContract,supplier,supplierAbb,supplierUser,buyer,buyerAbb,buyerUser,signDate,signAdd,proName,bondPro,varieties,quaSpe,height,price,priceMY,conutry,brand,shipName,billNum,shipDate,arriveDate,deliveryDate,SGSDB,SGSTVN,SGSZA,SGSZF,SGSSF,SGSSHY,SGSS,SGSSJ,SGSHF,deliveryAdd,deliveryLast,fishId,conProtein,conTVN,conZA,conFFA,conZF,conSF,conSHY,conS,conSJ,conHF,conLAS,conDAS,remark)"); strSql.Append(" values ("); strSql.Append("@codeNum,@codeNumContract,@supplier,@supplierAbb,@supplierUser,@buyer,@buyerAbb,@buyerUser,@signDate,@signAdd,@proName,@bondPro,@varieties,@quaSpe,@height,@price,@priceMY,@conutry,@brand,@shipName,@billNum,@shipDate,@arriveDate,@deliveryDate,@SGSDB,@SGSTVN,@SGSZA,@SGSZF,@SGSSF,@SGSSHY,@SGSS,@SGSSJ,@SGSHF,@deliveryAdd,@deliveryLast,@fishId,@conProtein,@conTVN,@conZA,@conFFA,@conZF,@conSF,@conSHY,@conS,@conSJ,@conHF,@conLAS,@conDAS,@remark);select last_insert_id();"); MySqlParameter [] parameters = { new MySqlParameter("@codeNum", MySqlDbType.VarChar, 30), new MySqlParameter("@codeNumContract", MySqlDbType.VarChar, 30), new MySqlParameter("@supplier", MySqlDbType.VarChar, 50), new MySqlParameter("@supplierAbb", MySqlDbType.VarChar, 50), new MySqlParameter("@supplierUser", MySqlDbType.VarChar, 50), new MySqlParameter("@buyer", MySqlDbType.VarChar, 50), new MySqlParameter("@buyerAbb", MySqlDbType.VarChar, 50), new MySqlParameter("@buyerUser", MySqlDbType.VarChar, 50), new MySqlParameter("@signDate", MySqlDbType.DateTime), new MySqlParameter("@signAdd", MySqlDbType.VarChar, 100), new MySqlParameter("@proName", MySqlDbType.VarChar, 100), new MySqlParameter("@bondPro", MySqlDbType.Decimal, 18), new MySqlParameter("@varieties", MySqlDbType.VarChar, 50), new MySqlParameter("@quaSpe", MySqlDbType.VarChar, 50), new MySqlParameter("@height", MySqlDbType.Decimal, 18), new MySqlParameter("@price", MySqlDbType.Decimal, 18), new MySqlParameter("@priceMY", MySqlDbType.Decimal, 18), new MySqlParameter("@conutry", MySqlDbType.VarChar, 30), new MySqlParameter("@brand", MySqlDbType.VarChar, 30), new MySqlParameter("@shipName", MySqlDbType.VarChar, 50), new MySqlParameter("@billNum", MySqlDbType.VarChar, 50), new MySqlParameter("@shipDate", MySqlDbType.DateTime), new MySqlParameter("@arriveDate", MySqlDbType.DateTime), new MySqlParameter("@deliveryDate", MySqlDbType.DateTime), new MySqlParameter("@SGSDB", MySqlDbType.VarChar, 50), new MySqlParameter("@SGSTVN", MySqlDbType.VarChar, 50), new MySqlParameter("@SGSZA", MySqlDbType.VarChar, 50), new MySqlParameter("@SGSZF", MySqlDbType.VarChar, 50), new MySqlParameter("@SGSSF", MySqlDbType.VarChar, 50), new MySqlParameter("@SGSSHY", MySqlDbType.VarChar, 50), new MySqlParameter("@SGSS", MySqlDbType.VarChar, 50), new MySqlParameter("@SGSSJ", MySqlDbType.VarChar, 50), new MySqlParameter("@SGSHF", MySqlDbType.VarChar, 50), new MySqlParameter("@deliveryAdd", MySqlDbType.VarChar, 50), new MySqlParameter("@deliveryLast", MySqlDbType.DateTime), new MySqlParameter("@fishId", MySqlDbType.VarChar, 50), new MySqlParameter("@conProtein", MySqlDbType.VarChar, 50), new MySqlParameter("@conTVN", MySqlDbType.VarChar, 50), new MySqlParameter("@conZA", MySqlDbType.VarChar, 50), new MySqlParameter("@conFFA", MySqlDbType.VarChar, 50), new MySqlParameter("@conZF", MySqlDbType.VarChar, 50), new MySqlParameter("@conSF", MySqlDbType.VarChar, 50), new MySqlParameter("@conSHY", MySqlDbType.VarChar, 50), new MySqlParameter("@conS", MySqlDbType.VarChar, 50), new MySqlParameter("@conSJ", MySqlDbType.VarChar, 50), new MySqlParameter("@conHF", MySqlDbType.VarChar, 50), new MySqlParameter("@conLAS", MySqlDbType.VarChar, 50), new MySqlParameter("@conDAS", MySqlDbType.VarChar, 50), new MySqlParameter("@remark", MySqlDbType.VarChar, 255) }; parameters [0].Value = model.codeNum; parameters [1].Value = model.codeNumContract; parameters [2].Value = model.supplier; parameters [3].Value = model.supplierAbb; parameters [4].Value = model.supplierUser; parameters [5].Value = model.buyer; parameters [6].Value = model.buyerAbb; parameters [7].Value = model.buyerUser; parameters [8].Value = model.signDate; parameters [9].Value = model.signAdd; parameters [10].Value = model.proName; parameters [11].Value = model.bondPro; parameters [12].Value = model.varieties; parameters [13].Value = model.quaSpe; parameters [14].Value = model.height; parameters [15].Value = model.price; parameters [16].Value = model.priceMY; parameters [17].Value = model.conutry; parameters [18].Value = model.brand; parameters [19].Value = model.shipName; parameters [20].Value = model.billNum; parameters [21].Value = model.shipDate; parameters [22].Value = model.arriveDate; parameters [23].Value = model.deliveryDate; parameters [24].Value = model.SGSDB; parameters [25].Value = model.SGSTVN; parameters [26].Value = model.SGSZA; parameters [27].Value = model.SGSZF; parameters [28].Value = model.SGSSF; parameters [29].Value = model.SGSSHY; parameters [30].Value = model.SGSS; parameters [31].Value = model.SGSSJ; parameters [32].Value = model.SGSHF; parameters [33].Value = model.deliveryAdd; parameters [34].Value = model.deliveryLast; parameters [35].Value = model.fishId; parameters [36].Value = model.conProtein; parameters [37].Value = model.conTVN; parameters [38].Value = model.conZA; parameters [39].Value = model.conFFA; parameters [40].Value = model.conZF; parameters [41].Value = model.conSF; parameters [42].Value = model.conSHY; parameters [43].Value = model.conS; parameters [44].Value = model.conSJ; parameters [45].Value = model.conHF; parameters [46].Value = model.conLAS; parameters [47].Value = model.conDAS; parameters [48].Value = model.remark; return(MySqlHelper.ExecuteSqlReturnId(strSql.ToString( ), parameters)); }