/// <summary> /// 得到一个对象实体 /// </summary> public FXJDatabase.tb_CheckDataonlineModel GetModel(long HLId) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 "); strSql.Append(" ID,BarCode,cType,FileName,fltCapacity,fltVolGap,fltSelfFrequency,fltVol,fltResistance,cGrade,cState,cDate,cStateCode,Tf_BatchId,Tf_TrayId,tf_Location,tf_CheckGrade,tf_Tag,dlOCV,dlOCVTime,Tf_TempE,tf_DOcv,Kvalue,tf_Pick,tf_ResultNum,HLId "); strSql.Append(" from tb_CheckDataonline "); strSql.Append(" where HLId=" + HLId + ""); FXJDatabase.tb_CheckDataonlineModel model = new FXJDatabase.tb_CheckDataonlineModel(); DataSet ds = DbHelperSQL.Query(strSql.ToString()); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(FXJDatabase.tb_CheckDataonlineModel model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public long Add(FXJDatabase.tb_CheckDataonlineModel model) { return(dal.Add(model)); }
/// <summary> /// 得到一个对象实体 /// </summary> public FXJDatabase.tb_CheckDataonlineModel DataRowToModel(DataRow row) { FXJDatabase.tb_CheckDataonlineModel model = new FXJDatabase.tb_CheckDataonlineModel(); if (row != null) { if (row["ID"] != null && row["ID"].ToString() != "") { model.ID = long.Parse(row["ID"].ToString()); } if (row["BarCode"] != null) { model.BarCode = row["BarCode"].ToString(); } if (row["cType"] != null) { model.cType = row["cType"].ToString(); } if (row["FileName"] != null) { model.FileName = row["FileName"].ToString(); } if (row["fltCapacity"] != null) { model.fltCapacity = row["fltCapacity"].ToString(); } if (row["fltVolGap"] != null && row["fltVolGap"].ToString() != "") { model.fltVolGap = decimal.Parse(row["fltVolGap"].ToString()); } if (row["fltSelfFrequency"] != null && row["fltSelfFrequency"].ToString() != "") { model.fltSelfFrequency = decimal.Parse(row["fltSelfFrequency"].ToString()); } if (row["fltVol"] != null && row["fltVol"].ToString() != "") { model.fltVol = decimal.Parse(row["fltVol"].ToString()); } if (row["fltResistance"] != null && row["fltResistance"].ToString() != "") { model.fltResistance = decimal.Parse(row["fltResistance"].ToString()); } if (row["cGrade"] != null) { model.cGrade = row["cGrade"].ToString(); } if (row["cState"] != null && row["cState"].ToString() != "") { model.cState = decimal.Parse(row["cState"].ToString()); } if (row["cDate"] != null) { model.cDate = row["cDate"].ToString(); } if (row["cStateCode"] != null) { model.cStateCode = row["cStateCode"].ToString(); } if (row["Tf_BatchId"] != null) { model.Tf_BatchId = row["Tf_BatchId"].ToString(); } if (row["Tf_TrayId"] != null) { model.Tf_TrayId = row["Tf_TrayId"].ToString(); } if (row["tf_Location"] != null) { model.tf_Location = row["tf_Location"].ToString(); } if (row["tf_CheckGrade"] != null) { model.tf_CheckGrade = row["tf_CheckGrade"].ToString(); } if (row["tf_Tag"] != null && row["tf_Tag"].ToString() != "") { model.tf_Tag = int.Parse(row["tf_Tag"].ToString()); } if (row["dlOCV"] != null) { model.dlOCV = row["dlOCV"].ToString(); } if (row["dlOCVTime"] != null) { model.dlOCVTime = row["dlOCVTime"].ToString(); } if (row["Tf_TempE"] != null) { model.Tf_TempE = row["Tf_TempE"].ToString(); } if (row["tf_DOcv"] != null) { model.tf_DOcv = row["tf_DOcv"].ToString(); } if (row["Kvalue"] != null) { model.Kvalue = row["Kvalue"].ToString(); } if (row["tf_Pick"] != null) { model.tf_Pick = row["tf_Pick"].ToString(); } if (row["tf_ResultNum"] != null) { model.tf_ResultNum = row["tf_ResultNum"].ToString(); } if (row["HLId"] != null && row["HLId"].ToString() != "") { model.HLId = long.Parse(row["HLId"].ToString()); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public long Add(FXJDatabase.tb_CheckDataonlineModel model) { StringBuilder strSql = new StringBuilder(); StringBuilder strSql1 = new StringBuilder(); StringBuilder strSql2 = new StringBuilder(); if (model.ID != null) { strSql1.Append("ID,"); strSql2.Append("" + model.ID + ","); } if (model.BarCode != null) { strSql1.Append("BarCode,"); strSql2.Append("'" + model.BarCode + "',"); } if (model.cType != null) { strSql1.Append("cType,"); strSql2.Append("'" + model.cType + "',"); } if (model.FileName != null) { strSql1.Append("FileName,"); strSql2.Append("'" + model.FileName + "',"); } if (model.fltCapacity != null) { strSql1.Append("fltCapacity,"); strSql2.Append("'" + model.fltCapacity + "',"); } if (model.fltVolGap != null) { strSql1.Append("fltVolGap,"); strSql2.Append("" + model.fltVolGap + ","); } if (model.fltSelfFrequency != null) { strSql1.Append("fltSelfFrequency,"); strSql2.Append("" + model.fltSelfFrequency + ","); } if (model.fltVol != null) { strSql1.Append("fltVol,"); strSql2.Append("" + model.fltVol + ","); } if (model.fltResistance != null) { strSql1.Append("fltResistance,"); strSql2.Append("" + model.fltResistance + ","); } if (model.cGrade != null) { strSql1.Append("cGrade,"); strSql2.Append("'" + model.cGrade + "',"); } if (model.cState != null) { strSql1.Append("cState,"); strSql2.Append("" + model.cState + ","); } if (model.cDate != null) { strSql1.Append("cDate,"); strSql2.Append("'" + model.cDate + "',"); } if (model.cStateCode != null) { strSql1.Append("cStateCode,"); strSql2.Append("'" + model.cStateCode + "',"); } if (model.Tf_BatchId != null) { strSql1.Append("Tf_BatchId,"); strSql2.Append("'" + model.Tf_BatchId + "',"); } if (model.Tf_TrayId != null) { strSql1.Append("Tf_TrayId,"); strSql2.Append("'" + model.Tf_TrayId + "',"); } if (model.tf_Location != null) { strSql1.Append("tf_Location,"); strSql2.Append("'" + model.tf_Location + "',"); } if (model.tf_CheckGrade != null) { strSql1.Append("tf_CheckGrade,"); strSql2.Append("'" + model.tf_CheckGrade + "',"); } if (model.tf_Tag != null) { strSql1.Append("tf_Tag,"); strSql2.Append("" + model.tf_Tag + ","); } if (model.dlOCV != null) { strSql1.Append("dlOCV,"); strSql2.Append("'" + model.dlOCV + "',"); } if (model.dlOCVTime != null) { strSql1.Append("dlOCVTime,"); strSql2.Append("'" + model.dlOCVTime + "',"); } if (model.Tf_TempE != null) { strSql1.Append("Tf_TempE,"); strSql2.Append("'" + model.Tf_TempE + "',"); } if (model.tf_DOcv != null) { strSql1.Append("tf_DOcv,"); strSql2.Append("'" + model.tf_DOcv + "',"); } if (model.Kvalue != null) { strSql1.Append("Kvalue,"); strSql2.Append("'" + model.Kvalue + "',"); } if (model.tf_Pick != null) { strSql1.Append("tf_Pick,"); strSql2.Append("'" + model.tf_Pick + "',"); } if (model.tf_ResultNum != null) { strSql1.Append("tf_ResultNum,"); strSql2.Append("'" + model.tf_ResultNum + "',"); } strSql.Append("insert into tb_CheckDataonline("); strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1)); strSql.Append(")"); strSql.Append(" values ("); strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1)); strSql.Append(")"); strSql.Append(";select @@IDENTITY"); object obj = DbHelperSQL.GetSingle(strSql.ToString()); if (obj == null) { return(0); } else { return(Convert.ToInt64(obj)); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(FXJDatabase.tb_CheckDataonlineModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tb_CheckDataonline set "); if (model.ID != null) { strSql.Append("ID=" + model.ID + ","); } else { strSql.Append("ID= null ,"); } if (model.BarCode != null) { strSql.Append("BarCode='" + model.BarCode + "',"); } else { strSql.Append("BarCode= null ,"); } if (model.cType != null) { strSql.Append("cType='" + model.cType + "',"); } else { strSql.Append("cType= null ,"); } if (model.FileName != null) { strSql.Append("FileName='" + model.FileName + "',"); } else { strSql.Append("FileName= null ,"); } if (model.fltCapacity != null) { strSql.Append("fltCapacity='" + model.fltCapacity + "',"); } else { strSql.Append("fltCapacity= null ,"); } if (model.fltVolGap != null) { strSql.Append("fltVolGap=" + model.fltVolGap + ","); } else { strSql.Append("fltVolGap= null ,"); } if (model.fltSelfFrequency != null) { strSql.Append("fltSelfFrequency=" + model.fltSelfFrequency + ","); } else { strSql.Append("fltSelfFrequency= null ,"); } if (model.fltVol != null) { strSql.Append("fltVol=" + model.fltVol + ","); } else { strSql.Append("fltVol= null ,"); } if (model.fltResistance != null) { strSql.Append("fltResistance=" + model.fltResistance + ","); } else { strSql.Append("fltResistance= null ,"); } if (model.cGrade != null) { strSql.Append("cGrade='" + model.cGrade + "',"); } else { strSql.Append("cGrade= null ,"); } if (model.cState != null) { strSql.Append("cState=" + model.cState + ","); } else { strSql.Append("cState= null ,"); } if (model.cDate != null) { strSql.Append("cDate='" + model.cDate + "',"); } else { strSql.Append("cDate= null ,"); } if (model.cStateCode != null) { strSql.Append("cStateCode='" + model.cStateCode + "',"); } else { strSql.Append("cStateCode= null ,"); } if (model.Tf_BatchId != null) { strSql.Append("Tf_BatchId='" + model.Tf_BatchId + "',"); } else { strSql.Append("Tf_BatchId= null ,"); } if (model.Tf_TrayId != null) { strSql.Append("Tf_TrayId='" + model.Tf_TrayId + "',"); } else { strSql.Append("Tf_TrayId= null ,"); } if (model.tf_Location != null) { strSql.Append("tf_Location='" + model.tf_Location + "',"); } else { strSql.Append("tf_Location= null ,"); } if (model.tf_CheckGrade != null) { strSql.Append("tf_CheckGrade='" + model.tf_CheckGrade + "',"); } else { strSql.Append("tf_CheckGrade= null ,"); } if (model.tf_Tag != null) { strSql.Append("tf_Tag=" + model.tf_Tag + ","); } else { strSql.Append("tf_Tag= null ,"); } if (model.dlOCV != null) { strSql.Append("dlOCV='" + model.dlOCV + "',"); } else { strSql.Append("dlOCV= null ,"); } if (model.dlOCVTime != null) { strSql.Append("dlOCVTime='" + model.dlOCVTime + "',"); } else { strSql.Append("dlOCVTime= null ,"); } if (model.Tf_TempE != null) { strSql.Append("Tf_TempE='" + model.Tf_TempE + "',"); } else { strSql.Append("Tf_TempE= null ,"); } if (model.tf_DOcv != null) { strSql.Append("tf_DOcv='" + model.tf_DOcv + "',"); } else { strSql.Append("tf_DOcv= null ,"); } if (model.Kvalue != null) { strSql.Append("Kvalue='" + model.Kvalue + "',"); } else { strSql.Append("Kvalue= null ,"); } if (model.tf_Pick != null) { strSql.Append("tf_Pick='" + model.tf_Pick + "',"); } else { strSql.Append("tf_Pick= null ,"); } if (model.tf_ResultNum != null) { strSql.Append("tf_ResultNum='" + model.tf_ResultNum + "',"); } else { strSql.Append("tf_ResultNum= null ,"); } int n = strSql.ToString().LastIndexOf(","); strSql.Remove(n, 1); strSql.Append(" where HLId=" + model.HLId + ""); int rowsAffected = DbHelperSQL.ExecuteSql(strSql.ToString()); if (rowsAffected > 0) { return(true); } else { return(false); } }