public JsonModel CreateInventoryList(int planid, string type, string useridcard)
{
//定义JSON标准格式实体中
JsonModel jsonModel = new JsonModel();
try
{
//事务
using (SqlTransaction trans = dal.GetTran())
{
try
{
int listCount = new EmsDAL.InventoryList().AddInventoryList(trans, planid, type, useridcard);
if (listCount <= 0)
{
trans.Rollback();//回滚
jsonModel.Status = "no";
jsonModel.Msg = "生成盘点单失败";
return(jsonModel);
}
int addCount = dal.AddInventoryListDetail(trans, planid, type);
if (addCount <= 0)
{
trans.Rollback();//回滚
jsonModel.Status = "no";
jsonModel.Msg = "生成盘点单失败";
return(jsonModel);
}
EmsModel.InventoryPlan plan = new EmsBLL.InventoryPlan().GetEmsModel(planid);
plan.IsGenerate = 1;
int upcount = new EmsDAL.InventoryPlan().Update(plan);
if (upcount <= 0)
{
trans.Rollback();//回滚
jsonModel.Status = "no";
jsonModel.Msg = "生成盘点单失败";
return(jsonModel);
}
trans.Commit();//提交
}
catch (Exception)
{
trans.Rollback();//回滚
throw;
}
}
jsonModel.Status = "ok";
jsonModel.Msg = "操作成功";
return(jsonModel);
}
catch (Exception ex)
{
jsonModel.Status = "error";
jsonModel.Msg = ex.ToString();
return(jsonModel);
}
}
/// <summary>
/// 保存房间盘点信息
/// </summary>
/// <param name="invenid">盘点单id</param>
/// <param name="roomid">房间id</param>
/// <param name="idStr">盘点详情id</param>
/// <param name="editStr">需要换房间的盘点详情id</param>
/// <param name="useridcard">用户身份证号</param>
/// <returns></returns>
public JsonModel SaveRoomInventory(string invenid, string roomid, string idStr, string editStr, string useridcard)
{
//定义JSON标准格式实体中
JsonModel jsonModel = new JsonModel();
try
{
//事务
using (SqlTransaction trans = dal.GetTran())
{
try
{
string[] idArray = idStr.Split(',');
string[] editArray = editStr.Split(',');
int result = 0;
if (!string.IsNullOrEmpty(idStr))
{
int idcount = 0;
foreach (string deid in idArray)
{
EmsModel.InventoryListDetail ind = dal.GetEmsModel(Convert.ToInt32(deid));
ind.IsLoss = true;
result = dal.Update(trans, ind);
if (result > 0)
{
idcount++;
}
}
if (idArray.Length != idcount)
{
trans.Rollback();//回滚
jsonModel.Status = "no";
jsonModel.Msg = "保存失败";
return(jsonModel);
}
}
if (!string.IsNullOrEmpty(editStr))
{
int editcount = 0;
foreach (string editid in editArray)
{
EmsModel.InventoryListDetail ind = dal.GetEmsModel(Convert.ToInt32(editid));
ind.SourceRoomId = ind.RoomId;
ind.RoomId = Convert.ToInt32(roomid);
ind.IsLoss = true;
result = dal.Update(trans, ind);
EmsDAL.EquipDetail dal_equip = new EmsDAL.EquipDetail();
EmsModel.EquipDetail equip = dal_equip.GetEmsModel(ind.EquipId);
equip.StorageLocation = roomid;
dal_equip.Update(trans, equip);//修改仪器设备详情存放地点
if (result > 0)
{
editcount++;
}
}
if (editArray.Length != editcount)
{
trans.Rollback();//回滚
jsonModel.Status = "no";
jsonModel.Msg = "保存失败";
return(jsonModel);
}
}
EmsDAL.InventoryList dal_list = new EmsDAL.InventoryList();
EmsModel.InventoryList list = dal_list.GetEmsModelByInvRoomId(invenid, roomid);
list.RealQuantity = (!string.IsNullOrEmpty(idStr) ? idArray.Length : 0) + (!string.IsNullOrEmpty(editStr) ? editArray.Length : 0);
list.Status = 1;
list.Operator = useridcard;
list.Editor = useridcard;
list.UpdateTime = DateTime.Now;
result = dal_list.Update(trans, list);
if (result == 0)
{
trans.Rollback();//回滚
jsonModel.Status = "no";
jsonModel.Msg = "保存失败";
return(jsonModel);
}
if (dal.GetNotInventoryCount(trans, invenid) == 0)
{
EmsDAL.InventoryPlan dal_plan = new EmsDAL.InventoryPlan();
EmsModel.InventoryPlan plan = dal_plan.GetEmsModel(Convert.ToInt32(invenid));
plan.Status = 1;
result = dal_plan.Update(trans, plan);
if (result == 0)
{
trans.Rollback();//回滚
jsonModel.Status = "no";
jsonModel.Msg = "保存失败";
return(jsonModel);
}
}
trans.Commit();//提交
}
catch (Exception)
{
trans.Rollback();//回滚
throw;
}
}
jsonModel.Status = "ok";
jsonModel.Msg = "操作成功";
return(jsonModel);
}
catch (Exception ex)
{
jsonModel.Status = "error";
jsonModel.Msg = ex.ToString();
return(jsonModel);
}
}