/// <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;
}
}
