/// <summary> /// 提交审批 /// </summary> /// <param name="CompanyCD"></param> /// <param name="FlowNo"></param> /// <param name="BillTypeFlag"></param> /// <param name="BillTypeCode"></param> /// <param name="BillID"></param> /// <param name="PageUrl"></param> /// <param name="ApplyUserID"></param> /// <param name="ModifiedUserID"></param> /// <returns></returns> public static string FlowApplyAdd(string CompanyCD, string FlowNo, int BillTypeFlag, int BillTypeCode, int BillID, string BillNo, string PageUrl, string ApplyUserID, string ModifiedUserID, int MsgRemind) { try { string strRetVal = ""; strRetVal = FlowDBHelper.FlowApplyAdd(CompanyCD, FlowNo, BillTypeFlag, BillTypeCode, BillID, BillNo, PageUrl, ApplyUserID, ModifiedUserID); if (!String.IsNullOrEmpty(strRetVal)) { string[] retArray = strRetVal.Split('|'); if (int.Parse(retArray[0].ToString()) > 0) { if (MsgRemind > 0) { //提交审批成功后发送短信提醒 SendMobileMsg(CompanyCD, FlowNo, BillTypeFlag, BillTypeCode, BillID, BillNo, 0, 0); } } } return(strRetVal); } catch (System.Exception ex) { throw ex; } }
/// <summary> /// 获取流程步骤 /// </summary> /// <returns>DataTable</returns> public static DataTable GetFlowStep(string CompanyCD, int BillTypeFlag, int BillTypeCode, int BillID) { try { return(FlowDBHelper.GetFlowStep(CompanyCD, BillTypeFlag, BillTypeCode, BillID)); } catch (System.Exception ex) { throw ex; } }
/// <summary> /// 审批流程手机短信提醒 /// </summary> /// <param name="CompanyCD">公司CD</param> /// <param name="FlowNo">流程编号</param> /// <param name="BillTypeFlag">Flag</param> /// <param name="BillTypeCode">Code</param> /// <param name="BillID">单据ID</param> /// <param name="State">审批状态(1:通过 0:不通过)</param> /// <param name="OperateType">操作类型(0:提交审批时 1:审批时)</param> /// <returns></returns> public static DataTable GetMsgRemindList(string CompanyCD, string FlowNo, int BillTypeFlag, int BillTypeCode, int BillID, int State, int OperateType) { try { return(FlowDBHelper.GetMsgRemindList(CompanyCD, FlowNo, BillTypeFlag, BillTypeCode, BillID, State, ((UserInfoUtil)SessionUtil.Session["UserInfo"]).UserID, OperateType)); } catch (System.Exception ex) { throw ex; } }
/// <summary> /// 判断是否有权限审批 /// </summary> /// <param name="CompanyCD"></param> /// <param name="FlowNo"></param> /// <param name="BillTypeFlag"></param> /// <param name="BillTypeCode"></param> /// <param name="BillID"></param> /// <param name="ModifiedEmployeeID"></param> /// <returns></returns> public static string GetFlowApprovalAuthority(string CompanyCD, int BillTypeFlag, int BillTypeCode, int BillID, int ModifiedEmployeeID) { try { return(FlowDBHelper.GetFlowApprovalAuthority(CompanyCD, BillTypeFlag, BillTypeCode, BillID, ModifiedEmployeeID)); } catch (System.Exception ex) { throw ex; } }
/// <summary> /// 当前单据处理状态 /// </summary> /// <param name="CompanyCD"></param> /// <param name="BillTypeFlag"></param> /// <param name="BillTypeCode"></param> /// <param name="BillID"></param> /// <param name="FlowNo"></param> /// <returns></returns> public static int GetBillUsedStatus(string CompanyCD, int BillTypeFlag, int BillTypeCode, int BillID) { try { return(FlowDBHelper.GetBillUsedStatus(CompanyCD, BillTypeFlag, BillTypeCode, BillID)); } catch (Exception) { throw; } }
/// <summary> /// 当前步骤 /// </summary> /// <param name="CompanyCD"></param> /// <param name="BillTypeFlag"></param> /// <param name="BillTypeCode"></param> /// <param name="BillID"></param> /// <returns></returns> public static int CurrentStep(string CompanyCD, int BillTypeFlag, int BillTypeCode, int BillID) { try { return(FlowDBHelper.CurrentStep(CompanyCD, BillTypeFlag, BillTypeCode, BillID)); } catch (Exception ex) { throw ex; } }
/// <summary> /// 撤消审批 /// </summary> /// <param name="CompanyCD"></param> /// <param name="FlowNo"></param> /// <param name="BillTypeFlag"></param> /// <param name="BillTypeCode"></param> /// <param name="BillID"></param> /// <param name="State"></param> /// <param name="ModifiedUserID"></param> /// <returns></returns> public static string FlowApproveUpdate(string CompanyCD, int BillTypeFlag, int BillTypeCode, int BillID, string ModifiedUserID, int ModifiedEmployeeID) { try { return(FlowDBHelper.FlowApprovalUpdate(CompanyCD, BillTypeFlag, BillTypeCode, BillID, ModifiedUserID, ModifiedEmployeeID)); } catch (System.Exception ex) { throw ex; } }
/// <summary> /// 取消车辆申请确认信息 /// </summary> /// <param name="CarApplyM">车辆申请信息</param> /// <returns>添加是否成功 false:失败,true:成功</returns> public static bool UpdateCarApplyCancelConfirm(string BillStatus, string Confirmor, string ConfirmDate, string ID, string userID, string CompanyID) { try { #region 车辆申请信息SQL拼写 StringBuilder sql = new StringBuilder(); sql.AppendLine("UPDATE officedba.CarApply"); sql.AppendLine(" SET BillStatus=@BillStatus "); sql.AppendLine(" ,Confirmor=@Confirmor "); sql.AppendLine(" ,ConfirmDate=@ConfirmDate "); sql.AppendLine(" ,ModifiedDate=@ModifiedDate "); sql.AppendLine(" ,ModifiedUserID=@ModifiedUserID "); sql.AppendLine("WHERE "); sql.AppendLine(" ID=@ID "); #endregion #region 车辆申请信息参数设置 SqlParameter[] param; param = new SqlParameter[6]; param[0] = SqlHelper.GetParameter("@BillStatus", BillStatus); param[1] = SqlHelper.GetParameter("@Confirmor", Confirmor); param[2] = SqlHelper.GetParameter("@ConfirmDate", ConfirmDate); param[3] = SqlHelper.GetParameter("@ModifiedDate", System.DateTime.Now); param[4] = SqlHelper.GetParameter("@ModifiedUserID", userID); param[5] = SqlHelper.GetParameter("@ID", ID); #endregion //SqlHelper.ExecuteTransSql(sql.ToString(), param); TransactionManager tran = new TransactionManager(); tran.BeginTransaction(); try { FlowDBHelper.OperateCancelConfirm(CompanyID, 3, 8, Convert.ToInt32(ID), userID, tran);//取消确认 SqlHelper.ExecuteNonQuery(tran.Trans, CommandType.Text, sql.ToString(), param); tran.Commit(); return(true); } catch { tran.Rollback(); return(false); } } catch { return(false); } }
public static bool UpdateMoveApplyCancelConfirm(string BillStatus, string ID, string userID, string CompanyID, string ReprotNo) { try { StringBuilder sql = new StringBuilder(); sql.AppendLine("UPDATE officedba.RectApply"); sql.AppendLine(" SET BillStatus=@Status "); sql.AppendLine(" ,ModifiedDate=getdate() "); sql.AppendLine(" ,ModifiedUserID=@ModifiedUserID "); sql.AppendLine(" ,ConfirmDate = null "); sql.AppendLine(" ,Confirmor = null "); sql.AppendLine("WHERE "); sql.AppendLine(" CompanyCD = @CompanyCD "); sql.AppendLine(" AND RectApplyNo = @RectApplyNo "); SqlParameter[] param; param = new SqlParameter[4]; param[0] = SqlHelper.GetParameter("@Status", BillStatus); param[1] = SqlHelper.GetParameter("@ModifiedUserID", userID); param[2] = SqlHelper.GetParameter("@CompanyCD", CompanyID); param[3] = SqlHelper.GetParameter("@RectApplyNo", ReprotNo); //SqlHelper.ExecuteTransSql(sql.ToString(), param); TransactionManager tran = new TransactionManager(); tran.BeginTransaction(); try { FlowDBHelper.OperateCancelConfirm(CompanyID, Convert.ToInt32(XBase.Common.ConstUtil.BILL_TYPEFLAG_HUMAN), Convert.ToInt32(XBase.Common.ConstUtil.BILL_TYPECODE_HUMAN_RECT_APPLY), Convert.ToInt32(ID), userID, tran);//取消确认 SqlHelper.ExecuteNonQuery(tran.Trans, CommandType.Text, sql.ToString(), param); tran.Commit(); return(true); } catch { tran.Rollback(); return(false); } } catch { return(false); } }
public static bool CancelConfirm(string ID, string No) { try { ////已经被引用的采购申请不能取消确认 //if (IsCitePurApply(ID)) //{ // return false; //} ArrayList lstCancelConfirm = new ArrayList(); //更改主表 lstCancelConfirm.Add(OfficeThingsPurchaseApplyDBHelper.CancelConfirm(ID)); //获取登陆用户信息 UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //撤销审批 string CompanyCD = userInfo.CompanyCD; string BillTypeFlag = ConstUtil.CODING_RULE_PURCHASE; string BillTypeCode = ConstUtil.CODING_RULE_PURCHASE_APPLY; string strUserID = userInfo.UserID;; DataTable dt = FlowDBHelper.GetFlowInstanceInfo(CompanyCD, Convert.ToInt32(BillTypeFlag), Convert.ToInt32(BillTypeCode), Convert.ToInt32(ID)); if (dt.Rows.Count > 0) { string FlowInstanceID = dt.Rows[0]["FlowInstanceID"].ToString(); string FlowStatus = dt.Rows[0]["FlowStatus"].ToString(); string FlowNo = dt.Rows[0]["FlowNo"].ToString(); lstCancelConfirm.Add(FlowDBHelper.CancelConfirmHis(CompanyCD, FlowInstanceID, FlowNo, BillTypeFlag, BillTypeCode, strUserID)); lstCancelConfirm.Add(FlowDBHelper.CancelConfirmTsk(CompanyCD, FlowInstanceID, strUserID)); lstCancelConfirm.Add(FlowDBHelper.CancelConfirmIns(CompanyCD, FlowNo, BillTypeFlag, BillTypeCode, ID, strUserID)); } //定义返回变量 bool isSucc = false; /* * 定义日志内容变量 * 增删改相关的日志,需要输出操作日志,该类型日志插入到数据库 * 其他的 如出现异常时,需要输出系统日志,该类型日志保存到日志文件 */ //执行插入操作 try { isSucc = SqlHelper.ExecuteTransWithArrayList(lstCancelConfirm); } catch (Exception ex) { //输出日志 WriteSystemLog(userInfo, ex); } //定义变量 string remark; //成功时 if (isSucc) { //设置操作成功标识 remark = ConstUtil.LOG_PROCESS_SUCCESS; } else { //设置操作成功标识 remark = ConstUtil.LOG_PROCESS_FAILED; } LogInfoModel logModel = InitLogInfo(No); //涉及关键元素 这个需要根据每个页面具体设置,本页面暂时设置为空 logModel.Element = ConstUtil.LOG_PROCESS_UNCONFIRM; //设置操作成功标识 logModel.Remark = remark; //登陆日志 LogDBHelper.InsertLog(logModel); return(isSucc); } catch (Exception ex) { throw ex; } }
public static bool ConcelConfirm(string ID, string FromType, string OrderNo, List<ProductModel> ProductMList, List<ProductModel> ProductMStorList, out string Reason) { try { Reason = string.Empty; //不可以确认返回false if (!PurchaseOrderDBHelper.CanConcel(ID, out Reason)) return false; ArrayList lstConcelConfirm = new ArrayList(); //更新主表 SqlCommand ConcelPri = PurchaseOrderDBHelper.ConcelConfirm(ID); lstConcelConfirm.Add(ConcelPri); //更新分仓存量表 if (ProductMStorList != null) { foreach (ProductModel ProductM in ProductMStorList) { SqlCommand comm = PurchaseOrderDBHelper.WriteStorgeDecr(ProductM); lstConcelConfirm.Add(comm); } } if (ProductMList != null) { if (FromType == "2") {//回写采购计划 foreach (ProductModel ProductM in ProductMList) { SqlCommand comm = PurchaseOrderDBHelper.WritePurPlanDecr(ProductM); lstConcelConfirm.Add(comm); } } else if (FromType == "4") {//回写采购合同 foreach (ProductModel ProductM in ProductMList) { SqlCommand comm = PurchaseOrderDBHelper.WritePurContDecr(ProductM); lstConcelConfirm.Add(comm); } } } //获取登陆用户信息 UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //撤销审批 string CompanyCD = userInfo.CompanyCD; string BillTypeFlag = ConstUtil.CODING_RULE_PURCHASE; string BillTypeCode = ConstUtil.CODING_RULE_PURCHASE_ORDER; string strUserID = userInfo.UserID; ; DataTable dt = FlowDBHelper.GetFlowInstanceInfo(CompanyCD, Convert.ToInt32(BillTypeFlag), Convert.ToInt32(BillTypeCode), Convert.ToInt32(ID)); if (dt.Rows.Count > 0) { string FlowInstanceID = dt.Rows[0]["FlowInstanceID"].ToString(); string FlowStatus = dt.Rows[0]["FlowStatus"].ToString(); string FlowNo = dt.Rows[0]["FlowNo"].ToString(); lstConcelConfirm.Add(FlowDBHelper.CancelConfirmHis(CompanyCD, FlowInstanceID, FlowNo, BillTypeFlag, BillTypeCode, strUserID)); lstConcelConfirm.Add(FlowDBHelper.CancelConfirmTsk(CompanyCD, FlowInstanceID, strUserID)); lstConcelConfirm.Add(FlowDBHelper.CancelConfirmIns(CompanyCD, FlowNo, BillTypeFlag, BillTypeCode, ID, strUserID)); } //定义返回变量 bool isSucc = false; /* * 定义日志内容变量 * 增删改相关的日志,需要输出操作日志,该类型日志插入到数据库 * 其他的 如出现异常时,需要输出系统日志,该类型日志保存到日志文件 */ //执行插入操作 try { isSucc = SqlHelper.ExecuteTransWithArrayList(lstConcelConfirm); } catch (Exception ex) { //输出日志 WriteSystemLog(userInfo, ex); } //定义变量 string remark; //成功时 if (isSucc) { //设置操作成功标识 remark = ConstUtil.LOG_PROCESS_SUCCESS; } else { //设置操作成功标识 remark = ConstUtil.LOG_PROCESS_FAILED; } LogInfoModel logModel = InitLogInfo(OrderNo); //涉及关键元素 这个需要根据每个页面具体设置,本页面暂时设置为空 logModel.Element = ConstUtil.LOG_PROCESS_UNCONFIRM; //设置操作成功标识 logModel.Remark = remark; //登陆日志 LogDBHelper.InsertLog(logModel); return isSucc; } catch (Exception ex) { throw ex; } }
public static bool CancelConfirm(string ID, string PlanNo, List <ProductModel> ProductMList) { try { ArrayList lstCancelConfirm = new ArrayList(); //更新主表 lstCancelConfirm.Add(PurchasePlanDBHelper.CancelConfirm(ID)); //回写采购申请中已计划数量 if (ProductMList != null) { foreach (ProductModel ProductM in ProductMList) { if (ProductM.FromType == "1") { SqlCommand DescPurApply = PurchasePlanDBHelper.WritePurchaseApplyDesc(ProductM); lstCancelConfirm.Add(DescPurApply); } else if (ProductM.FromType == "2") { SqlCommand DesePurRequire = PurchasePlanDBHelper.WritePurchaseRequireDesc(ProductM); lstCancelConfirm.Add(DesePurRequire); } } } //获取登陆用户信息 UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //撤销审批 string CompanyCD = userInfo.CompanyCD; string BillTypeFlag = ConstUtil.CODING_RULE_PURCHASE; string BillTypeCode = ConstUtil.CODING_RULE_PURCHASE_PLAN; string strUserID = userInfo.UserID;; DataTable dt = FlowDBHelper.GetFlowInstanceInfo(CompanyCD, Convert.ToInt32(BillTypeFlag), Convert.ToInt32(BillTypeCode), Convert.ToInt32(ID)); if (dt.Rows.Count > 0) { string FlowInstanceID = dt.Rows[0]["FlowInstanceID"].ToString(); string FlowStatus = dt.Rows[0]["FlowStatus"].ToString(); string FlowNo = dt.Rows[0]["FlowNo"].ToString(); lstCancelConfirm.Add(FlowDBHelper.CancelConfirmHis(CompanyCD, FlowInstanceID, FlowNo, BillTypeFlag, BillTypeCode, strUserID)); lstCancelConfirm.Add(FlowDBHelper.CancelConfirmTsk(CompanyCD, FlowInstanceID, strUserID)); lstCancelConfirm.Add(FlowDBHelper.CancelConfirmIns(CompanyCD, FlowNo, BillTypeFlag, BillTypeCode, ID, strUserID)); } //定义返回变量 bool isSucc = false; /* * 定义日志内容变量 * 增删改相关的日志,需要输出操作日志,该类型日志插入到数据库 * 其他的 如出现异常时,需要输出系统日志,该类型日志保存到日志文件 */ //执行插入操作 try { isSucc = SqlHelper.ExecuteTransWithArrayList(lstCancelConfirm); } catch (Exception ex) { //输出日志 WriteSystemLog(userInfo, ex); } //定义变量 string remark; //成功时 if (isSucc) { //设置操作成功标识 remark = ConstUtil.LOG_PROCESS_SUCCESS; } else { //设置操作成功标识 remark = ConstUtil.LOG_PROCESS_FAILED; } LogInfoModel logModel = InitLogInfo(PlanNo); //涉及关键元素 这个需要根据每个页面具体设置,本页面暂时设置为空 logModel.Element = ConstUtil.LOG_PROCESS_UNCONFIRM; //设置操作成功标识 logModel.Remark = remark; //登陆日志 LogDBHelper.InsertLog(logModel); return(isSucc); } catch (Exception ex) { throw ex; } }