public static BG_MonPayPlan_His AddBG_MonPayPlan_His(BG_MonPayPlan_His bG_MonPayPlan_His)
{
string sql =
"INSERT BG_MonPayPlan_His (PIID, MPFunding, DeptID, MPTime, MPRemark, CPID, MPPHisTime, MPFundingAdd, MPFundingAddTimes)" +
"VALUES (@PIID, @MPFunding, @DeptID, @MPTime, @MPRemark, @CPID, @MPPHisTime, @MPFundingAdd, @MPFundingAddTimes)";
sql += " ; SELECT @@IDENTITY";
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@PIID", bG_MonPayPlan_His.PIID),
new SqlParameter("@MPFunding", bG_MonPayPlan_His.MPFunding),
new SqlParameter("@DeptID", bG_MonPayPlan_His.DeptID),
new SqlParameter("@MPTime", bG_MonPayPlan_His.MPTime),
new SqlParameter("@MPRemark", bG_MonPayPlan_His.MPRemark),
new SqlParameter("@CPID", bG_MonPayPlan_His.CPID),
new SqlParameter("@MPPHisTime", bG_MonPayPlan_His.MPPHisTime),
new SqlParameter("@MPFundingAdd", bG_MonPayPlan_His.MPFundingAdd),
new SqlParameter("@MPFundingAddTimes", bG_MonPayPlan_His.MPFundingAddTimes)
};
string IdStr = DBUnity.ExecuteScalar(CommandType.Text, sql, para);
int newId = Convert.ToInt32(IdStr);
return GetBG_MonPayPlan_HisByMPPHis(newId);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
private void DoAuditExit(string YearMonth, int depid, int pici, int prid)
{
BG_MonPayPlanRemark mppr = BG_MonPayPlanRemarkManager.GetBG_MonPayPlanRemarkByPRID(prid);
mppr.MASta = "退回";
mppr.MACause = txtReason.Text;
BG_MonPayPlanRemarkManager.ModifyBG_MonPayPlanRemark(mppr);
DataTable paydt = BG_MonPayPlanGenerateLogic.GetMonPayTimepici(YearMonth, depid, pici);
for (int i = 0; i < paydt.Rows.Count; i++)
{
BG_MonPayPlan_His bgMonPayPlanHis = new BG_MonPayPlan_His();
bgMonPayPlanHis.CPID = common.IntSafeConvert(paydt.Rows[i]["CPID"]);
bgMonPayPlanHis.DeptID = depid;
bgMonPayPlanHis.MPFunding = ParseUtil.ToDecimal(paydt.Rows[i]["MPFunding"].ToString(), 0);
bgMonPayPlanHis.MPPHisTime = DateTime.Now;
bgMonPayPlanHis.PIID = common.IntSafeConvert(paydt.Rows[i]["PIID"]);
bgMonPayPlanHis.MPRemark = "退回";
bgMonPayPlanHis.MPFundingAdd = ParseUtil.ToDecimal(paydt.Rows[i]["MPFundingAdd"].ToString(), 0);
bgMonPayPlanHis.MPTime = Convert.ToDateTime(paydt.Rows[i]["MPTime"]);
bgMonPayPlanHis.MPFundingAddTimes = common.IntSafeConvert(paydt.Rows[i]["MPFundingAddTimes"]);
BG_MonPayPlan_HisManager.AddBG_MonPayPlan_His(bgMonPayPlanHis);
}
}
public static bool ModifyBG_MonPayPlan_His(BG_MonPayPlan_His bG_MonPayPlan_His)
{
return BG_MonPayPlan_HisService.ModifyBG_MonPayPlan_His(bG_MonPayPlan_His);
}
public static bool DeleteBG_MonPayPlan_His(BG_MonPayPlan_His bG_MonPayPlan_His)
{
return BG_MonPayPlan_HisService.DeleteBG_MonPayPlan_His(bG_MonPayPlan_His);
}
public static BG_MonPayPlan_His AddBG_MonPayPlan_His(BG_MonPayPlan_His bG_MonPayPlan_His)
{
return BG_MonPayPlan_HisService.AddBG_MonPayPlan_His(bG_MonPayPlan_His);
}
private static void DoAudit(string YearMonth, int depid, int pici, DataTable dt, int prid)
{
BG_MonPayPlanRemark mppr = BG_MonPayPlanRemarkManager.GetBG_MonPayPlanRemarkByPRID(prid);
mppr.MASta = "审核通过";
if (BG_MonPayPlanRemarkManager.ModifyBG_MonPayPlanRemark(mppr))
{
DataTable paydt = BG_MonPayPlanGenerateLogic.GetMonPayTimepici(YearMonth, depid, pici);
for (int i = 0; i < paydt.Rows.Count; i++)
{
BG_MonPayPlan_His bgMonPayPlanHis = new BG_MonPayPlan_His();
bgMonPayPlanHis.CPID = common.IntSafeConvert(paydt.Rows[i]["CPID"]);
bgMonPayPlanHis.DeptID = depid;
bgMonPayPlanHis.MPFunding = ParseUtil.ToDecimal(paydt.Rows[i]["MPFunding"].ToString(), 0);
bgMonPayPlanHis.MPPHisTime = DateTime.Now;
bgMonPayPlanHis.PIID = common.IntSafeConvert(paydt.Rows[i]["PIID"]);
bgMonPayPlanHis.MPRemark = "审核通过";
bgMonPayPlanHis.MPFundingAdd = ParseUtil.ToDecimal(paydt.Rows[i]["MPFundingAdd"].ToString(), 0);
bgMonPayPlanHis.MPTime = Convert.ToDateTime(paydt.Rows[i]["MPTime"]);
bgMonPayPlanHis.MPFundingAddTimes = common.IntSafeConvert(paydt.Rows[i]["MPFundingAddTimes"]);
BG_MonPayPlan_HisManager.AddBG_MonPayPlan_His(bgMonPayPlanHis);
}
for (int i = 0; i < dt.Rows.Count; i++)
{
int CashierID = BG_CashierLogic.GetCashierIDAudit_RemarkByPiid(depid, YearMonth,
common.IntSafeConvert(dt.Rows[i]["PIID"]));
if (CashierID > 0)
{
BG_Cashier bgCashier = BG_CashierManager.GetBG_CashierByCashierid(CashierID);
bgCashier.BQMon += ParToDecimal.ParToDel(dt.Rows[i]["MPFundingAdd"].ToString());
bgCashier.BgMon += ParToDecimal.ParToDel(dt.Rows[i]["MPFundingAdd"].ToString());
bgCashier.CashierBalance += ParToDecimal.ParToDel(dt.Rows[i]["MPFundingAdd"].ToString());
bgCashier.CZMon = 0;
bgCashier.QTMon = 0;
bgCashier.CTime = mppr.MATime;
bgCashier.Piid = common.IntSafeConvert(dt.Rows[i]["PIID"]);
bgCashier.DepID = mppr.DeptID;
BG_CashierManager.ModifyBG_Cashier(bgCashier);
}
else
{
BG_Cashier bgCashier = new BG_Cashier();
bgCashier.BQMon += ParToDecimal.ParToDel(dt.Rows[i]["MPFundingAdd"].ToString());
bgCashier.BgMon += ParToDecimal.ParToDel(dt.Rows[i]["MPFundingAdd"].ToString());
bgCashier.CashierBalance += ParToDecimal.ParToDel(dt.Rows[i]["MPFundingAdd"].ToString());
bgCashier.CZMon = 0;
bgCashier.QTMon = 0;
bgCashier.CTime = mppr.MATime;
bgCashier.Piid = common.IntSafeConvert(dt.Rows[i]["PIID"]);
bgCashier.DepID = mppr.DeptID;
BG_CashierManager.AddBG_Cashier(bgCashier);
}
}
}
}
public static bool DeleteBG_MonPayPlan_His(BG_MonPayPlan_His bG_MonPayPlan_His)
{
return DeleteBG_MonPayPlan_HisByMPPHis( bG_MonPayPlan_His.MPPHis );
}
public static bool ModifyBG_MonPayPlan_His(BG_MonPayPlan_His bG_MonPayPlan_His)
{
string sql =
"UPDATE BG_MonPayPlan_His " +
"SET " +
"PIID = @PIID, " +
"MPFunding = @MPFunding, " +
"DeptID = @DeptID, " +
"MPTime = @MPTime, " +
"MPRemark = @MPRemark, " +
"CPID = @CPID, " +
"MPPHisTime = @MPPHisTime, " +
"MPFundingAdd = @MPFundingAdd, " +
"MPFundingAddTimes = @MPFundingAddTimes " +
"WHERE MPPHis = @MPPHis";
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@MPPHis", bG_MonPayPlan_His.MPPHis),
new SqlParameter("@PIID", bG_MonPayPlan_His.PIID),
new SqlParameter("@MPFunding", bG_MonPayPlan_His.MPFunding),
new SqlParameter("@DeptID", bG_MonPayPlan_His.DeptID),
new SqlParameter("@MPTime", bG_MonPayPlan_His.MPTime),
new SqlParameter("@MPRemark", bG_MonPayPlan_His.MPRemark),
new SqlParameter("@CPID", bG_MonPayPlan_His.CPID),
new SqlParameter("@MPPHisTime", bG_MonPayPlan_His.MPPHisTime),
new SqlParameter("@MPFundingAdd", bG_MonPayPlan_His.MPFundingAdd),
new SqlParameter("@MPFundingAddTimes", bG_MonPayPlan_His.MPFundingAddTimes)
};
int t = DBUnity.ExecuteNonQuery(CommandType.Text, sql, para);
if(t>0)
{
return true;
}
else
{
return false;
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
public static BG_MonPayPlan_His GetBG_MonPayPlan_HisByMPPHis(int mPPHis)
{
string sql = "SELECT * FROM BG_MonPayPlan_His WHERE MPPHis = @MPPHis";
try
{
SqlParameter para = new SqlParameter("@MPPHis", mPPHis);
DataTable dt = DBUnity.AdapterToTab(sql, para);
if(dt.Rows.Count > 0)
{
BG_MonPayPlan_His bG_MonPayPlan_His = new BG_MonPayPlan_His();
bG_MonPayPlan_His.MPPHis = dt.Rows[0]["MPPHis"] == DBNull.Value ? 0 : (int)dt.Rows[0]["MPPHis"];
bG_MonPayPlan_His.PIID = dt.Rows[0]["PIID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PIID"];
bG_MonPayPlan_His.MPFunding = dt.Rows[0]["MPFunding"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["MPFunding"];
bG_MonPayPlan_His.DeptID = dt.Rows[0]["DeptID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["DeptID"];
bG_MonPayPlan_His.MPTime = dt.Rows[0]["MPTime"] == DBNull.Value ? DateTime.MinValue : (DateTime)dt.Rows[0]["MPTime"];
bG_MonPayPlan_His.MPRemark = dt.Rows[0]["MPRemark"] == DBNull.Value ? "" : (string)dt.Rows[0]["MPRemark"];
bG_MonPayPlan_His.CPID = dt.Rows[0]["CPID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["CPID"];
bG_MonPayPlan_His.MPPHisTime = dt.Rows[0]["MPPHisTime"] == DBNull.Value ? DateTime.MinValue : (DateTime)dt.Rows[0]["MPPHisTime"];
bG_MonPayPlan_His.MPFundingAdd = dt.Rows[0]["MPFundingAdd"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["MPFundingAdd"];
bG_MonPayPlan_His.MPFundingAddTimes = dt.Rows[0]["MPFundingAddTimes"] == DBNull.Value ? 0 : (int)dt.Rows[0]["MPFundingAddTimes"];
return bG_MonPayPlan_His;
}
else
{
return null;
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
