public int Add(FishEntity.PurchaseRequisitionEntity model) { StringBuilder strsql = new StringBuilder(); strsql.Append("insert into t_purchaserequisition(ContractNo,supplier,SupplierId,DemandSide,DemandSideId,DateOfSigni,PlaceOfSign,ProductName,Unit,FishmealId,Variety,Quantity,NameOfTheShip,BillOfLadingNumber,DemandSideShort,SupplierAbbreviation,Ash,HTprotein,HTTVB,HTHistamine,HTFFA,HTFat,HTMoisture,HTSandAndSalt,HTSand,HTUnit,HTAsh,Lysine,Methionine,UnitPrice,AmountOfMoney,Protein,TVN,Histamine,FFA,Fat,Moisture,SandAndSalt,Sand,Rebate,USDollarPrice,Country,Brand,TradingLocations,TimeOfShipment,ExpectedDate,modifyman,modifytime,createman,createtime,Numbering,Openbank,accountnumber,Purchasingcontacts,deliverytime,PurchasingcontactsId,Remarks,Specification,MJAmount,validate)"); strsql.Append("values(@ContractNo,@supplier,@SupplierId,@DemandSide,@DemandSideId,@DateOfSigni,@PlaceOfSign,@ProductName,@Unit,@FishmealId,@Variety,@Quantity,@NameOfTheShip,@BillOfLadingNumber,@DemandSideShort,@SupplierAbbreviation,@Ash,@HTprotein,@HTTVB,@HTHistamine,@HTFFA,@HTFat,@HTMoisture,@HTSandAndSalt,@HTSand,@HTUnit,@HTAsh,@Lysine,@Methionine,@UnitPrice,@AmountOfMoney,@Protein,@TVN,@Histamine,@FFA,@Fat,@Moisture,@SandAndSalt,@Sand,@Rebate,@USDollarPrice,@Country,@Brand,@TradingLocations,@TimeOfShipment,@ExpectedDate,@modifyman,@modifytime,@createman,@createtime,@Numbering,@Openbank,@accountnumber,@Purchasingcontacts,@deliverytime,@PurchasingcontactsId,@Remarks,@Specification,@MJAmount,@validate)"); MySqlParameter[] parameter = { new MySqlParameter("@ContractNo", MySqlDbType.VarChar, 45), new MySqlParameter("@supplier", MySqlDbType.VarChar, 45), new MySqlParameter("@DemandSide", MySqlDbType.VarChar, 45), new MySqlParameter("@DateOfSigni", MySqlDbType.DateTime), new MySqlParameter("@PlaceOfSign", MySqlDbType.VarChar, 45), new MySqlParameter("@ProductName", MySqlDbType.VarChar, 45), new MySqlParameter("@Unit", MySqlDbType.VarChar, 45), new MySqlParameter("@Variety", MySqlDbType.VarChar, 45), new MySqlParameter("@Quantity", MySqlDbType.VarChar, 45), new MySqlParameter("@UnitPrice", MySqlDbType.VarChar, 45), new MySqlParameter("@AmountOfMoney", MySqlDbType.VarChar, 45), new MySqlParameter("@Protein", MySqlDbType.VarChar, 45), new MySqlParameter("@TVN", MySqlDbType.VarChar, 45), new MySqlParameter("@Histamine", MySqlDbType.VarChar, 45), new MySqlParameter("@FFA", MySqlDbType.VarChar, 45), new MySqlParameter("@Fat", MySqlDbType.VarChar, 45), new MySqlParameter("@Moisture", MySqlDbType.VarChar, 45), new MySqlParameter("@SandAndSalt", MySqlDbType.VarChar, 45), new MySqlParameter("@Sand", MySqlDbType.VarChar, 45), new MySqlParameter("@Rebate", MySqlDbType.VarChar, 45), new MySqlParameter("@USDollarPrice", MySqlDbType.VarChar, 45), new MySqlParameter("@Country", MySqlDbType.VarChar, 45), new MySqlParameter("@TradingLocations", MySqlDbType.VarChar, 45), new MySqlParameter("@TimeOfShipment", MySqlDbType.DateTime), new MySqlParameter("@ExpectedDate", MySqlDbType.DateTime), new MySqlParameter("@createman", MySqlDbType.VarChar, 45), new MySqlParameter("@createtime", MySqlDbType.Timestamp), new MySqlParameter("@modifyman", MySqlDbType.VarChar, 45), new MySqlParameter("@modifytime", MySqlDbType.Timestamp), new MySqlParameter("@Numbering", MySqlDbType.VarChar, 45), new MySqlParameter("@Openbank", MySqlDbType.VarChar, 100), new MySqlParameter("@accountnumber", MySqlDbType.VarChar, 100), new MySqlParameter("@Purchasingcontacts", MySqlDbType.VarChar, 45), new MySqlParameter("@deliverytime", MySqlDbType.DateTime), new MySqlParameter("@SupplierId", MySqlDbType.VarChar, 45), new MySqlParameter("@DemandSideId", MySqlDbType.VarChar, 45), new MySqlParameter("@PurchasingcontactsId", MySqlDbType.VarChar, 45), new MySqlParameter("@FishmealId", MySqlDbType.VarChar, 45), new MySqlParameter("@Brand", MySqlDbType.VarChar, 45), new MySqlParameter("@Remarks", MySqlDbType.VarChar, 500), new MySqlParameter("@NameOfTheShip", MySqlDbType.VarChar, 45), new MySqlParameter("@BillOfLadingNumber", MySqlDbType.VarChar, 45), new MySqlParameter("@DemandSideShort", MySqlDbType.VarChar, 45), new MySqlParameter("@SupplierAbbreviation", MySqlDbType.VarChar, 45), new MySqlParameter("@Ash", MySqlDbType.VarChar, 45), new MySqlParameter("@HTprotein", MySqlDbType.VarChar, 45), new MySqlParameter("@HTTVB", MySqlDbType.VarChar, 45), new MySqlParameter("@HTHistamine", MySqlDbType.VarChar, 45), new MySqlParameter("@HTFFA", MySqlDbType.VarChar, 45), new MySqlParameter("@HTFat", MySqlDbType.VarChar, 45), new MySqlParameter("@HTMoisture", MySqlDbType.VarChar, 45), new MySqlParameter("@HTSandAndSalt", MySqlDbType.VarChar, 45), new MySqlParameter("@HTSand", MySqlDbType.VarChar, 45), new MySqlParameter("@HTUnit", MySqlDbType.VarChar, 45), new MySqlParameter("@HTAsh", MySqlDbType.VarChar, 45), new MySqlParameter("@Lysine", MySqlDbType.VarChar, 45), new MySqlParameter("@Methionine", MySqlDbType.VarChar, 45), new MySqlParameter("@Specification", MySqlDbType.VarChar, 45), new MySqlParameter("@MJAmount", MySqlDbType.VarChar, 45), new MySqlParameter("@validate", MySqlDbType.VarChar, 45) }; parameter[0].Value = model.ContractNo; parameter[1].Value = model.Supplier; parameter[2].Value = model.DemandSide; parameter[3].Value = model.DateOfSigni; parameter[4].Value = model.PlaceOfSign; parameter[5].Value = model.ProductName; parameter[6].Value = model.Unit; parameter[7].Value = model.Variety; parameter[8].Value = model.Quantity; parameter[9].Value = model.UnitPrice; parameter[10].Value = model.AmountOfMoney; parameter[11].Value = model.Protein; parameter[12].Value = model.TVN; parameter[13].Value = model.Histamine; parameter[14].Value = model.FFA; parameter[15].Value = model.Fat; parameter[16].Value = model.Moisture; parameter[17].Value = model.SandAndSalt; parameter[18].Value = model.Sand; parameter[19].Value = model.Rebate; parameter[20].Value = model.USDollarPrice; parameter[21].Value = model.Country; parameter[22].Value = model.TradingLocations; parameter[23].Value = model.TimeOfShipment; parameter[24].Value = model.ExpectedDate; parameter[25].Value = model.Createman; parameter[26].Value = model.Createtime; parameter[27].Value = model.Modifyman; parameter[28].Value = model.Modifytime; parameter[29].Value = model.Numbering; parameter[30].Value = model.Openbank; parameter[31].Value = model.Accountnumber; parameter[32].Value = model.Purchasingcontacts; parameter[33].Value = model.Deliverytime; parameter[34].Value = model.SupplierId; parameter[35].Value = model.DemandSideId; parameter[36].Value = model.PurchasingcontactsId; parameter[37].Value = model.FishmealId; parameter[38].Value = model.Brand; parameter[39].Value = model.Remarks; parameter[40].Value = model.NameOfTheShip; parameter[41].Value = model.BillOfLadingNumber; parameter[42].Value = model.DemandSideShort; parameter[43].Value = model.SupplierAbbreviation; parameter[44].Value = model.Ash; parameter[45].Value = model.HTprotein; parameter[46].Value = model.HTTVB; parameter[47].Value = model.HTHistamine; parameter[48].Value = model.HTFFA; parameter[49].Value = model.HTFat; parameter[50].Value = model.HTMoisture; parameter[51].Value = model.HTSandAndSalt; parameter[52].Value = model.HTSand; parameter[53].Value = model.HTUnit; parameter[54].Value = model.HTAsh; parameter[55].Value = model.Lysine; parameter[56].Value = model.Methionine; parameter[57].Value = model.Specification; parameter[58].Value = model.MJAmount; parameter[59].Value = model.validate; int id = MySqlHelper.ExecuteSql(strsql.ToString(), parameter); return(id); }
public bool Update(FishEntity.PurchaseRequisitionEntity model) { StringBuilder strsql = new StringBuilder(); strsql.Append("update t_purchaserequisition set "); strsql.Append("supplier = @supplier,"); strsql.Append("ContractNo=@ContractNo,"); strsql.Append("SupplierId = @SupplierId,"); strsql.Append("DemandSide = @DemandSide,"); strsql.Append("DemandSideId = @DemandSideId,"); strsql.Append("DateOfSigni = @DateOfSigni,"); strsql.Append("PlaceOfSign = @PlaceOfSign,"); strsql.Append("ProductName = @ProductName,"); strsql.Append("Unit = @Unit,"); strsql.Append("FishmealId=@FishmealId,"); strsql.Append("Variety = @Variety,"); strsql.Append("Quantity = @Quantity,"); strsql.Append("NameOfTheShip = @NameOfTheShip,"); strsql.Append("BillOfLadingNumber = @BillOfLadingNumber,"); strsql.Append("DemandSideShort = @DemandSideShort,"); strsql.Append("SupplierAbbreviation = @SupplierAbbreviation,"); strsql.Append("Ash = @Ash,"); strsql.Append("HTprotein = @HTprotein,"); strsql.Append("HTTVB = @HTTVB,"); strsql.Append("HTHistamine = @HTHistamine,"); strsql.Append("HTFFA = @HTFFA,"); strsql.Append("HTFat = @HTFat,"); strsql.Append("HTMoisture = @HTMoisture,"); strsql.Append("HTSandAndSalt = @HTSandAndSalt,"); strsql.Append("HTSand = @HTSand,"); strsql.Append("HTUnit = @HTUnit,"); strsql.Append("HTAsh = @HTAsh,"); strsql.Append("Lysine = @Lysine,"); strsql.Append("Methionine = @Methionine,"); strsql.Append("Specification=@Specification,"); strsql.Append("MJAmount=@MJAmount,"); strsql.Append("UnitPrice = @UnitPrice,"); strsql.Append("AmountOfMoney = @AmountOfMoney,"); strsql.Append("Protein = @Protein,"); strsql.Append("TVN = @TVN,"); strsql.Append("Histamine = @Histamine,"); strsql.Append("FFA = @FFA,"); strsql.Append("Fat = @Fat,"); strsql.Append("Moisture = @Moisture,"); strsql.Append("SandAndSalt = @SandAndSalt,"); strsql.Append("Sand = @Sand,"); strsql.Append("Rebate = @Rebate,"); strsql.Append("USDollarPrice = @USDollarPrice,"); strsql.Append("Country = @Country,"); strsql.Append("validate=@validate,"); strsql.Append("Brand=@Brand,"); strsql.Append("TradingLocations = @TradingLocations,"); strsql.Append("TimeOfShipment = @TimeOfShipment,"); strsql.Append("ExpectedDate = @ExpectedDate, "); strsql.Append("modifyman=@modifyman,"); strsql.Append("modifytime=@modifytime, "); strsql.Append("Numbering=@Numbering, "); strsql.Append("Openbank=@Openbank, "); strsql.Append("accountnumber=@accountnumber, "); strsql.Append("Purchasingcontacts=@Purchasingcontacts,"); strsql.Append("PurchasingcontactsId=@PurchasingcontactsId,"); strsql.Append("deliverytime=@deliverytime,"); strsql.Append("Remarks=@Remarks "); strsql.Append("where id = @id"); MySqlParameter[] parameter = { new MySqlParameter("@supplier", MySqlDbType.VarChar, 45), new MySqlParameter("@DemandSide", MySqlDbType.VarChar, 45), new MySqlParameter("@DateOfSigni", MySqlDbType.DateTime), new MySqlParameter("@PlaceOfSign", MySqlDbType.VarChar, 45), new MySqlParameter("@ProductName", MySqlDbType.VarChar, 45), new MySqlParameter("@Unit", MySqlDbType.VarChar, 45), new MySqlParameter("@Variety", MySqlDbType.VarChar, 45), new MySqlParameter("@Quantity", MySqlDbType.VarChar, 45), new MySqlParameter("@UnitPrice", MySqlDbType.VarChar, 45), new MySqlParameter("@AmountOfMoney", MySqlDbType.VarChar, 45), new MySqlParameter("@Protein", MySqlDbType.VarChar, 45), new MySqlParameter("@TVN", MySqlDbType.VarChar, 45), new MySqlParameter("@Histamine", MySqlDbType.VarChar, 45), new MySqlParameter("@FFA", MySqlDbType.VarChar, 45), new MySqlParameter("@Fat", MySqlDbType.VarChar, 45), new MySqlParameter("@Moisture", MySqlDbType.VarChar, 45), new MySqlParameter("@SandAndSalt", MySqlDbType.VarChar, 45), new MySqlParameter("@Sand", MySqlDbType.VarChar, 45), new MySqlParameter("@Rebate", MySqlDbType.VarChar, 45), new MySqlParameter("@USDollarPrice", MySqlDbType.VarChar, 45), new MySqlParameter("@Country", MySqlDbType.VarChar, 45), new MySqlParameter("@TradingLocations", MySqlDbType.VarChar, 45), new MySqlParameter("@TimeOfShipment", MySqlDbType.DateTime), new MySqlParameter("@ExpectedDate", MySqlDbType.DateTime), new MySqlParameter("@modifyman", MySqlDbType.VarChar, 45), new MySqlParameter("@modifytime", MySqlDbType.Timestamp), new MySqlParameter("@Numbering", MySqlDbType.VarChar, 45), new MySqlParameter("@Openbank", MySqlDbType.VarChar, 100), new MySqlParameter("@accountnumber", MySqlDbType.VarChar, 100), new MySqlParameter("@id", MySqlDbType.Int32, 11), new MySqlParameter("@deliverytime", MySqlDbType.DateTime), new MySqlParameter("@SupplierId", MySqlDbType.VarChar, 45), new MySqlParameter("@Purchasingcontacts", MySqlDbType.VarChar, 45), new MySqlParameter("@DemandSideId", MySqlDbType.VarChar, 45), new MySqlParameter("@PurchasingcontactsId", MySqlDbType.VarChar, 45), new MySqlParameter("@FishmealId", MySqlDbType.VarChar, 45), new MySqlParameter("@Brand", MySqlDbType.VarChar, 45), new MySqlParameter("@Remarks", MySqlDbType.VarChar, 500), new MySqlParameter("@ContractNo", MySqlDbType.VarChar, 45), new MySqlParameter("@NameOfTheShip", MySqlDbType.VarChar, 45), new MySqlParameter("@BillOfLadingNumber", MySqlDbType.VarChar, 45), new MySqlParameter("@DemandSideShort", MySqlDbType.VarChar, 45), new MySqlParameter("@SupplierAbbreviation", MySqlDbType.VarChar, 45), new MySqlParameter("@Ash", MySqlDbType.VarChar, 45), new MySqlParameter("@HTprotein", MySqlDbType.VarChar, 45), new MySqlParameter("@HTTVB", MySqlDbType.VarChar, 45), new MySqlParameter("@HTHistamine", MySqlDbType.VarChar, 45), new MySqlParameter("@HTFFA", MySqlDbType.VarChar, 45), new MySqlParameter("@HTFat", MySqlDbType.VarChar, 45), new MySqlParameter("@HTMoisture", MySqlDbType.VarChar, 45), new MySqlParameter("@HTSandAndSalt", MySqlDbType.VarChar, 45), new MySqlParameter("@HTSand", MySqlDbType.VarChar, 45), new MySqlParameter("@HTUnit", MySqlDbType.VarChar, 45), new MySqlParameter("@HTAsh", MySqlDbType.VarChar, 45), new MySqlParameter("@Lysine", MySqlDbType.VarChar, 45), new MySqlParameter("@Methionine", MySqlDbType.VarChar, 45), new MySqlParameter("@Specification", MySqlDbType.VarChar, 45), new MySqlParameter("@MJAmount", MySqlDbType.VarChar, 45), new MySqlParameter("@validate", MySqlDbType.VarChar, 45) }; parameter[0].Value = model.Supplier; parameter[1].Value = model.DemandSide; parameter[2].Value = model.DateOfSigni; parameter[3].Value = model.PlaceOfSign; parameter[4].Value = model.ProductName; parameter[5].Value = model.Unit; parameter[6].Value = model.Variety; parameter[7].Value = model.Quantity; parameter[8].Value = model.UnitPrice; parameter[9].Value = model.AmountOfMoney; parameter[10].Value = model.Protein; parameter[11].Value = model.TVN; parameter[12].Value = model.Histamine; parameter[13].Value = model.FFA; parameter[14].Value = model.Fat; parameter[15].Value = model.Moisture; parameter[16].Value = model.SandAndSalt; parameter[17].Value = model.Sand; parameter[18].Value = model.Rebate; parameter[19].Value = model.USDollarPrice; parameter[20].Value = model.Country; parameter[21].Value = model.TradingLocations; parameter[22].Value = model.TimeOfShipment; parameter[23].Value = model.ExpectedDate; parameter[24].Value = model.Modifyman; parameter[25].Value = model.Modifytime; parameter[26].Value = model.Numbering; parameter[27].Value = model.Openbank; parameter[28].Value = model.Accountnumber; parameter[29].Value = model.Id; parameter[30].Value = model.Deliverytime; parameter[31].Value = model.SupplierId; parameter[32].Value = model.Purchasingcontacts; parameter[33].Value = model.DemandSideId; parameter[34].Value = model.PurchasingcontactsId; parameter[35].Value = model.FishmealId; parameter[36].Value = model.Brand; parameter[37].Value = model.Remarks; parameter[38].Value = model.ContractNo; parameter[39].Value = model.NameOfTheShip; parameter[40].Value = model.BillOfLadingNumber; parameter[41].Value = model.DemandSideShort; parameter[42].Value = model.SupplierAbbreviation; parameter[43].Value = model.Ash; parameter[44].Value = model.HTprotein; parameter[45].Value = model.HTTVB; parameter[46].Value = model.HTHistamine; parameter[47].Value = model.HTFFA; parameter[48].Value = model.HTFat; parameter[49].Value = model.HTMoisture; parameter[50].Value = model.HTSandAndSalt; parameter[51].Value = model.HTSand; parameter[52].Value = model.HTUnit; parameter[53].Value = model.HTAsh; parameter[54].Value = model.Lysine; parameter[55].Value = model.Methionine; parameter[56].Value = model.Specification; parameter[57].Value = model.MJAmount; parameter[58].Value = model.validate; int row = MySqlHelper.ExecuteSql(strsql.ToString(), parameter); if (row > 0) { return(true); } else { return(false); } }