/// <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));
}
