public static BG_Cashier AddBG_Cashier(BG_Cashier bG_Cashier) { string sql = "INSERT BG_Cashier (Piid, BgMon, CZMon, QTMon, BQMon, DepID, CTime, CashierBalance)" + "VALUES (@Piid, @BgMon, @CZMon, @QTMon, @BQMon, @DepID, @CTime, @CashierBalance)"; sql += " ; SELECT @@IDENTITY"; try { SqlParameter[] para = new SqlParameter[] { new SqlParameter("@Piid", bG_Cashier.Piid), new SqlParameter("@BgMon", bG_Cashier.BgMon), new SqlParameter("@CZMon", bG_Cashier.CZMon), new SqlParameter("@QTMon", bG_Cashier.QTMon), new SqlParameter("@BQMon", bG_Cashier.BQMon), new SqlParameter("@DepID", bG_Cashier.DepID), new SqlParameter("@CTime", bG_Cashier.CTime), new SqlParameter("@CashierBalance", bG_Cashier.CashierBalance) }; string IdStr = DBUnity.ExecuteScalar(CommandType.Text, sql, para); int newId = Convert.ToInt32(IdStr); return GetBG_CashierByCashierid(newId); } catch (Exception e) { Console.WriteLine(e.Message); throw e; } }
public static bool ModifyBG_Cashier(BG_Cashier bG_Cashier) { return BG_CashierService.ModifyBG_Cashier(bG_Cashier); }
public static bool DeleteBG_Cashier(BG_Cashier bG_Cashier) { return BG_CashierService.DeleteBG_Cashier(bG_Cashier); }
public static BG_Cashier AddBG_Cashier(BG_Cashier bG_Cashier) { return BG_CashierService.AddBG_Cashier(bG_Cashier); }
public static bool DeleteBG_Cashier(BG_Cashier bG_Cashier) { return DeleteBG_CashierByCashierid( bG_Cashier.Cashierid ); }
public static bool ModifyBG_Cashier(BG_Cashier bG_Cashier) { string sql = "UPDATE BG_Cashier " + "SET " + "Piid = @Piid, " + "BgMon = @BgMon, " + "CZMon = @CZMon, " + "QTMon = @QTMon, " + "BQMon = @BQMon, " + "DepID = @DepID, " + "CTime = @CTime, " + "CashierBalance = @CashierBalance " + "WHERE Cashierid = @Cashierid"; try { SqlParameter[] para = new SqlParameter[] { new SqlParameter("@Cashierid", bG_Cashier.Cashierid), new SqlParameter("@Piid", bG_Cashier.Piid), new SqlParameter("@BgMon", bG_Cashier.BgMon), new SqlParameter("@CZMon", bG_Cashier.CZMon), new SqlParameter("@QTMon", bG_Cashier.QTMon), new SqlParameter("@BQMon", bG_Cashier.BQMon), new SqlParameter("@DepID", bG_Cashier.DepID), new SqlParameter("@CTime", bG_Cashier.CTime), new SqlParameter("@CashierBalance", bG_Cashier.CashierBalance) }; 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_Cashier GetBG_CashierByCashierid(int cashierid) { string sql = "SELECT * FROM BG_Cashier WHERE Cashierid = @Cashierid"; try { SqlParameter para = new SqlParameter("@Cashierid", cashierid); DataTable dt = DBUnity.AdapterToTab(sql, para); if(dt.Rows.Count > 0) { BG_Cashier bG_Cashier = new BG_Cashier(); bG_Cashier.Cashierid = dt.Rows[0]["Cashierid"] == DBNull.Value ? 0 : (int)dt.Rows[0]["Cashierid"]; bG_Cashier.Piid = dt.Rows[0]["Piid"] == DBNull.Value ? 0 : (int)dt.Rows[0]["Piid"]; bG_Cashier.BgMon = dt.Rows[0]["BgMon"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["BgMon"]; bG_Cashier.CZMon = dt.Rows[0]["CZMon"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["CZMon"]; bG_Cashier.QTMon = dt.Rows[0]["QTMon"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["QTMon"]; bG_Cashier.BQMon = dt.Rows[0]["BQMon"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["BQMon"]; bG_Cashier.DepID = dt.Rows[0]["DepID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["DepID"]; bG_Cashier.CTime = dt.Rows[0]["CTime"] == DBNull.Value ? DateTime.MinValue : (DateTime)dt.Rows[0]["CTime"]; bG_Cashier.CashierBalance = dt.Rows[0]["CashierBalance"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["CashierBalance"]; return bG_Cashier; } 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); } } } }