public bool UpdateCheckRecord(FishEntity.CheckRecordEntity model) { StringBuilder strSql = new StringBuilder(); strSql.Append(" update t_product set "); strSql.Append("domestic_protein=@domestic_protein,"); strSql.Append("domestic_tvn=@domestic_tvn,"); strSql.Append("domestic_graypart=@domestic_graypart,"); strSql.Append("domestic_sandsalt=@domestic_sandsalt,"); strSql.Append("domestic_sour=@domestic_sour,"); strSql.Append("domestic_lysine=@domestic_lysine,"); strSql.Append("domestic_methionine=@domestic_methionine,"); strSql.Append("domestic_amine=@domestic_amine,"); strSql.Append("domestic_aminototal=@domestic_aminototal,"); strSql.Append("domestic_fat=@domestic_fat,"); strSql.Append("samplingtime=@samplingtime"); strSql.Append(" where id=@id"); MySqlParameter[] parameters = { new MySqlParameter("@domestic_protein", MySqlDbType.Decimal, 6), new MySqlParameter("@domestic_tvn", MySqlDbType.Decimal, 8), new MySqlParameter("@domestic_graypart", MySqlDbType.Decimal, 6), new MySqlParameter("@domestic_sandsalt", MySqlDbType.Decimal, 6), new MySqlParameter("@domestic_sour", MySqlDbType.Decimal, 6), new MySqlParameter("@domestic_lysine", MySqlDbType.Decimal, 6), new MySqlParameter("@domestic_methionine", MySqlDbType.Decimal, 6), new MySqlParameter("@domestic_amine", MySqlDbType.Decimal, 6), new MySqlParameter("@domestic_aminototal", MySqlDbType.Decimal, 6), new MySqlParameter("@domestic_fat", MySqlDbType.Decimal, 6), new MySqlParameter("@samplingtime", MySqlDbType.VarChar, 45), new MySqlParameter("@id", MySqlDbType.Int32, 11) }; parameters[0].Value = model.regularindex1; parameters[1].Value = model.regularindex2; parameters[2].Value = model.regularindex4; parameters[3].Value = model.regularindex6; parameters[4].Value = model.regularindex5; parameters[5].Value = model.aminoindex14; parameters[6].Value = model.aminoindex9; parameters[7].Value = model.regularindex3; parameters[8].Value = model.aminoindex19; parameters[9].Value = model.regularindex8; parameters[10].Value = model.checkdate; parameters[11].Value = model.productid; int rows = MySqlHelper.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public FishEntity.CheckRecordEntity GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select id,productid,productcode,productname,recordno,checkdate,testdate,testcompanyid,testcompanycode,testcompanyname,Digestibility,regularindex1,regularindex2,regularindex3,regularindex4,regularindex5,regularindex6,regularindex7,regularindex8,regularindex9,regularindex10,regularindex11,regularindex12,aminoindex1,aminoindex2,aminoindex3,aminoindex4,aminoindex5,aminoindex6,aminoindex7,aminoindex8,aminoindex9,aminoindex10,aminoindex11,aminoindex12,aminoindex13,aminoindex14,aminoindex15,aminoindex16,aminoindex17,aminoindex18,aminoindex19,aminoindex20,aminoindex21,aminoindex22,aminoindex23,specialindex1,specialindex2,specialindex3,specialindex4,specialindex5,fee,sendsamplename,describe1 from t_checkrecord "); strSql.Append(" where id=@id"); MySqlParameter[] parameters = { new MySqlParameter("@id", MySqlDbType.Int32) }; parameters[0].Value = id; FishEntity.CheckRecordEntity model = new FishEntity.CheckRecordEntity(); DataSet ds = MySqlHelper.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
public override void Save() { if (Check() == false) { return; } int startcol = 3; int startrow = 0; DateTime lateDate = DateTime.MinValue; FishEntity.CheckRecordEntity lateRecord = null; for (int i = 0; i < 6; i++) { FishEntity.CheckRecordEntity vo = null;// new FishEntity.CheckRecordEntity(); if (_records == null || _records.Count < 1) { vo = new FishEntity.CheckRecordEntity(); vo.recordno = i + 1; vo.productid = _productId; vo.productcode = _productCode; vo.productname = _productName; } else { vo = _records.Find((m) => { return(m.recordno == (i + 1)); }); if (vo == null) { vo = new FishEntity.CheckRecordEntity(); vo.recordno = i + 1; vo.productid = _productId; vo.productcode = _productCode; vo.productname = _productName; } } vo.checkdate = GetString(startcol + i, startrow); vo.testdate = GetString(startcol + i, startrow + 1); int companyid = 0; string companyname = string.Empty; string sends = string.Empty; GetValue(startcol + i, startrow + 2, ref companyid, ref sends); GetValue(startcol + i, startrow + 3, ref companyid, ref companyname); vo.testcompanyid = companyid; vo.testcompanyname = companyname; vo.Sendsamplename = sends; vo.regularindex1 = GetDecimalNull(startcol + i, startrow + 7); vo.regularindex2 = GetDecimalNull(startcol + i, startrow + 8); vo.regularindex3 = GetDecimalNull(startcol + i, startrow + 9); vo.regularindex4 = GetDecimalNull(startcol + i, startrow + 10); vo.regularindex5 = GetDecimalNull(startcol + i, startrow + 11); vo.regularindex6 = GetDecimalNull(startcol + i, startrow + 12); vo.regularindex7 = GetDecimalNull(startcol + i, startrow + 13); vo.regularindex8 = GetDecimalNull(startcol + i, startrow + 14); vo.Digestibility = GetDecimalNull(startcol + i, startrow + 15); vo.aminoindex1 = GetDecimalNull(startcol + i, startrow + 16); vo.aminoindex2 = GetDecimalNull(startcol + i, startrow + 17); vo.aminoindex3 = GetDecimalNull(startcol + i, startrow + 18); vo.aminoindex4 = GetDecimalNull(startcol + i, startrow + 19); vo.aminoindex5 = GetDecimalNull(startcol + i, startrow + 20); vo.aminoindex6 = GetDecimalNull(startcol + i, startrow + 21); vo.aminoindex7 = GetDecimalNull(startcol + i, startrow + 22); vo.aminoindex8 = GetDecimalNull(startcol + i, startrow + 23); vo.aminoindex9 = GetDecimalNull(startcol + i, startrow + 24); vo.aminoindex10 = GetDecimalNull(startcol + i, startrow + 25); vo.aminoindex11 = GetDecimalNull(startcol + i, startrow + 26); vo.aminoindex12 = GetDecimalNull(startcol + i, startrow + 27); vo.aminoindex13 = GetDecimalNull(startcol + i, startrow + 28); vo.aminoindex14 = GetDecimalNull(startcol + i, startrow + 29); vo.aminoindex15 = GetDecimalNull(startcol + i, startrow + 30); vo.aminoindex16 = GetDecimalNull(startcol + i, startrow + 31); vo.aminoindex17 = GetDecimalNull(startcol + i, startrow + 32); vo.aminoindex18 = GetDecimalNull(startcol + i, startrow + 33); vo.aminoindex19 = GetDecimalNull(startcol + i, startrow + 34); vo.specialindex1 = GetString(startcol + i, startrow + 35); vo.fee = GetDecimalNull(startcol + i, startrow + 36); vo.Describe = GetString(startcol + i, startrow + 37); if (vo.id > 0) { bool isUpdate = _bll.Update(vo); } else { int id = _bll.Add(vo); vo.id = id; if (_records == null) { _records = new List <FishEntity.CheckRecordEntity>(); } _records.Add(vo); } DateTime tempDate = DateTime.MinValue; if (DateTime.TryParseExact(vo.checkdate, "yyyy.MM.dd", null, System.Globalization.DateTimeStyles.None, out tempDate)) { if (lateDate < tempDate) { lateDate = tempDate; lateRecord = vo; } } } //更新鱼粉的 国检指标,和送样日期 if (lateRecord != null) { FishBll.Bll.ProductBll productBll = new FishBll.Bll.ProductBll(); productBll.UpdateCheckRecord(lateRecord); } MessageBox.Show("保存成功。"); if (RefreshDataEvent != null) { RefreshDataEvent(this, EventArgs.Empty); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(FishEntity.CheckRecordEntity model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(FishEntity.CheckRecordEntity model) { return(dal.Add(model)); }
public bool UpdateCheckRecord(FishEntity.CheckRecordEntity vo) { return(dal.UpdateCheckRecord(vo)); }
/// <summary> /// 得到一个对象实体 /// </summary> public FishEntity.CheckRecordEntity DataRowToModel(DataRow row) { FishEntity.CheckRecordEntity model = new FishEntity.CheckRecordEntity(); if (row != null) { if (row["id"] != null && row["id"].ToString() != "") { model.id = int.Parse(row["id"].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["productname"] != null) { model.productname = row["productname"].ToString(); } if (row["recordno"] != null && row["recordno"].ToString() != "") { model.recordno = int.Parse(row["recordno"].ToString()); } if (row["checkdate"] != null) { model.checkdate = row["checkdate"].ToString(); } if (row["testdate"] != null) { model.testdate = row["testdate"].ToString(); } if (row["testcompanyid"] != null && row["testcompanyid"].ToString() != "") { model.testcompanyid = int.Parse(row["testcompanyid"].ToString()); } if (row["testcompanycode"] != null) { model.testcompanycode = row["testcompanycode"].ToString(); } if (row["testcompanyname"] != null) { model.testcompanyname = row["testcompanyname"].ToString(); } if (row["Digestibility"] != null && row["Digestibility"].ToString() != "") { model.Digestibility = decimal.Parse(row["Digestibility"].ToString()); } if (row["regularindex1"] != null && row["regularindex1"].ToString() != "") { model.regularindex1 = decimal.Parse(row["regularindex1"].ToString()); } if (row["regularindex2"] != null && row["regularindex2"].ToString() != "") { model.regularindex2 = decimal.Parse(row["regularindex2"].ToString()); } if (row["regularindex3"] != null && row["regularindex3"].ToString() != "") { model.regularindex3 = decimal.Parse(row["regularindex3"].ToString()); } if (row["regularindex4"] != null && row["regularindex4"].ToString() != "") { model.regularindex4 = decimal.Parse(row["regularindex4"].ToString()); } if (row["regularindex5"] != null && row["regularindex5"].ToString() != "") { model.regularindex5 = decimal.Parse(row["regularindex5"].ToString()); } if (row["regularindex6"] != null && row["regularindex6"].ToString() != "") { model.regularindex6 = decimal.Parse(row["regularindex6"].ToString()); } if (row["regularindex7"] != null && row["regularindex7"].ToString() != "") { model.regularindex7 = decimal.Parse(row["regularindex7"].ToString()); } if (row["regularindex8"] != null && row["regularindex8"].ToString() != "") { model.regularindex8 = decimal.Parse(row["regularindex8"].ToString()); } if (row["regularindex9"] != null && row["regularindex9"].ToString() != "") { model.regularindex9 = decimal.Parse(row["regularindex9"].ToString()); } if (row["regularindex10"] != null && row["regularindex10"].ToString() != "") { model.regularindex10 = decimal.Parse(row["regularindex10"].ToString()); } if (row["regularindex11"] != null && row["regularindex11"].ToString() != "") { model.regularindex11 = decimal.Parse(row["regularindex11"].ToString()); } if (row["regularindex12"] != null && row["regularindex12"].ToString() != "") { model.regularindex12 = decimal.Parse(row["regularindex12"].ToString()); } if (row["aminoindex1"] != null && row["aminoindex1"].ToString() != "") { model.aminoindex1 = decimal.Parse(row["aminoindex1"].ToString()); } if (row["aminoindex2"] != null && row["aminoindex2"].ToString() != "") { model.aminoindex2 = decimal.Parse(row["aminoindex2"].ToString()); } if (row["aminoindex3"] != null && row["aminoindex3"].ToString() != "") { model.aminoindex3 = decimal.Parse(row["aminoindex3"].ToString()); } if (row["aminoindex4"] != null && row["aminoindex4"].ToString() != "") { model.aminoindex4 = decimal.Parse(row["aminoindex4"].ToString()); } if (row["aminoindex5"] != null && row["aminoindex5"].ToString() != "") { model.aminoindex5 = decimal.Parse(row["aminoindex5"].ToString()); } if (row["aminoindex6"] != null && row["aminoindex6"].ToString() != "") { model.aminoindex6 = decimal.Parse(row["aminoindex6"].ToString()); } if (row["aminoindex7"] != null && row["aminoindex7"].ToString() != "") { model.aminoindex7 = decimal.Parse(row["aminoindex7"].ToString()); } if (row["aminoindex8"] != null && row["aminoindex8"].ToString() != "") { model.aminoindex8 = decimal.Parse(row["aminoindex8"].ToString()); } if (row["aminoindex9"] != null && row["aminoindex9"].ToString() != "") { model.aminoindex9 = decimal.Parse(row["aminoindex9"].ToString()); } if (row["aminoindex10"] != null && row["aminoindex10"].ToString() != "") { model.aminoindex10 = decimal.Parse(row["aminoindex10"].ToString()); } if (row["aminoindex11"] != null && row["aminoindex11"].ToString() != "") { model.aminoindex11 = decimal.Parse(row["aminoindex11"].ToString()); } if (row["aminoindex12"] != null && row["aminoindex12"].ToString() != "") { model.aminoindex12 = decimal.Parse(row["aminoindex12"].ToString()); } if (row["aminoindex13"] != null && row["aminoindex13"].ToString() != "") { model.aminoindex13 = decimal.Parse(row["aminoindex13"].ToString()); } if (row["aminoindex14"] != null && row["aminoindex14"].ToString() != "") { model.aminoindex14 = decimal.Parse(row["aminoindex14"].ToString()); } if (row["aminoindex15"] != null && row["aminoindex15"].ToString() != "") { model.aminoindex15 = decimal.Parse(row["aminoindex15"].ToString()); } if (row["aminoindex16"] != null && row["aminoindex16"].ToString() != "") { model.aminoindex16 = decimal.Parse(row["aminoindex16"].ToString()); } if (row["aminoindex17"] != null && row["aminoindex17"].ToString() != "") { model.aminoindex17 = decimal.Parse(row["aminoindex17"].ToString()); } if (row["aminoindex18"] != null && row["aminoindex18"].ToString() != "") { model.aminoindex18 = decimal.Parse(row["aminoindex18"].ToString()); } if (row["aminoindex19"] != null && row["aminoindex19"].ToString() != "") { model.aminoindex19 = decimal.Parse(row["aminoindex19"].ToString()); } if (row["aminoindex20"] != null && row["aminoindex20"].ToString() != "") { model.aminoindex20 = decimal.Parse(row["aminoindex20"].ToString()); } if (row["aminoindex21"] != null && row["aminoindex21"].ToString() != "") { model.aminoindex21 = decimal.Parse(row["aminoindex21"].ToString()); } if (row["aminoindex22"] != null && row["aminoindex22"].ToString() != "") { model.aminoindex22 = decimal.Parse(row["aminoindex22"].ToString()); } if (row["aminoindex23"] != null && row["aminoindex23"].ToString() != "") { model.aminoindex23 = decimal.Parse(row["aminoindex23"].ToString()); } if (row["specialindex1"] != null) { model.specialindex1 = row["specialindex1"].ToString(); } if (row["specialindex2"] != null) { model.specialindex2 = row["specialindex2"].ToString(); } if (row["specialindex3"] != null) { model.specialindex3 = row["specialindex3"].ToString(); } if (row["specialindex4"] != null) { model.specialindex4 = row["specialindex4"].ToString(); } if (row["specialindex5"] != null) { model.specialindex5 = row["specialindex5"].ToString(); } if (row["fee"] != null && row["fee"].ToString() != "") { model.fee = decimal.Parse(row["fee"].ToString()); } if (row["sendsamplename"] != null) { model.Sendsamplename = row["sendsamplename"].ToString(); } if (row["describe1"] != null) { model.Describe = row["describe1"].ToString(); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(FishEntity.CheckRecordEntity model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into t_checkrecord("); strSql.Append("productid,productcode,productname,recordno,checkdate,testdate,testcompanyid,testcompanycode,testcompanyname,Digestibility,regularindex1,regularindex2,regularindex3,regularindex4,regularindex5,regularindex6,regularindex7,regularindex8,regularindex9,regularindex10,regularindex11,regularindex12,aminoindex1,aminoindex2,aminoindex3,aminoindex4,aminoindex5,aminoindex6,aminoindex7,aminoindex8,aminoindex9,aminoindex10,aminoindex11,aminoindex12,aminoindex13,aminoindex14,aminoindex15,aminoindex16,aminoindex17,aminoindex18,aminoindex19,aminoindex20,aminoindex21,aminoindex22,aminoindex23,specialindex1,specialindex2,specialindex3,specialindex4,specialindex5,fee,sendsamplename,describe1)"); strSql.Append(" values ("); strSql.Append("@productid,@productcode,@productname,@recordno,@checkdate,@testdate,@testcompanyid,@testcompanycode,@testcompanyname,@Digestibility,@regularindex1,@regularindex2,@regularindex3,@regularindex4,@regularindex5,@regularindex6,@regularindex7,@regularindex8,@regularindex9,@regularindex10,@regularindex11,@regularindex12,@aminoindex1,@aminoindex2,@aminoindex3,@aminoindex4,@aminoindex5,@aminoindex6,@aminoindex7,@aminoindex8,@aminoindex9,@aminoindex10,@aminoindex11,@aminoindex12,@aminoindex13,@aminoindex14,@aminoindex15,@aminoindex16,@aminoindex17,@aminoindex18,@aminoindex19,@aminoindex20,@aminoindex21,@aminoindex22,@aminoindex23,@specialindex1,@specialindex2,@specialindex3,@specialindex4,@specialindex5,@fee,@sendsamplename,@describe1);"); strSql.Append("select LAST_INSERT_ID();"); MySqlParameter[] parameters = { new MySqlParameter("@productid", MySqlDbType.Int32, 11), new MySqlParameter("@productcode", MySqlDbType.VarChar, 45), new MySqlParameter("@productname", MySqlDbType.VarChar, 255), new MySqlParameter("@recordno", MySqlDbType.Int32, 11), new MySqlParameter("@checkdate", MySqlDbType.VarChar, 255), new MySqlParameter("@testdate", MySqlDbType.VarChar, 255), new MySqlParameter("@testcompanyid", MySqlDbType.Int32, 11), new MySqlParameter("@testcompanycode", MySqlDbType.VarChar, 45), new MySqlParameter("@testcompanyname", MySqlDbType.VarChar, 255), new MySqlParameter("@Digestibility", MySqlDbType.Decimal, 6), new MySqlParameter("@regularindex1", MySqlDbType.Decimal, 6), new MySqlParameter("@regularindex2", MySqlDbType.Decimal, 6), new MySqlParameter("@regularindex3", MySqlDbType.Decimal, 6), new MySqlParameter("@regularindex4", MySqlDbType.Decimal, 6), new MySqlParameter("@regularindex5", MySqlDbType.Decimal, 6), new MySqlParameter("@regularindex6", MySqlDbType.Decimal, 6), new MySqlParameter("@regularindex7", MySqlDbType.Decimal, 6), new MySqlParameter("@regularindex8", MySqlDbType.Decimal, 6), new MySqlParameter("@regularindex9", MySqlDbType.Decimal, 6), new MySqlParameter("@regularindex10", MySqlDbType.Decimal, 6), new MySqlParameter("@regularindex11", MySqlDbType.Decimal, 6), new MySqlParameter("@regularindex12", MySqlDbType.Decimal, 6), new MySqlParameter("@aminoindex1", MySqlDbType.Decimal, 6), new MySqlParameter("@aminoindex2", MySqlDbType.Decimal, 6), new MySqlParameter("@aminoindex3", MySqlDbType.Decimal, 6), new MySqlParameter("@aminoindex4", MySqlDbType.Decimal, 6), new MySqlParameter("@aminoindex5", MySqlDbType.Decimal, 6), new MySqlParameter("@aminoindex6", MySqlDbType.Decimal, 6), new MySqlParameter("@aminoindex7", MySqlDbType.Decimal, 6), new MySqlParameter("@aminoindex8", MySqlDbType.Decimal, 6), new MySqlParameter("@aminoindex9", MySqlDbType.Decimal, 6), new MySqlParameter("@aminoindex10", MySqlDbType.Decimal, 6), new MySqlParameter("@aminoindex11", MySqlDbType.Decimal, 6), new MySqlParameter("@aminoindex12", MySqlDbType.Decimal, 6), new MySqlParameter("@aminoindex13", MySqlDbType.Decimal, 6), new MySqlParameter("@aminoindex14", MySqlDbType.Decimal, 6), new MySqlParameter("@aminoindex15", MySqlDbType.Decimal, 6), new MySqlParameter("@aminoindex16", MySqlDbType.Decimal, 6), new MySqlParameter("@aminoindex17", MySqlDbType.Decimal, 6), new MySqlParameter("@aminoindex18", MySqlDbType.Decimal, 6), new MySqlParameter("@aminoindex19", MySqlDbType.Decimal, 6), new MySqlParameter("@aminoindex20", MySqlDbType.Decimal, 6), new MySqlParameter("@aminoindex21", MySqlDbType.Decimal, 6), new MySqlParameter("@aminoindex22", MySqlDbType.Decimal, 6), new MySqlParameter("@aminoindex23", MySqlDbType.Decimal, 6), new MySqlParameter("@specialindex1", MySqlDbType.VarChar, 255), new MySqlParameter("@specialindex2", MySqlDbType.VarChar, 255), new MySqlParameter("@specialindex3", MySqlDbType.VarChar, 255), new MySqlParameter("@specialindex4", MySqlDbType.VarChar, 255), new MySqlParameter("@specialindex5", MySqlDbType.VarChar, 255), new MySqlParameter("@fee", MySqlDbType.Decimal, 6), new MySqlParameter("@sendsamplename", MySqlDbType.VarChar, 225), new MySqlParameter("@describe1", MySqlDbType.VarChar, 255) }; parameters[0].Value = model.productid; parameters[1].Value = model.productcode; parameters[2].Value = model.productname; parameters[3].Value = model.recordno; parameters[4].Value = model.checkdate; parameters[5].Value = model.testdate; parameters[6].Value = model.testcompanyid; parameters[7].Value = model.testcompanycode; parameters[8].Value = model.testcompanyname; parameters[9].Value = model.Digestibility; parameters[10].Value = model.regularindex1; parameters[11].Value = model.regularindex2; parameters[12].Value = model.regularindex3; parameters[13].Value = model.regularindex4; parameters[14].Value = model.regularindex5; parameters[15].Value = model.regularindex6; parameters[16].Value = model.regularindex7; parameters[17].Value = model.regularindex8; parameters[18].Value = model.regularindex9; parameters[19].Value = model.regularindex10; parameters[20].Value = model.regularindex11; parameters[21].Value = model.regularindex12; parameters[22].Value = model.aminoindex1; parameters[23].Value = model.aminoindex2; parameters[24].Value = model.aminoindex3; parameters[25].Value = model.aminoindex4; parameters[26].Value = model.aminoindex5; parameters[27].Value = model.aminoindex6; parameters[28].Value = model.aminoindex7; parameters[29].Value = model.aminoindex8; parameters[30].Value = model.aminoindex9; parameters[31].Value = model.aminoindex10; parameters[32].Value = model.aminoindex11; parameters[33].Value = model.aminoindex12; parameters[34].Value = model.aminoindex13; parameters[35].Value = model.aminoindex14; parameters[36].Value = model.aminoindex15; parameters[37].Value = model.aminoindex16; parameters[38].Value = model.aminoindex17; parameters[39].Value = model.aminoindex18; parameters[40].Value = model.aminoindex19; parameters[41].Value = model.aminoindex20; parameters[42].Value = model.aminoindex21; parameters[43].Value = model.aminoindex22; parameters[44].Value = model.aminoindex23; parameters[45].Value = model.specialindex1; parameters[46].Value = model.specialindex2; parameters[47].Value = model.specialindex3; parameters[48].Value = model.specialindex4; parameters[49].Value = model.specialindex5; parameters[50].Value = model.fee; parameters[51].Value = model.Sendsamplename; parameters[52].Value = model.Describe; int rows = MySqlHelper.ExecuteSqlReturnId(strSql.ToString(), parameters); return(rows); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(FishEntity.CheckRecordEntity model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update t_checkrecord set "); strSql.Append("productid=@productid,"); strSql.Append("productcode=@productcode,"); strSql.Append("productname=@productname,"); strSql.Append("recordno=@recordno,"); strSql.Append("checkdate=@checkdate,"); strSql.Append("testdate=@testdate,"); strSql.Append("testcompanyid=@testcompanyid,"); strSql.Append("testcompanycode=@testcompanycode,"); strSql.Append("testcompanyname=@testcompanyname,"); strSql.Append("Digestibility=@Digestibility,"); strSql.Append("regularindex1=@regularindex1,"); strSql.Append("regularindex2=@regularindex2,"); strSql.Append("regularindex3=@regularindex3,"); strSql.Append("regularindex4=@regularindex4,"); strSql.Append("regularindex5=@regularindex5,"); strSql.Append("regularindex6=@regularindex6,"); strSql.Append("regularindex7=@regularindex7,"); strSql.Append("regularindex8=@regularindex8,"); strSql.Append("regularindex9=@regularindex9,"); strSql.Append("regularindex10=@regularindex10,"); strSql.Append("regularindex11=@regularindex11,"); strSql.Append("regularindex12=@regularindex12,"); strSql.Append("aminoindex1=@aminoindex1,"); strSql.Append("aminoindex2=@aminoindex2,"); strSql.Append("aminoindex3=@aminoindex3,"); strSql.Append("aminoindex4=@aminoindex4,"); strSql.Append("aminoindex5=@aminoindex5,"); strSql.Append("aminoindex6=@aminoindex6,"); strSql.Append("aminoindex7=@aminoindex7,"); strSql.Append("aminoindex8=@aminoindex8,"); strSql.Append("aminoindex9=@aminoindex9,"); strSql.Append("aminoindex10=@aminoindex10,"); strSql.Append("aminoindex11=@aminoindex11,"); strSql.Append("aminoindex12=@aminoindex12,"); strSql.Append("aminoindex13=@aminoindex13,"); strSql.Append("aminoindex14=@aminoindex14,"); strSql.Append("aminoindex15=@aminoindex15,"); strSql.Append("aminoindex16=@aminoindex16,"); strSql.Append("aminoindex17=@aminoindex17,"); strSql.Append("aminoindex18=@aminoindex18,"); strSql.Append("aminoindex19=@aminoindex19,"); strSql.Append("aminoindex20=@aminoindex20,"); strSql.Append("aminoindex21=@aminoindex21,"); strSql.Append("aminoindex22=@aminoindex22,"); strSql.Append("aminoindex23=@aminoindex23,"); strSql.Append("specialindex1=@specialindex1,"); strSql.Append("specialindex2=@specialindex2,"); strSql.Append("specialindex3=@specialindex3,"); strSql.Append("specialindex4=@specialindex4,"); strSql.Append("specialindex5=@specialindex5,"); strSql.Append("fee=@fee,"); strSql.Append("sendsamplename=@sendsamplename,"); strSql.Append("describe1=@describe1"); strSql.Append(" where id=@id"); MySqlParameter[] parameters = { new MySqlParameter("@productid", MySqlDbType.Int32, 11), new MySqlParameter("@productcode", MySqlDbType.VarChar, 45), new MySqlParameter("@productname", MySqlDbType.VarChar, 255), new MySqlParameter("@recordno", MySqlDbType.Int32, 11), new MySqlParameter("@checkdate", MySqlDbType.VarChar, 255), new MySqlParameter("@testdate", MySqlDbType.VarChar, 255), new MySqlParameter("@testcompanyid", MySqlDbType.Int32, 11), new MySqlParameter("@testcompanycode", MySqlDbType.VarChar, 45), new MySqlParameter("@testcompanyname", MySqlDbType.VarChar, 255), new MySqlParameter("@Digestibility", MySqlDbType.Decimal, 6), new MySqlParameter("@regularindex1", MySqlDbType.Decimal, 6), new MySqlParameter("@regularindex2", MySqlDbType.Decimal, 6), new MySqlParameter("@regularindex3", MySqlDbType.Decimal, 6), new MySqlParameter("@regularindex4", MySqlDbType.Decimal, 6), new MySqlParameter("@regularindex5", MySqlDbType.Decimal, 6), new MySqlParameter("@regularindex6", MySqlDbType.Decimal, 6), new MySqlParameter("@regularindex7", MySqlDbType.Decimal, 6), new MySqlParameter("@regularindex8", MySqlDbType.Decimal, 6), new MySqlParameter("@regularindex9", MySqlDbType.Decimal, 6), new MySqlParameter("@regularindex10", MySqlDbType.Decimal, 6), new MySqlParameter("@regularindex11", MySqlDbType.Decimal, 6), new MySqlParameter("@regularindex12", MySqlDbType.Decimal, 6), new MySqlParameter("@aminoindex1", MySqlDbType.Decimal, 6), new MySqlParameter("@aminoindex2", MySqlDbType.Decimal, 6), new MySqlParameter("@aminoindex3", MySqlDbType.Decimal, 6), new MySqlParameter("@aminoindex4", MySqlDbType.Decimal, 6), new MySqlParameter("@aminoindex5", MySqlDbType.Decimal, 6), new MySqlParameter("@aminoindex6", MySqlDbType.Decimal, 6), new MySqlParameter("@aminoindex7", MySqlDbType.Decimal, 6), new MySqlParameter("@aminoindex8", MySqlDbType.Decimal, 6), new MySqlParameter("@aminoindex9", MySqlDbType.Decimal, 6), new MySqlParameter("@aminoindex10", MySqlDbType.Decimal, 6), new MySqlParameter("@aminoindex11", MySqlDbType.Decimal, 6), new MySqlParameter("@aminoindex12", MySqlDbType.Decimal, 6), new MySqlParameter("@aminoindex13", MySqlDbType.Decimal, 6), new MySqlParameter("@aminoindex14", MySqlDbType.Decimal, 6), new MySqlParameter("@aminoindex15", MySqlDbType.Decimal, 6), new MySqlParameter("@aminoindex16", MySqlDbType.Decimal, 6), new MySqlParameter("@aminoindex17", MySqlDbType.Decimal, 6), new MySqlParameter("@aminoindex18", MySqlDbType.Decimal, 6), new MySqlParameter("@aminoindex19", MySqlDbType.Decimal, 6), new MySqlParameter("@aminoindex20", MySqlDbType.Decimal, 6), new MySqlParameter("@aminoindex21", MySqlDbType.Decimal, 6), new MySqlParameter("@aminoindex22", MySqlDbType.Decimal, 6), new MySqlParameter("@aminoindex23", MySqlDbType.Decimal, 6), new MySqlParameter("@specialindex1", MySqlDbType.VarChar, 255), new MySqlParameter("@specialindex2", MySqlDbType.VarChar, 255), new MySqlParameter("@specialindex3", MySqlDbType.VarChar, 255), new MySqlParameter("@specialindex4", MySqlDbType.VarChar, 255), new MySqlParameter("@specialindex5", MySqlDbType.VarChar, 255), new MySqlParameter("@fee", MySqlDbType.Decimal, 6), new MySqlParameter("@sendsamplename", MySqlDbType.VarChar, 255), new MySqlParameter("@describe1", MySqlDbType.VarChar, 255), new MySqlParameter("@id", MySqlDbType.Int32, 11) }; parameters[0].Value = model.productid; parameters[1].Value = model.productcode; parameters[2].Value = model.productname; parameters[3].Value = model.recordno; parameters[4].Value = model.checkdate; parameters[5].Value = model.testdate; parameters[6].Value = model.testcompanyid; parameters[7].Value = model.testcompanycode; parameters[8].Value = model.testcompanyname; parameters[9].Value = model.Digestibility; parameters[10].Value = model.regularindex1; parameters[11].Value = model.regularindex2; parameters[12].Value = model.regularindex3; parameters[13].Value = model.regularindex4; parameters[14].Value = model.regularindex5; parameters[15].Value = model.regularindex6; parameters[16].Value = model.regularindex7; parameters[17].Value = model.regularindex8; parameters[18].Value = model.regularindex9; parameters[19].Value = model.regularindex10; parameters[20].Value = model.regularindex11; parameters[21].Value = model.regularindex12; parameters[22].Value = model.aminoindex1; parameters[23].Value = model.aminoindex2; parameters[24].Value = model.aminoindex3; parameters[25].Value = model.aminoindex4; parameters[26].Value = model.aminoindex5; parameters[27].Value = model.aminoindex6; parameters[28].Value = model.aminoindex7; parameters[29].Value = model.aminoindex8; parameters[30].Value = model.aminoindex9; parameters[31].Value = model.aminoindex10; parameters[32].Value = model.aminoindex11; parameters[33].Value = model.aminoindex12; parameters[34].Value = model.aminoindex13; parameters[35].Value = model.aminoindex14; parameters[36].Value = model.aminoindex15; parameters[37].Value = model.aminoindex16; parameters[38].Value = model.aminoindex17; parameters[39].Value = model.aminoindex18; parameters[40].Value = model.aminoindex19; parameters[41].Value = model.aminoindex20; parameters[42].Value = model.aminoindex21; parameters[43].Value = model.aminoindex22; parameters[44].Value = model.aminoindex23; parameters[45].Value = model.specialindex1; parameters[46].Value = model.specialindex2; parameters[47].Value = model.specialindex3; parameters[48].Value = model.specialindex4; parameters[49].Value = model.specialindex5; parameters[50].Value = model.fee; parameters[51].Value = model.Sendsamplename; parameters[52].Value = model.Describe; parameters[53].Value = model.id; int rows = MySqlHelper.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }