public ActionResult doEasyConsumeLockInfo(int id)
{
tb_EasyConsumeLock model = new tb_EasyConsumeLock();
if (id > 0)
{
model = _easyConsumelockbll.GetModel(id);
}
return(View(model));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(tb_EasyConsumeLock model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_EasyConsumeLock set ");
strSql.Append("lockName=@lockName,");
strSql.Append("mark=@mark,");
strSql.Append("createUser=@createUser,");
strSql.Append("createDate=@createDate,");
strSql.Append("updateUser=@updateUser,");
strSql.Append("updateDate=@updateDate,");
strSql.Append("lockType=@lockType,");
strSql.Append("temp1=@temp1,");
strSql.Append("temp2=@temp2");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@lockName", SqlDbType.NVarChar, -1),
new SqlParameter("@mark", SqlDbType.NVarChar, 50),
new SqlParameter("@createUser", SqlDbType.Int, 4),
new SqlParameter("@createDate", SqlDbType.DateTime),
new SqlParameter("@updateUser", SqlDbType.Int, 4),
new SqlParameter("@updateDate", SqlDbType.DateTime),
new SqlParameter("@lockType", SqlDbType.NVarChar, 100),
new SqlParameter("@temp1", SqlDbType.NVarChar, -1),
new SqlParameter("@temp2", SqlDbType.NVarChar, -1),
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = model.lockName;
parameters[1].Value = model.mark;
parameters[2].Value = model.createUser;
parameters[3].Value = model.createDate;
parameters[4].Value = model.updateUser;
parameters[5].Value = model.updateDate;
parameters[6].Value = model.lockType;
parameters[7].Value = model.temp1;
parameters[8].Value = model.temp2;
parameters[9].Value = model.id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public tb_EasyConsumeLock DataRowToModel(DataRow row)
{
tb_EasyConsumeLock model = new tb_EasyConsumeLock();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = int.Parse(row["id"].ToString());
}
if (row["lockName"] != null)
{
model.lockName = row["lockName"].ToString();
}
if (row["mark"] != null)
{
model.mark = row["mark"].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["lockType"] != null)
{
model.lockType = row["lockType"].ToString();
}
if (row["temp1"] != null)
{
model.temp1 = row["temp1"].ToString();
}
if (row["temp2"] != null)
{
model.temp2 = row["temp2"].ToString();
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(tb_EasyConsumeLock model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_EasyConsumeLock(");
strSql.Append("lockName,mark,createUser,createDate,updateUser,updateDate,lockType,temp1,temp2)");
strSql.Append(" values (");
strSql.Append("@lockName,@mark,@createUser,@createDate,@updateUser,@updateDate,@lockType,@temp1,@temp2)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@lockName", SqlDbType.NVarChar, -1),
new SqlParameter("@mark", SqlDbType.NVarChar, 50),
new SqlParameter("@createUser", SqlDbType.Int, 4),
new SqlParameter("@createDate", SqlDbType.DateTime),
new SqlParameter("@updateUser", SqlDbType.Int, 4),
new SqlParameter("@updateDate", SqlDbType.DateTime),
new SqlParameter("@lockType", SqlDbType.NVarChar, 100),
new SqlParameter("@temp1", SqlDbType.NVarChar, -1),
new SqlParameter("@temp2", SqlDbType.NVarChar, -1)
};
parameters[0].Value = model.lockName;
parameters[1].Value = model.mark;
parameters[2].Value = model.createUser;
parameters[3].Value = model.createDate;
parameters[4].Value = model.updateUser;
parameters[5].Value = model.updateDate;
parameters[6].Value = model.lockType;
parameters[7].Value = model.temp1;
parameters[8].Value = model.temp2;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public tb_EasyConsumeLock GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 * from tb_EasyConsumeLock ");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
tb_EasyConsumeLock model = new tb_EasyConsumeLock();
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_EasyConsumeLock model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(tb_EasyConsumeLock model)
{
return(dal.Add(model));
}
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));
}
