private void DoAudit(string YearMonth, int depid, int pici, int prid) { BG_MonPayPlanRemark mppr = BG_MonPayPlanRemarkManager.GetBG_MonPayPlanRemarkByPRID(prid); mppr.MASta = "提交"; BG_MonPayPlanRemarkManager.ModifyBG_MonPayPlanRemark(mppr); }
private void DoAuditExit(string YearMonth, int depid, int pici, DataTable dt, 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, common.IntSafeConvert(cmbpici.SelectedItem.Text)); 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 BG_MonPayPlanRemark AddBG_MonPayPlanRemark(BG_MonPayPlanRemark bG_MonPayPlanRemark) { string sql = "INSERT BG_MonPayPlanRemark (DeptID, MATime, MASta, MACause, MAUser, MATimes)" + "VALUES (@DeptID, @MATime, @MASta, @MACause, @MAUser, @MATimes)"; sql += " ; SELECT @@IDENTITY"; try { SqlParameter[] para = new SqlParameter[] { new SqlParameter("@DeptID", bG_MonPayPlanRemark.DeptID), new SqlParameter("@MATime", bG_MonPayPlanRemark.MATime), new SqlParameter("@MASta", bG_MonPayPlanRemark.MASta), new SqlParameter("@MACause", bG_MonPayPlanRemark.MACause), new SqlParameter("@MAUser", bG_MonPayPlanRemark.MAUser), new SqlParameter("@MATimes", bG_MonPayPlanRemark.MATimes) }; string IdStr = DBUnity.ExecuteScalar(CommandType.Text, sql, para); int newId = Convert.ToInt32(IdStr); return(GetBG_MonPayPlanRemarkByPRID(newId)); } catch (Exception e) { Console.WriteLine(e.Message); throw e; } }
public static BG_MonPayPlanRemark GetBG_MonPayPlanRemarkByPRID(int pRID) { string sql = "SELECT * FROM BG_MonPayPlanRemark WHERE PRID = @PRID"; try { SqlParameter para = new SqlParameter("@PRID", pRID); DataTable dt = DBUnity.AdapterToTab(sql, para); if (dt.Rows.Count > 0) { BG_MonPayPlanRemark bG_MonPayPlanRemark = new BG_MonPayPlanRemark(); bG_MonPayPlanRemark.PRID = dt.Rows[0]["PRID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PRID"]; bG_MonPayPlanRemark.DeptID = dt.Rows[0]["DeptID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["DeptID"]; bG_MonPayPlanRemark.MATime = dt.Rows[0]["MATime"] == DBNull.Value ? DateTime.MinValue : (DateTime)dt.Rows[0]["MATime"]; bG_MonPayPlanRemark.MASta = dt.Rows[0]["MASta"] == DBNull.Value ? "" : (string)dt.Rows[0]["MASta"]; bG_MonPayPlanRemark.MACause = dt.Rows[0]["MACause"] == DBNull.Value ? "" : (string)dt.Rows[0]["MACause"]; bG_MonPayPlanRemark.MAUser = dt.Rows[0]["MAUser"] == DBNull.Value ? "" : (string)dt.Rows[0]["MAUser"]; bG_MonPayPlanRemark.MATimes = dt.Rows[0]["MATimes"] == DBNull.Value ? 0 : (int)dt.Rows[0]["MATimes"]; return(bG_MonPayPlanRemark); } else { return(null); } } catch (Exception e) { Console.WriteLine(e.Message); throw e; } }
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 ModifyBG_MonPayPlanRemark(BG_MonPayPlanRemark bG_MonPayPlanRemark) { string sql = "UPDATE BG_MonPayPlanRemark " + "SET " + "DeptID = @DeptID, " + "MATime = @MATime, " + "MASta = @MASta, " + "MACause = @MACause, " + "MAUser = @MAUser, " + "MATimes = @MATimes " + "WHERE PRID = @PRID"; try { SqlParameter[] para = new SqlParameter[] { new SqlParameter("@PRID", bG_MonPayPlanRemark.PRID), new SqlParameter("@DeptID", bG_MonPayPlanRemark.DeptID), new SqlParameter("@MATime", bG_MonPayPlanRemark.MATime), new SqlParameter("@MASta", bG_MonPayPlanRemark.MASta), new SqlParameter("@MACause", bG_MonPayPlanRemark.MACause), new SqlParameter("@MAUser", bG_MonPayPlanRemark.MAUser), new SqlParameter("@MATimes", bG_MonPayPlanRemark.MATimes) }; 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 bool ModifyBG_MonPayPlanRemark(BG_MonPayPlanRemark bG_MonPayPlanRemark) { return(BG_MonPayPlanRemarkService.ModifyBG_MonPayPlanRemark(bG_MonPayPlanRemark)); }
public static bool DeleteBG_MonPayPlanRemark(BG_MonPayPlanRemark bG_MonPayPlanRemark) { return(BG_MonPayPlanRemarkService.DeleteBG_MonPayPlanRemark(bG_MonPayPlanRemark)); }
public static BG_MonPayPlanRemark AddBG_MonPayPlanRemark(BG_MonPayPlanRemark bG_MonPayPlanRemark) { return(BG_MonPayPlanRemarkService.AddBG_MonPayPlanRemark(bG_MonPayPlanRemark)); }
public static bool DeleteBG_MonPayPlanRemark(BG_MonPayPlanRemark bG_MonPayPlanRemark) { return(DeleteBG_MonPayPlanRemarkByPRID(bG_MonPayPlanRemark.PRID)); }