Пример #1
0
        public JsonModel SetRoomDistributionEquip(string roomid, string type, string equipids, string owneridcard)
        {
            //定义JSON标准格式实体中
            JsonModel jsonModel = new JsonModel();

            try
            {
                //事务
                using (SqlTransaction trans = dal.GetTran())
                {
                    try
                    {
                        if (!string.IsNullOrEmpty(equipids))
                        {
                            string[]           idArray   = equipids.Split(',');
                            int                count     = 0;
                            EmsDAL.EquipDetail dal_equip = new EmsDAL.EquipDetail();
                            foreach (string equipid in idArray)
                            {
                                EmsModel.EquipDetail equip = dal_equip.GetEmsModel(Convert.ToInt32(equipid));
                                equip.StorageLocation = roomid;
                                if (type == "2")
                                {
                                    equip.EquipOwner = owneridcard;
                                }
                                int result = dal_equip.Update(trans, equip);
                                if (result > 0)
                                {
                                    count++;
                                }
                            }
                            if (idArray.Length != count)
                            {
                                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);
            }
        }
Пример #2
0
        /// <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);
            }
        }