/// <summary> /// 新增或编辑 /// 作者:章建国 /// </summary> /// <param name="model"></param> /// <returns></returns> public string doMeasureInfoCU(tb_Measure model) { string flag = "0"; try { model.updateDate = DateTime.Now; model.updateUser = CurrentUserInfo.PersonnelID; if (model.id > 0) { if (_measurebll.Update(model)) { flag = "1"; } } else { model.createDate = DateTime.Now; model.createUser = CurrentUserInfo.PersonnelID; model.measureType = "计量"; if (_measurebll.Add(model) > 0) { flag = "1"; } } } catch (Exception e) { flag = "0"; } return(flag); }
public ActionResult doMeasureCheckInfo(int id) { tb_Measure model = new tb_Measure(); if (id > 0) { model = _measurebll.GetModel(id); } return(View(model)); }
public ActionResult MeasureCertificate(int id) { tb_Measure model = new tb_Measure(); if (id > 0) { model = _measurebll.GetModel(id); } return(View(model)); }
/// <summary> /// 得到一个对象实体 /// </summary> public tb_Measure GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 * from tb_measure"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; tb_Measure model = new tb_Measure(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(tb_Measure model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(tb_Measure model) { return(dal.Add(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(tb_Measure model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tb_Measure("); strSql.Append("deviceName,standard,assetCode,deviceCode,buyDate,useDate,oValue,deperciation,periodVerification,lastVerification,verification,nextVerification,technologyState,problem,useCompany,usePerson,createUser,createDate,updateUser,updateDate,temp1,temp2,companyName,verificationCompany,phoneNumber,isDevice,measureType,device_Id)"); strSql.Append(" values ("); strSql.Append("@deviceName,@standard,@assetCode,@deviceCode,@buyDate,@useDate,@oValue,@deperciation,@periodVerification,@lastVerification,@verification,@nextVerification,@technologyState,@problem,@useCompany,@usePerson,@createUser,@createDate,@updateUser,@updateDate,@temp1,@temp2,@companyName,@verificationCompany,@phoneNumber,@isDevice,@measureType,@device_Id)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@deviceName", SqlDbType.NVarChar, -1), new SqlParameter("@standard", SqlDbType.NVarChar, -1), new SqlParameter("@assetCode", SqlDbType.NVarChar, 50), new SqlParameter("@deviceCode", SqlDbType.NVarChar, 50), new SqlParameter("@buyDate", SqlDbType.DateTime), new SqlParameter("@useDate", SqlDbType.DateTime), new SqlParameter("@oValue", SqlDbType.Decimal, 9), new SqlParameter("@deperciation", SqlDbType.Int, 4), new SqlParameter("@periodVerification", SqlDbType.Int, 4), new SqlParameter("@lastVerification", SqlDbType.DateTime), new SqlParameter("@verification", SqlDbType.NVarChar, -1), new SqlParameter("@nextVerification", SqlDbType.DateTime), new SqlParameter("@technologyState", SqlDbType.NVarChar, -1), new SqlParameter("@problem", SqlDbType.NVarChar, -1), new SqlParameter("@useCompany", SqlDbType.NVarChar, -1), new SqlParameter("@usePerson", SqlDbType.NVarChar, -1), new SqlParameter("@createUser", SqlDbType.Int, 4), new SqlParameter("@createDate", SqlDbType.DateTime), new SqlParameter("@updateUser", SqlDbType.Int, 4), new SqlParameter("@updateDate", SqlDbType.DateTime), new SqlParameter("@temp1", SqlDbType.NVarChar, -1), new SqlParameter("@temp2", SqlDbType.NVarChar, -1), new SqlParameter("@companyName", SqlDbType.NVarChar, -1), new SqlParameter("@verificationCompany", SqlDbType.NVarChar, -1), new SqlParameter("@phoneNumber", SqlDbType.NVarChar, -1), new SqlParameter("@isDevice", SqlDbType.NVarChar, -1), new SqlParameter("@measureType", SqlDbType.NVarChar, 50), new SqlParameter("@device_Id", SqlDbType.Int, 4) }; parameters[0].Value = model.deviceName; parameters[1].Value = model.standard; parameters[2].Value = model.assetCode; parameters[3].Value = model.deviceCode; parameters[4].Value = model.buyDate; parameters[5].Value = model.useDate; parameters[6].Value = model.oValue; parameters[7].Value = model.deperciation; parameters[8].Value = model.periodVerification; parameters[9].Value = model.lastVerification; parameters[10].Value = model.verification; parameters[11].Value = model.nextVerification; parameters[12].Value = model.technologyState; parameters[13].Value = model.problem; parameters[14].Value = model.useCompany; parameters[15].Value = model.usePerson; parameters[16].Value = model.createUser; parameters[17].Value = model.createDate; parameters[18].Value = model.updateUser; parameters[19].Value = model.updateDate; parameters[20].Value = model.temp1; parameters[21].Value = model.temp2; parameters[22].Value = model.companyName; parameters[23].Value = model.verificationCompany; parameters[24].Value = model.phoneNumber; parameters[25].Value = model.isDevice; parameters[26].Value = model.measureType; parameters[27].Value = model.Device_Id; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public tb_Measure DataRowToModel(DataRow row) { tb_Measure model = new tb_Measure(); if (row != null) { if (row["id"] != null && row["id"].ToString() != "") { model.id = int.Parse(row["id"].ToString()); } if (row["deviceName"] != null) { model.deviceName = row["deviceName"].ToString(); } if (row["standard"] != null) { model.standard = row["standard"].ToString(); } if (row["assetCode"] != null) { model.assetCode = row["assetCode"].ToString(); } if (row["deviceCode"] != null) { model.deviceCode = row["deviceCode"].ToString(); } if (row["buyDate"] != null && row["buyDate"].ToString() != "") { model.buyDate = DateTime.Parse(row["buyDate"].ToString()); } if (row["useDate"] != null && row["useDate"].ToString() != "") { model.useDate = DateTime.Parse(row["useDate"].ToString()); } if (row["oValue"] != null && row["oValue"].ToString() != "") { model.oValue = decimal.Parse(row["oValue"].ToString()); } if (row["deperciation"] != null && row["deperciation"].ToString() != "") { model.deperciation = int.Parse(row["deperciation"].ToString()); } if (row["periodVerification"] != null && row["periodVerification"].ToString() != "") { model.periodVerification = int.Parse(row["periodVerification"].ToString()); } if (row["lastVerification"] != null && row["lastVerification"].ToString() != "") { model.lastVerification = DateTime.Parse(row["lastVerification"].ToString()); } if (row["verification"] != null) { model.verification = row["verification"].ToString(); } if (row["nextVerification"] != null && row["nextVerification"].ToString() != "") { model.nextVerification = DateTime.Parse(row["nextVerification"].ToString()); } if (row["technologyState"] != null) { model.technologyState = row["technologyState"].ToString(); } if (row["problem"] != null) { model.problem = row["problem"].ToString(); } if (row["useCompany"] != null) { model.useCompany = row["useCompany"].ToString(); } if (row["usePerson"] != null) { model.usePerson = row["usePerson"].ToString(); } if (row["createUser"] != null && row["createUser"].ToString() != "") { model.createUser = int.Parse(row["createUser"].ToString()); } if (row["createDate"] != null && row["createDate"].ToString() != "") { model.createDate = DateTime.Parse(row["createDate"].ToString()); } if (row["updateUser"] != null && row["updateUser"].ToString() != "") { model.updateUser = int.Parse(row["updateUser"].ToString()); } if (row["updateDate"] != null && row["updateDate"].ToString() != "") { model.updateDate = DateTime.Parse(row["updateDate"].ToString()); } if (row["temp1"] != null) { model.temp1 = row["temp1"].ToString(); } if (row["temp2"] != null) { model.temp2 = row["temp2"].ToString(); } if (row["companyName"] != null) { model.companyName = row["companyName"].ToString(); } if (row["verificationCompany"] != null) { model.verificationCompany = row["verificationCompany"].ToString(); } if (row["phoneNumber"] != null) { model.phoneNumber = row["phoneNumber"].ToString(); } if (row["isDevice"] != null) { model.isDevice = row["isDevice"].ToString(); } if (row["measureType"] != null) { model.measureType = row["measureType"].ToString(); } if (row["device_Id"] != null && row["device_Id"].ToString() != "") { model.Device_Id = int.Parse(row["device_Id"].ToString()); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(tb_Measure model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tb_Measure set "); strSql.Append("deviceName=@deviceName,"); strSql.Append("standard=@standard,"); strSql.Append("assetCode=@assetCode,"); strSql.Append("deviceCode=@deviceCode,"); strSql.Append("buyDate=@buyDate,"); strSql.Append("useDate=@useDate,"); strSql.Append("oValue=@oValue,"); strSql.Append("deperciation=@deperciation,"); strSql.Append("periodVerification=@periodVerification,"); strSql.Append("lastVerification=@lastVerification,"); strSql.Append("verification=@verification,"); strSql.Append("nextVerification=@nextVerification,"); strSql.Append("technologyState=@technologyState,"); strSql.Append("problem=@problem,"); strSql.Append("useCompany=@useCompany,"); strSql.Append("usePerson=@usePerson,"); strSql.Append("createUser=@createUser,"); strSql.Append("createDate=@createDate,"); strSql.Append("updateUser=@updateUser,"); strSql.Append("updateDate=@updateDate,"); strSql.Append("temp1=@temp1,"); strSql.Append("temp2=@temp2,"); strSql.Append("companyName=@companyName,"); strSql.Append("verificationCompany=@verificationCompany,"); strSql.Append("phoneNumber=@phoneNumber,"); strSql.Append("isDevice=@isDevice,"); strSql.Append("measureType=@measureType,"); strSql.Append("deviceId=@deviceId"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@deviceName", SqlDbType.NVarChar, -1), new SqlParameter("@standard", SqlDbType.NVarChar, -1), new SqlParameter("@assetCode", SqlDbType.NVarChar, 50), new SqlParameter("@deviceCode", SqlDbType.NVarChar, 50), new SqlParameter("@buyDate", SqlDbType.DateTime), new SqlParameter("@useDate", SqlDbType.DateTime), new SqlParameter("@oValue", SqlDbType.Decimal, 9), new SqlParameter("@deperciation", SqlDbType.Int, 4), new SqlParameter("@periodVerification", SqlDbType.Int, 4), new SqlParameter("@lastVerification", SqlDbType.DateTime), new SqlParameter("@verification", SqlDbType.NVarChar, -1), new SqlParameter("@nextVerification", SqlDbType.DateTime), new SqlParameter("@technologyState", SqlDbType.NVarChar, -1), new SqlParameter("@problem", SqlDbType.NVarChar, -1), new SqlParameter("@useCompany", SqlDbType.NVarChar, -1), new SqlParameter("@usePerson", SqlDbType.NVarChar, -1), new SqlParameter("@createUser", SqlDbType.Int, 4), new SqlParameter("@createDate", SqlDbType.DateTime), new SqlParameter("@updateUser", SqlDbType.Int, 4), new SqlParameter("@updateDate", SqlDbType.DateTime), new SqlParameter("@temp1", SqlDbType.NVarChar, -1), new SqlParameter("@temp2", SqlDbType.NVarChar, -1), new SqlParameter("@companyName", SqlDbType.NVarChar, -1), new SqlParameter("@verificationCompany", SqlDbType.NVarChar, -1), new SqlParameter("@phoneNumber", SqlDbType.NVarChar, -1), new SqlParameter("@isDevice", SqlDbType.NVarChar, -1), new SqlParameter("@measureType", SqlDbType.NVarChar, 50), new SqlParameter("@deviceId", SqlDbType.Int, 4), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.deviceName; parameters[1].Value = model.standard; parameters[2].Value = model.assetCode; parameters[3].Value = model.deviceCode; parameters[4].Value = model.buyDate; parameters[5].Value = model.useDate; parameters[6].Value = model.oValue; parameters[7].Value = model.deperciation; parameters[8].Value = model.periodVerification; parameters[9].Value = model.lastVerification; parameters[10].Value = model.verification; parameters[11].Value = model.nextVerification; parameters[12].Value = model.technologyState; parameters[13].Value = model.problem; parameters[14].Value = model.useCompany; parameters[15].Value = model.usePerson; parameters[16].Value = model.createUser; parameters[17].Value = model.createDate; parameters[18].Value = model.updateUser; parameters[19].Value = model.updateDate; parameters[20].Value = model.temp1; parameters[21].Value = model.temp2; parameters[22].Value = model.companyName; parameters[23].Value = model.verificationCompany; parameters[24].Value = model.phoneNumber; parameters[25].Value = model.isDevice; parameters[26].Value = model.measureType; parameters[27].Value = model.Device_Id; parameters[28].Value = model.id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }