using System;
|
using System.Collections.Generic;
|
using System.Text;
|
using System.Data;
|
using System.Windows.Forms;
|
|
namespace DBUtility
|
{
|
public class ClsPub:Pub_Class.ClsPub
|
{
|
//
|
|
|
|
#region 其他处理
|
|
|
|
//多审审核状态
|
public static int Xt_BillCheckFlowStatus(Int64 lngBillKey,string sBillNo, string mvarItemKey, Int64 HCheckFlowID, string HBillName)
|
{
|
//
|
Pub_Class.ClsPub.HCheckStatus = -1;
|
Xt_BillCheckFlowStatusNow(mvarItemKey, lngBillKey, sBillNo, HCheckFlowID, "", 1, HBillName);
|
return Pub_Class.ClsPub.HCheckStatus;
|
//
|
}
|
|
//多审审核
|
public static int Xt_BillCheckFlowStatus(Int64 lngBillKey,string sBillNo, string mvarItemKey, Int64 HCheckFlowID, string HCheckNote, string HBillName)
|
{
|
DataSet Ds;
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
string sWhere = "";
|
sWhere = sWhere + "," + HCheckFlowID + "";
|
sWhere = sWhere + ",'" + mvarItemKey + "'";
|
sWhere = sWhere + "," + lngBillKey + "";
|
//sWhere = sWhere + ",'" + sBillNo + "'";
|
sWhere = sWhere + ",'" + HCheckNote + "'";
|
sWhere = sWhere + ",'" + ClsPub.CurUserName + "'";
|
if (sWhere.Trim().Length > 0)
|
{
|
sWhere = sWhere.Substring(1, sWhere.Length - 1);
|
}
|
|
Ds = oCn.RunProcReturn("exec h_p_Xt_BillCheckFlowStatus " + sWhere, "h_p_Xt_BillCheckFlowStatus");
|
if (Ds == null || Ds.Tables[0].Rows.Count == 0)
|
{
|
MessageBox.Show("判断审核状态失败!");
|
return -1;
|
}
|
else
|
{
|
if (ClsPub.isInt(Ds.Tables[0].Rows[0]["sStatus"]) == -1) //异常 没有权限
|
{
|
MessageBox.Show(Ds.Tables[0].Rows[0]["sMsg"].ToString());
|
return -1;
|
}
|
else if (ClsPub.isInt(Ds.Tables[0].Rows[0]["sStatus"]) == -2) //没有审批流
|
{
|
MessageBox.Show("全部审核完毕!没有审核流!");
|
oCn.RunProc("update " + HBillName + " set HBillStatus=2 Where HinterID=" + lngBillKey.ToString());
|
return -2;
|
}
|
else if (ClsPub.isInt(Ds.Tables[0].Rows[0]["sStatus"]) == -3) //多审核完毕,不需要再审核
|
{
|
MessageBox.Show("全部审核完毕!不需要再审核!");
|
return -3;
|
}
|
else if (ClsPub.isInt(Ds.Tables[0].Rows[0]["sStatus"]) == 1) //终审核完毕
|
{
|
oCn.RunProc("update " + HBillName + " set HBillStatus=2 Where HinterID=" + lngBillKey.ToString());
|
return 1;
|
}
|
else //返回 0 正在审核中,审核成功。
|
{
|
oCn.RunProc("update " + HBillName + " set HBillStatus=6 Where HinterID=" + lngBillKey.ToString());
|
return 0;
|
}
|
}
|
}
|
//多审反审状态
|
public static int Xt_BillCheckFlowStatusback1(Int64 lngBillKey,string sBillNo, string mvarItemKey, Int64 HCheckFlowID, string HBillName)
|
{
|
ClsPub.HCheckStatus = -1;
|
ClsPub.Xt_BillCheckFlowStatusNow(mvarItemKey, lngBillKey, sBillNo, HCheckFlowID, "", 2, HBillName);
|
return HCheckStatus;
|
}
|
//多审反审核
|
public static int Xt_BillCheckFlowStatusback(Int64 lngBillKey, string sBillNo, string mvarItemKey, Int64 HCheckFlowID, string HBillName)
|
{
|
DataSet Ds;
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
string sWhere = "";
|
sWhere = sWhere + "," + HCheckFlowID + "";
|
sWhere = sWhere + "," + mvarItemKey + "";
|
sWhere = sWhere + "," + lngBillKey + "";
|
//sWhere = sWhere + ",'" + sBillNo + "'";
|
sWhere = sWhere + "," + ClsPub.CurUserName;
|
if (sWhere.Trim().Length > 0)
|
{
|
sWhere = sWhere.Substring(1, sWhere.Length - 1);
|
}
|
Ds = oCn.RunProcReturn("exec h_p_Xt_BillCheckFlowStatusback " + sWhere, "h_p_Xt_BillCheckFlowStatus");
|
if (Ds == null || Ds.Tables[0].Rows.Count == 0)
|
{
|
MessageBox.Show("判断审核状态失败!");
|
return -1;
|
}
|
else
|
{
|
if (ClsPub.isInt(Ds.Tables[0].Rows[0]["sStatus"]) == -1)//没反审权限
|
{
|
MessageBox.Show(Ds.Tables[0].Rows[0]["sMsg"].ToString());
|
return -1;
|
}
|
else if (ClsPub.isInt(Ds.Tables[0].Rows[0]["sStatus"]) == -2)//没有审批流
|
{
|
MessageBox.Show("全部反审完毕!");
|
oCn.RunProc("update " + HBillName + " set HBillStatus=1 Where HinterID=" + lngBillKey.ToString());
|
return -2;
|
}
|
else if (ClsPub.isInt(Ds.Tables[0].Rows[0]["sStatus"]) == -3)// 还未开始审核,不需要反审核
|
{
|
MessageBox.Show("还没有审核,不需要反审核!");
|
return -3;
|
}
|
else if (ClsPub.isInt(Ds.Tables[0].Rows[0]["sStatus"]) == 1) //全部反审完毕
|
{
|
oCn.RunProc("update " + HBillName + " set HBillStatus=1 Where HinterID=" + lngBillKey.ToString());
|
return 1;
|
}
|
else //反审核中 0
|
{
|
oCn.RunProc("update " + HBillName + " set HBillStatus=6 Where HinterID=" + lngBillKey.ToString());
|
return 0;
|
}
|
}
|
}
|
//查看审核状态
|
public static void Xt_BillCheckFlowStatusNow(string HBillTypeID, Int64 HBillInterID,string sBillNo, Int64 HCheckFlowID, string sMsg, int sStatus, string HBillName)
|
{
|
Xt_BillCheckFlowStatusNow oCheck = new Xt_BillCheckFlowStatusNow();
|
oCheck.HBillTypeID = HBillTypeID;
|
oCheck.HBillInterID = HBillInterID;
|
oCheck.HCheckFlowID = HCheckFlowID;
|
oCheck.sBillNo = sBillNo;
|
oCheck.lblMsg.Text = sMsg;
|
oCheck.HBillName = HBillName;
|
oCheck.sStatus = sStatus;
|
if (sStatus == 1)
|
{
|
oCheck.button1.Text = "审核";
|
}
|
else if (sStatus == 2)
|
{
|
oCheck.button1.Text = "反审";
|
}
|
else if (sStatus == 0)
|
{
|
oCheck.button1.Text = "确定";
|
oCheck.button1.Visible = false;
|
}
|
oCheck.ShowDialog();
|
return;
|
}
|
|
|
#endregion
|
}
|
}
|