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