public int Update(clsttStandardDecide model, out string errMsg) { errMsg = string.Empty; int rtn = 0; try { strB.Length = 0; strB.Append("Insert Into ttStandDecide(FtypeNmae,SampleNum,Name,ItemDes,StandardValue,Demarcate,Unit)Values('"); strB.Append(model.FtypeNmae); strB.Append("','"); strB.Append(model.SampleNum); strB.Append("','"); strB.Append(model.Name); strB.Append("','"); strB.Append(model.ItemDes); strB.Append("','"); strB.Append(model.StandardValue); strB.Append("','"); strB.Append(model.Demarcate); strB.Append("','"); strB.Append(model.Unit); strB.Append("')"); DataBase.ExecuteCommand(strB.ToString(), out errMsg); strB.Length = 0; rtn = 1; } catch (Exception e) { errMsg = e.Message; } return(rtn); }
/// <summary> /// 插入||修改 样品和检测项目对应标准 /// </summary> /// <param name="model"></param> /// <returns></returns> public int InsertOrUpdate(clsttStandardDecide model, out string errMsg) { errMsg = string.Empty; int rtn = 0; try { strB.Length = 0; DataTable dataTable = new clsTaskOpr().GetSampleByNameOrCode(model.SampleNum, string.Empty, true, false, 2); //List<clsttStandardDecide> listModel = (List<clsttStandardDecide>)DataTableToIList<clsttStandardDecide>(dataTable, 1); //if (dataTable.Rows.Count > 0) //{ // strB.Append("Update ttStandDecide Set FtypeNmae = '" + model.FtypeNmae); // strB.Append("',SampleNum = '" + model.SampleNum); // strB.Append("',Name = '" + model.Name); // strB.Append("',ItemDes = '" + model.ItemDes); // strB.Append("',StandardValue = '" + model.StandardValue); // strB.Append("',Demarcate = '" + model.Demarcate); // strB.Append("',Unit = '" + model.Unit); // strB.Append("',UDate = '" + model.UDate); // strB.Append("' Where SampleNum = '" + model.SampleNum + "'"); //} //else //{ strB.Append("Insert Into ttStandDecide(FtypeNmae,SampleNum,Name,ItemDes,StandardValue,Demarcate,Unit,UDate)Values('"); strB.Append(model.FtypeNmae); strB.Append("','"); strB.Append(model.SampleNum); strB.Append("','"); strB.Append(model.Name); strB.Append("','"); strB.Append(model.ItemDes); strB.Append("','"); strB.Append(model.StandardValue); strB.Append("','"); strB.Append(model.Demarcate); strB.Append("','"); strB.Append(model.Unit); strB.Append("','"); strB.Append(model.UDate); strB.Append("')"); //} DataBase.ExecuteCommand(strB.ToString(), out errMsg); strB.Length = 0; rtn = 1; } catch (Exception e) { errMsg = e.Message; } return(rtn); }