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