/// <summary> /// 插入A07收卡操作 /// </summary> /// <param name="job">工单实体</param> /// <returns></returns> public void InsertA07(Entity.JobInfo job) { if (job.JobType == "MD") { if (new ModifyList().GetList("IsDelete=0 and IsChangeName=1 and JobID='" + job.JobID + "'").Tables[0].Rows.Count == 0) { return; } } Entity.HandleList handle = new Entity.HandleList(); handle.Guid = Guid.NewGuid().ToString(); handle.JobID = job.JobID; handle.No = Num; handle.FunctionID = "A07"; handle.OpeartionID = 12; handle.IsChecked = false; handle.Status = "待处理"; Entity.HandleList handleEx = new Entity.HandleList(); handleEx.Guid = Guid.NewGuid().ToString(); handleEx.JobID = job.JobID; handleEx.No = Num++; handleEx.FunctionID = "A07"; handleEx.OpeartionID = 13; handleEx.IsChecked = false; handleEx.Status = "待处理"; this.Add(handle); this.Add(handleEx); }
/// <summary> /// 插入A08资料确认操作 /// </summary> /// <param name="job">工单实体</param> /// <returns></returns> public void InsertA08(Entity.JobInfo job) { Entity.HandleList handle = new Entity.HandleList(); handle.Guid = Guid.NewGuid().ToString(); handle.JobID = job.JobID; handle.No = Num++; handle.FunctionID = "A08"; handle.OpeartionID = 11; handle.IsChecked = false; handle.Status = "待处理"; this.Add(handle); }
/* * /// <summary> * /// 分页获取数据列表 * /// </summary> * public DataSet GetList(int PageSize,int PageIndex,string strWhere) * { * SqlParameter[] parameters = { * new SqlParameter("@tblName", SqlDbType.VarChar, 255), * new SqlParameter("@fldName", SqlDbType.VarChar, 255), * new SqlParameter("@PageSize", SqlDbType.Int), * new SqlParameter("@PageIndex", SqlDbType.Int), * new SqlParameter("@IsReCount", SqlDbType.Bit), * new SqlParameter("@OrderType", SqlDbType.Bit), * new SqlParameter("@strWhere", SqlDbType.VarChar,1000), * }; * parameters[0].Value = "HandleList"; * parameters[1].Value = "Guid"; * parameters[2].Value = PageSize; * parameters[3].Value = PageIndex; * parameters[4].Value = 0; * parameters[5].Value = 0; * parameters[6].Value = strWhere; * return DbHelperSQL.RunProcedure("UP_GetRecordByPage",parameters,"ds"); * }*/ #endregion BasicMethod #region ExtensionMethod /// <summary> /// 插入A01接单操作 /// </summary> /// <param name="job">工单实体</param> /// <returns></returns> public void InsertA01(Entity.JobInfo job) { Entity.HandleList handle = new Entity.HandleList(); handle.Guid = Guid.NewGuid().ToString(); handle.JobID = job.JobID; handle.No = Num++; handle.FunctionID = "A01"; handle.OpeartionID = job.IsOnline ? 2 : 1; handle.IsChecked = true; handle.Status = "已处理"; handle.OpeartionUser = job.IsOnline ? job.CreateUser : PageBase.CommonObject.ManagerUserInfo.guid; handle.OpeartionTime = job.CreateTime; handle.Remark = job.IsOnline ? job.EnterpriseName + ",网上提交工单." : "操作员:" + new ManagerUser().GetModel(handle.OpeartionUser).Name + ",现场收单."; this.Add(handle); }
/// <summary> /// 插入A03审批确认操作 /// </summary> /// <param name="job">工单实体</param> /// <returns></returns> public void InsertA03(Entity.JobInfo job) { DataTable dt = new NewlyAddedList().GetList("IsDelete=0 and JobType='NA001' and JobID='" + job.JobID + "'").Tables[0]; if (dt.Rows.Count > 0 && job.IsOnline) { string shtyxydm = new NewlyAddedListFR().GetList("ListID='" + dt.Rows[0]["ListID"] + "'").Tables[0].Rows[0]["SHTYXYDM_QS"].ToString().Substring(2, 4); if (shtyxydm != "4401" && shtyxydm != "4400") { Entity.HandleList handle = new Entity.HandleList(); handle.Guid = Guid.NewGuid().ToString(); handle.JobID = job.JobID; handle.No = Num++; handle.FunctionID = "A03"; handle.OpeartionID = 5; handle.IsChecked = false; handle.Status = "待处理"; this.Add(handle); } } }
/// <summary> /// 插入A02录入操作 /// </summary> /// <param name="job">工单实体</param> /// <returns></returns> public void InsertA02(Entity.JobInfo job) { if (new NewlyAddedList().GetList("IsDelete=0 and JobType='NA001' and JobID='" + job.JobID + "'").Tables[0].Rows.Count > 0) { Entity.HandleList handleQS = new Entity.HandleList(); handleQS.Guid = Guid.NewGuid().ToString(); handleQS.JobID = job.JobID; handleQS.No = Num; handleQS.FunctionID = "A02"; handleQS.OpeartionID = 3; handleQS.IsChecked = false; handleQS.Status = "待处理"; Entity.HandleList handleHS = new Entity.HandleList(); handleHS.Guid = Guid.NewGuid().ToString(); handleHS.JobID = job.JobID; handleHS.No = Num++; handleHS.FunctionID = "A02"; handleHS.OpeartionID = 4; handleHS.IsChecked = false; handleHS.Status = "待处理"; this.Add(handleQS); this.Add(handleHS); } }
/// <summary> /// 插入A04制卡操作 /// </summary> /// <param name="job">工单实体</param> /// <returns></returns> public void InsertA04(Entity.JobInfo job) { Entity.HandleList handle = new Entity.HandleList(); handle.Guid = Guid.NewGuid().ToString(); handle.JobID = job.JobID; handle.No = Num; handle.FunctionID = "A04"; handle.IsChecked = false; handle.Status = "待处理"; switch (job.JobType) { case "NA": DataTable dt = new NewlyAddedList().GetList("IsDelete=0 and JobID='" + job.JobID + "'").Tables[0]; if (dt.Select("JobType<>'NA001'").Length > 0) { handle.OpeartionID = 7; if (dt.Select("JobType='NA001'").Length > 0) { Entity.HandleList handleFR = new Entity.HandleList(); handleFR.Guid = Guid.NewGuid().ToString(); handleFR.JobID = job.JobID; handleFR.No = Num; handleFR.FunctionID = "A04"; handleFR.OpeartionID = 6; handleFR.IsChecked = false; handleFR.Status = "待处理"; this.Add(handleFR); } } else { handle.OpeartionID = 6; } break; case "MD": if (new ModifyList().GetList("IsDelete=0 and IsChangeName=1 and JobID='" + job.JobID + "'").Tables[0].Rows.Count > 0) { handle.OpeartionID = 14; } else { return; } break; case "RI": handle.OpeartionID = 15; break; case "RM": handle.OpeartionID = 17; break; case "UU": handle.OpeartionID = 16; break; } Num++; this.Add(handle); }