/// <summary> /// 获取所有数据列表 /// 作者:章建国 /// </summary> /// <returns>将DataTable转换为Json数据格式通过string类型返回</returns> public string GetEasyConsumeRegionList(int pageNumber, int pageSize, string _regionName, int _lockId) { DataTable dt = new DataTable(); int total = 0; try { string where = " 1 = 1 "; if (!string.IsNullOrEmpty(_regionName) && _lockId > 0) { try { tb_EasyConsumeRegion model = _easyConsumeregionbll.GetModelList(string.Format(" regionName = '{0}' and lockId = {1}", _regionName, _lockId)).First(); where += " and regionId = " + model.id; } catch { } } if (_lockId > 0) { where += " and lockId = " + _lockId; dt = _easyConsumeregionbll.GetListByPage(where, "UpdateDate", pageNumber * pageSize - (pageSize - 1), pageNumber * pageSize).Tables[0]; total = dt.Rows.Count; total = _easyConsumeregionbll.GetListCount(where); } } catch { } return(PublicClass.ToJson(dt, total)); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(tb_EasyConsumeRegion model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tb_EasyConsumeRegion set "); strSql.Append("lockId=@lockId,"); strSql.Append("regionName=@regionName,"); strSql.Append("createUser=@createUser,"); strSql.Append("createDate=@createDate,"); strSql.Append("updateUser=@updateUser,"); strSql.Append("updateDate=@updateDate"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@lockId", SqlDbType.Int, 4), new SqlParameter("@regionName", 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("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.lockId; parameters[1].Value = model.regionName; parameters[2].Value = model.createUser; parameters[3].Value = model.createDate; parameters[4].Value = model.updateUser; parameters[5].Value = model.updateDate; parameters[6].Value = model.id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public tb_EasyConsumeRegion DataRowToModel(DataRow row) { tb_EasyConsumeRegion model = new tb_EasyConsumeRegion(); if (row != null) { if (row["id"] != null && row["id"].ToString() != "") { model.id = int.Parse(row["id"].ToString()); } if (row["lockId"] != null && row["lockId"].ToString() != "") { model.lockId = int.Parse(row["lockId"].ToString()); } if (row["regionName"] != null) { model.regionName = row["regionName"].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()); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(tb_EasyConsumeRegion model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tb_EasyConsumeRegion("); strSql.Append("lockId,regionName,createUser,createDate,updateUser,updateDate)"); strSql.Append(" values ("); strSql.Append("@lockId,@regionName,@createUser,@createDate,@updateUser,@updateDate)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@lockId", SqlDbType.Int, 4), new SqlParameter("@regionName", 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) }; parameters[0].Value = model.lockId; parameters[1].Value = model.regionName; parameters[2].Value = model.createUser; parameters[3].Value = model.createDate; parameters[4].Value = model.updateUser; parameters[5].Value = model.updateDate; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public tb_EasyConsumeRegion GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,lockId,regionName,createUser,createDate,updateUser,updateDate from tb_EasyConsumeRegion "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; tb_EasyConsumeRegion model = new tb_EasyConsumeRegion(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
public JsonResult Update_EasyConsumeLock(int id, string _lockName, bool _wxp, bool _hxp, string _locktype) { string str = "保存失败!"; try { tb_EasyConsumeLock model = new tb_EasyConsumeLock(); if (id > 0) { model = _easyConsumelockbll.GetModel(id); } model.lockName = _lockName; model.lockType = _locktype; if (_wxp && _hxp) { model.mark = "都是"; } else if (!_wxp && !_hxp) { model.mark = "都不是"; } else if (_wxp) { model.mark = "危险品"; } else if (_hxp) { model.mark = "化学品"; } if (model.lockType.Equals("冷藏柜")) { model.mark = "都是"; } model.updateDate = DateTime.Now; model.updateUser = CurrentUserInfo.PersonnelID; if (id > 0) { if (_easyConsumelockbll.Update(model)) { str = "保存成功!"; } } else { model.createDate = DateTime.Now; model.createUser = CurrentUserInfo.PersonnelID; var easyConsumelocklist = _easyConsumelockbll.GetModelList("").Where(w => w.lockName.Equals(model.lockName) && w.createUser == model.createUser); if (easyConsumelocklist == null || easyConsumelocklist.Count() == 0) { if (_easyConsumelockbll.Add(model) > 0) { easyConsumelocklist = _easyConsumelockbll.GetModelList("").Where(w => w.lockName.Equals(model.lockName) && w.createUser == model.createUser); if (easyConsumelocklist != null && easyConsumelocklist.Count() > 0) { model = easyConsumelocklist.First(); int fornum = 12; string imgname = ""; if (model.lockType.Equals("不透明柜2_4")) { fornum = 8; } else if (model.lockType.Equals("冷藏柜")) { imgname = "冷藏柜"; fornum = 0; for (int i = 1; i <= 5; i++) { tb_EasyConsumeRegion easyConsumeregionmodel = new tb_EasyConsumeRegion(); switch (i) { case 1: imgname = "A"; break; case 2: imgname = "B"; break; case 3: imgname = "C"; break; case 4: imgname = "D"; break; case 5: imgname = "E"; break; } easyConsumeregionmodel.createDate = DateTime.Now; easyConsumeregionmodel.createUser = CurrentUserInfo.PersonnelID; easyConsumeregionmodel.lockId = model.id; easyConsumeregionmodel.regionName = imgname; easyConsumeregionmodel.updateDate = DateTime.Now; easyConsumeregionmodel.updateUser = CurrentUserInfo.PersonnelID; _easyConsumeregionbll.Add(easyConsumeregionmodel); } } for (int i = 1; i <= fornum; i++) { tb_EasyConsumeRegion easyConsumeregionmodel = new tb_EasyConsumeRegion(); switch (i) { case 1: imgname = "A1"; break; case 2: imgname = "A2"; break; case 3: imgname = "A3"; break; case 4: imgname = "A4"; break; case 5: imgname = "B1"; break; case 6: imgname = "B2"; break; case 7: imgname = "B3"; break; case 8: imgname = "B4"; break; case 9: imgname = "C1"; break; case 10: imgname = "C2"; break; case 11: imgname = "C3"; break; case 12: imgname = "C4"; break; } easyConsumeregionmodel.createDate = DateTime.Now; easyConsumeregionmodel.createUser = CurrentUserInfo.PersonnelID; easyConsumeregionmodel.lockId = model.id; easyConsumeregionmodel.regionName = imgname; easyConsumeregionmodel.updateDate = DateTime.Now; easyConsumeregionmodel.updateUser = CurrentUserInfo.PersonnelID; _easyConsumeregionbll.Add(easyConsumeregionmodel); } } str = "保存成功!"; } } else { str = "重复的药品柜名称!"; } } } catch { } return(Json(str, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(tb_EasyConsumeRegion model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(tb_EasyConsumeRegion model) { return(dal.Add(model)); }