コード例 #1
0
        public static BG_ProPay AddBG_ProPay(BG_ProPay bG_ProPay)
        {
            string sql =
                "INSERT BG_ProPay (DepID, ProPYear, PPID, ProPA0M)" +
                "VALUES (@DepID, @ProPYear, @PPID, @ProPA0M)";

            sql += " ; SELECT @@IDENTITY";

            try
            {
                SqlParameter[] para = new SqlParameter[]
                {
                    new SqlParameter("@DepID", bG_ProPay.DepID),
                    new SqlParameter("@ProPYear", bG_ProPay.ProPYear),
                    new SqlParameter("@PPID", bG_ProPay.PPID),
                    new SqlParameter("@ProPA0M", bG_ProPay.ProPA0M)
                };

                string IdStr = DBUnity.ExecuteScalar(CommandType.Text, sql, para);
                int    newId = Convert.ToInt32(IdStr);
                return(GetBG_ProPayByProPID(newId));
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
                throw e;
            }
        }
コード例 #2
0
        public static BG_ProPay GetBG_ProPayByProPID(int proPID)
        {
            string sql = "SELECT * FROM BG_ProPay WHERE ProPID = @ProPID";

            try
            {
                SqlParameter para = new SqlParameter("@ProPID", proPID);
                DataTable    dt   = DBUnity.AdapterToTab(sql, para);

                if (dt.Rows.Count > 0)
                {
                    BG_ProPay bG_ProPay = new BG_ProPay();

                    bG_ProPay.ProPID   = dt.Rows[0]["ProPID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["ProPID"];
                    bG_ProPay.DepID    = dt.Rows[0]["DepID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["DepID"];
                    bG_ProPay.ProPYear = dt.Rows[0]["ProPYear"] == DBNull.Value ? DateTime.MinValue : (DateTime)dt.Rows[0]["ProPYear"];
                    bG_ProPay.PPID     = dt.Rows[0]["PPID"] == DBNull.Value ? "" : (string)dt.Rows[0]["PPID"];
                    bG_ProPay.ProPA0M  = dt.Rows[0]["ProPA0M"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["ProPA0M"];

                    return(bG_ProPay);
                }
                else
                {
                    return(null);
                }
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
                throw e;
            }
        }
コード例 #3
0
    protected void btnAdd4_Click(object sender, DirectEventArgs e)
    {
        BG_ProPay pp = new BG_ProPay();

        pp.DepID    = AreaDepID;
        pp.ProPYear = DateTime.Now;
        pp.PPID     = ID.ToString();
        pp.ProPA0M  = Field;
        BG_ProPayManager.AddBG_ProPay(pp);
        //PreviewDataBind();
    }
コード例 #4
0
        public static bool ModifyBG_ProPay(BG_ProPay bG_ProPay)
        {
            string sql =
                "UPDATE BG_ProPay " +
                "SET " +
                "DepID = @DepID, " +
                "ProPYear = @ProPYear, " +
                "PPID = @PPID, " +
                "ProPA0M = @ProPA0M " +
                "WHERE ProPID = @ProPID";


            try
            {
                SqlParameter[] para = new SqlParameter[]
                {
                    new SqlParameter("@ProPID", bG_ProPay.ProPID),
                    new SqlParameter("@DepID", bG_ProPay.DepID),
                    new SqlParameter("@ProPYear", bG_ProPay.ProPYear),
                    new SqlParameter("@PPID", bG_ProPay.PPID),
                    new SqlParameter("@ProPA0M", bG_ProPay.ProPA0M)
                };

                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;
            }
        }
コード例 #5
0
 public static bool DeleteBG_ProPay(BG_ProPay bG_ProPay)
 {
     return(DeleteBG_ProPayByProPID(bG_ProPay.ProPID));
 }
コード例 #6
0
    private void IsnotBG_ProBasiPerPay()
    {
        byte[]    bt;
        DataTable dt1 = new DataTable();
        DataTable dt2 = new DataTable();
        DataTable dt3 = new DataTable();
        DataTable dt4 = new DataTable();

        if (FUFEXC.HasFile)
        {
            bt  = FUFEXC.FileBytes;
            dt1 = ImportFinaDataLogic.GetDTBySheetname("基人一", bt, 9, 10);
            dt2 = ImportFinaDataLogic.GetDTBySheetname("基人二", bt, 10, 12);
            dt3 = ImportFinaDataLogic.GetDTBySheetname("基公", bt, 9, 21);
            dt4 = ImportFinaDataLogic.GetDTBySheetname("项目支出", bt, 9, 15);
        }
        else
        {
            Response.Write("没有数据");
        }
        bt = null;

        DateTime            dtime  = Convert.ToDateTime(CurrentYear + "-" + "01-" + "01");
        BG_ProBasiPerPayOne PBPPOM = new BG_ProBasiPerPayOne();

        PBPPOM.POBS    = ParToDecimal.ParToDel(dt1.Rows[0][4].ToString());
        PBPPOM.POAS    = ParToDecimal.ParToDel(dt1.Rows[0][5].ToString());
        PBPPOM.POBonus = ParToDecimal.ParToDel(dt1.Rows[0][6].ToString());
        PBPPOM.POPS    = ParToDecimal.ParToDel(dt1.Rows[0][7].ToString());
        PBPPOM.POSE    = ParToDecimal.ParToDel(dt1.Rows[0][8].ToString());
        PBPPOM.POOther = ParToDecimal.ParToDel(dt1.Rows[0][9].ToString());
        PBPPOM.POTitol = ParToDecimal.ParToDel(dt1.Rows[0][3].ToString());
        PBPPOM.POYear  = dtime;
        PBPPOM.DepID   = AreaDepID;
        BG_ProBasiPerPayOneManager.AddBG_ProBasiPerPayOne(PBPPOM);

        BG_ProBasiPerPayTwo PBPPT = new BG_ProBasiPerPayTwo();

        PBPPT.RetiredPerP    = ParToDecimal.ParToDel(dt2.Rows[0][5].ToString());
        PBPPT.RetiredPubP    = ParToDecimal.ParToDel(dt2.Rows[0][6].ToString());
        PBPPT.RetirementPerP = ParToDecimal.ParToDel(dt2.Rows[0][9].ToString());
        PBPPT.RetirementPubP = ParToDecimal.ParToDel(dt2.Rows[0][8].ToString());
        PBPPT.PTME           = ParToDecimal.ParToDel(dt2.Rows[0][10].ToString());
        PBPPT.PTOther        = ParToDecimal.ParToDel(dt2.Rows[0][11].ToString());
        PBPPT.PTTitol        = ParToDecimal.ParToDel(dt2.Rows[0][3].ToString());
        PBPPT.PTYear         = dtime;
        PBPPT.DepID          = AreaDepID;
        BG_ProBasiPerPayTwoManager.AddBG_ProBasiPerPayTwo(PBPPT);

        BG_ProBasiPubPay PBPP = new BG_ProBasiPubPay();

        PBPP.PBOE        = ParToDecimal.ParToDel(dt3.Rows[0][5].ToString());
        PBPP.PBUtilities = ParToDecimal.ParToDel(dt3.Rows[0][6].ToString());
        PBPP.PBPF        = ParToDecimal.ParToDel(dt3.Rows[0][7].ToString());
        PBPP.OBCFE       = ParToDecimal.ParToDel(dt3.Rows[0][8].ToString());
        PBPP.PBTravelE   = ParToDecimal.ParToDel(dt3.Rows[0][9].ToString());
        PBPP.PBRE        = ParToDecimal.ParToDel(dt3.Rows[0][10].ToString());
        PBPP.PBME        = ParToDecimal.ParToDel(dt3.Rows[0][11].ToString());
        PBPP.PBTrainE    = ParToDecimal.ParToDel(dt3.Rows[0][12].ToString());
        PBPP.OBRE        = ParToDecimal.ParToDel(dt3.Rows[0][13].ToString());
        PBPP.PBAE        = ParToDecimal.ParToDel(dt3.Rows[0][14].ToString());
        PBPP.LUMD        = ParToDecimal.ParToDel(dt3.Rows[0][15].ToString());
        PBPP.PBWE        = ParToDecimal.ParToDel(dt3.Rows[0][16].ToString());
        PBPP.PBOCE       = ParToDecimal.ParToDel(dt3.Rows[0][17].ToString());
        PBPP.OCASE       = ParToDecimal.ParToDel(dt3.Rows[0][19].ToString());
        PBPP.PBIDTitol   = ParToDecimal.ParToDel(dt3.Rows[0][3].ToString());
        PBPP.PBYear      = dtime;
        PBPP.DepID       = AreaDepID;
        BG_ProBasiPubPayManager.AddBG_ProBasiPubPay(PBPP);

        for (int i = 0; i < dt4.Rows.Count; i++)
        {
            if (string.IsNullOrEmpty(dt4.Rows[i][3].ToString()))
            {
                return;
            }
            BG_ProPay PP = new BG_ProPay();
            PP.PPID     = dt4.Rows[i][3].ToString().Trim();
            PP.ProPA0M  = ParToDecimal.ParToDel(dt4.Rows[i][4].ToString());
            PP.ProPYear = dtime;
            PP.DepID    = AreaDepID;
            BG_ProPayManager.AddBG_ProPay(PP);
        }
        X.Msg.Alert("提示", "导入成功.").Show();
    }
コード例 #7
0
 public static bool ModifyBG_ProPay(BG_ProPay bG_ProPay)
 {
     return(BG_ProPayService.ModifyBG_ProPay(bG_ProPay));
 }
コード例 #8
0
 public static bool DeleteBG_ProPay(BG_ProPay bG_ProPay)
 {
     return(BG_ProPayService.DeleteBG_ProPay(bG_ProPay));
 }
コード例 #9
0
 public static BG_ProPay AddBG_ProPay(BG_ProPay bG_ProPay)
 {
     return(BG_ProPayService.AddBG_ProPay(bG_ProPay));
 }