/// <summary> /// 锁定物料操作人 /// </summary> /// <param name="taskDetailsMdl"></param> /// <param name="userMdl"></param> /// <returns></returns> public int LockTaskOperUser(TaskDetails_Model taskDetailsMdl, BLL.Basic.User.UserInfo userMdl) { try { string strSql = "update t_taskdetails set operatoruserno='{0}' where id = '{1}'"; strSql = string.Format(strSql, userMdl.UserNo, taskDetailsMdl.ID); return(OperationSql.ExecuteNonQuery2(System.Data.CommandType.Text, strSql)); } catch (Exception ex) { throw new Exception(ex.Message + ex.TargetSite); } }
public Task_Model GetTaskDetailsInfo(string strTaskNo) { try { Task_Model TM = new Task_Model(); TM.lstTaskDetails = new List <TaskDetails_Model>(); string strSql = string.Format("select * from V_GETTASKDETAILSINFO where taskno = '{0}'", strTaskNo); using (SqlDataReader dr = OperationSql.ExecuteReader(System.Data.CommandType.Text, strSql)) { while (dr.Read()) { TM.ID = dr["task_id"].ToInt32(); TM.TaskNo = dr["taskno"].ToDBString(); TM.TaskStatus = dr["taskstatus"].ToInt32(); TM.IsShelvePost = dr["isshelvepost"].ToInt32(); TM.IsQuality = dr["isquality"].ToInt32(); TM.VoucherType = dr["VoucherType"].ToInt32(); TM.Plant = dr["plant"].ToDBString(); TM.DeliveryNo = dr["deliveryno"].ToDBString(); TaskDetails_Model TDM = new TaskDetails_Model(); TDM.ID = dr["id"].ToInt32(); TDM.MaterialNo = dr["materialno"].ToDBString(); TDM.MaterialDesc = dr["materialdesc"].ToDBString(); TDM.MaterialStd = dr["MaterialStd"].ToDBString(); TDM.TaskQty = dr["taskqty"].ToDecimal(); TDM.QuanlityQty = dr["qualityqty"].ToDecimal(); TDM.RemainQty = dr["remainqty"].ToDecimal(); TDM.ShelveQty = dr["shelveqty"].ToDecimal(); TDM.RowNo = dr["RowNo"].ToDBString(); TDM.VoucherNo = dr["VoucherNo"].ToDBString(); TDM.PackCount = dr["PackCount"].ToDecimal(); TDM.ShelvePackCount = dr["ShelvePackCount"].ToDecimal(); TDM.RemainPackCount = dr["RemainPackCount"].ToDecimal(); TM.lstTaskDetails.Add(TDM); } } strSql = string.Format(@"SELECT A.warehouseno FROM T_WAREHOUSE A JOIN T_TASKWAREHOUSE B ON A.id=B.warehouse_id JOIN T_TASK C ON B.task_id=C.id WHERE C.taskno = '{0}'", strTaskNo); TM.WareHouseNo = OperationSql.ExecuteScalar(CommandType.Text, strSql, null).ToString(); return(TM); } catch (Exception ex) { throw ex; } }
/// <summary> /// 查看物料被哪个用户锁定 /// </summary> /// <param name="taskDetailsMdl"></param> /// <param name="userMdl"></param> /// <returns></returns> public string QueryUserNameByTaskDetails(TaskDetails_Model taskDetailsMdl, BLL.Basic.User.UserInfo userMdl) { try { string strUserName = string.Empty; string strSql = "select b.UserName from t_taskdetails a left join t_user b on a.operatoruserno = b.userno where a.id = {0} " + " and a.operatoruserno!='{1}'"; strSql = string.Format(strSql, taskDetailsMdl.ID, userMdl.UserNo); return((string)OperationSql.ExecuteScalar(System.Data.CommandType.Text, strSql)); } catch (Exception ex) { throw new Exception(ex.Message + ex.TargetSite); } }
/// <summary> /// 锁定任务操作人 /// </summary> /// <param name="taskDetailsMdl"></param> /// <param name="userMdl"></param> /// <param name="strErrMsg"></param> /// <returns></returns> public string LockTaskOperUser(string strTaskDetailsJson, string strUserJson) { TaskHead_Model taskHeadModel = new TaskHead_Model(); try { int iLock = 0; string strUserName = string.Empty; TaskDetails_Model taskDetailsModel = JSONUtil.JSONHelper.JsonToObject <TaskDetails_Model>(strTaskDetailsJson); if (taskDetailsModel == null || (string.IsNullOrEmpty(taskDetailsModel.MaterialNo) && string.IsNullOrEmpty(taskDetailsModel.TMaterialNo))) { return(GetFailJson(ref taskHeadModel, "没有物料信息")); } Basic.User.UserInfo userModel = JSONUtil.JSONHelper.JsonToObject <Basic.User.UserInfo>(strUserJson); if (userModel == null || string.IsNullOrEmpty(userModel.UserNo)) { return(GetFailJson(ref taskHeadModel, "没有用户信息")); } Task_DB TD = new Task_DB(); strUserName = TD.QueryUserNameByTaskDetails(taskDetailsModel, userModel); if (!string.IsNullOrEmpty(strUserName)) { return(GetFailJson(ref taskHeadModel, "物料:" + taskDetailsModel.MaterialNo + taskDetailsModel.TMaterialNo + "\r\n" + "被:" + strUserName + "锁定!")); } iLock = TD.LockTaskOperUser(taskDetailsModel, userModel); if (iLock == 0) { return(GetFailJson(ref taskHeadModel, "物料:" + taskDetailsModel.MaterialNo + "锁定失败!")); } return(GetSuccessJson(ref taskHeadModel)); } catch (Exception ex) { return(GetFailJson(ref taskHeadModel, "Web异常:" + ex)); } }