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