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);
    }
Ejemplo n.º 2
0
    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;
            }
        }
Ejemplo n.º 5
0
    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));
 }