/// <summary> /// 添加一条报销单据 /// </summary> /// <param name="arid">报销单据</param> /// <returns>bool</returns> public static bool AddARID(BG_ReimDocuments arid) { bool falg = false; try { string sqlStr = @"insert into BG_ReimDocuments(ARID,RDType,RDCont,RDTime)values(@ARID,@RDType,@RDCont,@RDTime)"; SqlParameter[] Pars = new SqlParameter[] { new SqlParameter("@ARID", arid.ARID), new SqlParameter("@RDType", arid.RDType), new SqlParameter("@RDCont", arid.RDCont), new SqlParameter("@RDTime", arid.RDTime) }; falg = DBUnity.ExecuteNonQuery(CommandType.Text, sqlStr, Pars) > 0; } catch (Exception ex) { falg = false; Log.WriteLog(ex.Message, "BudgetSys.DAL.BGReimDocumentsService.AddARID"); } return(falg); }
public static bool ModifyBG_ProvBudItems(BG_ProvBudItems bG_ProvBudItems) { string sql = "UPDATE BG_ProvBudItems " + "SET " + "PBType = @PBType, " + "PBMon = @PBMon, " + "PBYear = @PBYear, " + "DepID = @DepID " + "WHERE PBID = @PBID"; try { SqlParameter[] para = new SqlParameter[] { new SqlParameter("@PBID", bG_ProvBudItems.PBID), new SqlParameter("@PBType", bG_ProvBudItems.PBType), new SqlParameter("@PBMon", bG_ProvBudItems.PBMon), new SqlParameter("@PBYear", bG_ProvBudItems.PBYear), new SqlParameter("@DepID", bG_ProvBudItems.DepID) }; 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; } }
internal static DataTable GetApplyReimburByDepID(int DepID, int year) { DataTable dt = new DataTable(); try { string sqlStr = string.Format("select * from BG_BudItems where DepID={0} and BIYear={1} order by BudID desc", DepID, year); if (DepID == 0) { sqlStr = string.Format("select * from BG_BudItems order by BudID desc"); } dt = DBUnity.AdapterToTab(sqlStr); } catch (Exception ex) { dt = new DataTable(); Log.WriteLog(ex.Message, "BGBudItemsService--GetApplyReimburByDepID"); } return(dt); }
public static bool ModifyBG_Quota(BG_Quota bG_Quota) { string sql = "UPDATE BG_Quota " + "SET " + "PIID = @PIID, " + "Money = @Money, " + "Qtime = @Qtime, " + "DepID = @DepID " + "WHERE QtID = @QtID"; try { SqlParameter[] para = new SqlParameter[] { new SqlParameter("@QtID", bG_Quota.QtID), new SqlParameter("@PIID", bG_Quota.PIID), new SqlParameter("@Money", bG_Quota.Money), new SqlParameter("@Qtime", bG_Quota.Qtime), new SqlParameter("@DepID", bG_Quota.DepID) }; 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_FixedAssets(BG_FixedAssets bG_FixedAssets) { string sql = "UPDATE BG_FixedAssets " + "SET " + "FACode = @FACode, " + "FAMon = @FAMon, " + "FAYear = @FAYear, " + "FAMonth = @FAMonth " + "WHERE FAID = @FAID"; try { SqlParameter[] para = new SqlParameter[] { new SqlParameter("@FAID", bG_FixedAssets.FAID), new SqlParameter("@FACode", bG_FixedAssets.FACode), new SqlParameter("@FAMon", bG_FixedAssets.FAMon), new SqlParameter("@FAYear", bG_FixedAssets.FAYear), new SqlParameter("@FAMonth", bG_FixedAssets.FAMonth) }; 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_ReimDocuments(BG_ReimDocuments bG_ReimDocuments) { string sql = "UPDATE BG_ReimDocuments " + "SET " + "ARID = @ARID, " + "RDType = @RDType, " + "RDCont = @RDCont, " + "RDTime = @RDTime " + "WHERE RDID = @RDID"; try { SqlParameter[] para = new SqlParameter[] { new SqlParameter("@RDID", bG_ReimDocuments.RDID), new SqlParameter("@ARID", bG_ReimDocuments.ARID), new SqlParameter("@RDType", bG_ReimDocuments.RDType), new SqlParameter("@RDCont", bG_ReimDocuments.RDCont), new SqlParameter("@RDTime", bG_ReimDocuments.RDTime) }; 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_ProBasiPerPayTwo GetBG_ProBasiPerPayTwoByPTID(int pTID) { string sql = "SELECT * FROM BG_ProBasiPerPayTwo WHERE PTID = @PTID"; try { SqlParameter para = new SqlParameter("@PTID", pTID); DataTable dt = DBUnity.AdapterToTab(sql, para); if (dt.Rows.Count > 0) { BG_ProBasiPerPayTwo bG_ProBasiPerPayTwo = new BG_ProBasiPerPayTwo(); bG_ProBasiPerPayTwo.PTID = dt.Rows[0]["PTID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PTID"]; bG_ProBasiPerPayTwo.DepID = dt.Rows[0]["DepID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["DepID"]; bG_ProBasiPerPayTwo.PTYear = dt.Rows[0]["PTYear"] == DBNull.Value ? DateTime.MinValue : (DateTime)dt.Rows[0]["PTYear"]; bG_ProBasiPerPayTwo.RetiredPerP = dt.Rows[0]["RetiredPerP"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["RetiredPerP"]; bG_ProBasiPerPayTwo.RetiredPubP = dt.Rows[0]["RetiredPubP"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["RetiredPubP"]; bG_ProBasiPerPayTwo.RetirementPerP = dt.Rows[0]["RetirementPerP"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["RetirementPerP"]; bG_ProBasiPerPayTwo.RetirementPubP = dt.Rows[0]["RetirementPubP"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["RetirementPubP"]; bG_ProBasiPerPayTwo.PTHF = dt.Rows[0]["PTHF"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["PTHF"]; bG_ProBasiPerPayTwo.PTME = dt.Rows[0]["PTME"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["PTME"]; bG_ProBasiPerPayTwo.PTOther = dt.Rows[0]["PTOther"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["PTOther"]; bG_ProBasiPerPayTwo.PTTitol = dt.Rows[0]["PTTitol"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["PTTitol"]; return(bG_ProBasiPerPayTwo); } else { return(null); } } catch (Exception e) { Console.WriteLine(e.Message); throw e; } }
/// <summary> /// 添加一条附件信息 /// </summary> /// <param name="radid">附件</param> /// <returns>bool</returns> public static bool AddAccessories(BG_ReimAppendix radid) { bool falg = false; try { string sqlStr = @"insert into BG_ReimAppendix(ARID,ARType,ARName,ARContent,ARTime) values(@ARID,@ARType,@ARName,@ARContent,@ARTime)"; SqlParameter[] Pars = new SqlParameter[] { new SqlParameter("@ARID", radid.ARID), new SqlParameter("@ARType", radid.ARType), new SqlParameter("@ARName", radid.ARName), new SqlParameter("@ARContent", radid.ARContent), new SqlParameter("@ARTime", radid.ARTime) }; falg = DBUnity.ExecuteNonQuery(CommandType.Text, sqlStr, Pars) > 0; } catch { } return(falg); }
/// <summary> /// 修改指定报销附件信息 /// </summary> /// <param name="radid">附件信息</param> /// <returns>bool</returns> public static bool UpdAccessories(BG_ReimAppendix radid) { bool flag = false; try { string sqlStr = @"update BG_ReimAppendix set ARID=@ARID,ARType=@ARType,ARName=@ARName,ARContent=@ARContent,ARTime=@ARTime where RADID = @RADID"; SqlParameter[] Pars = new SqlParameter[] { new SqlParameter("@RADID", radid.RADID), new SqlParameter("@ARID", radid.ARID), new SqlParameter("@ARType", radid.ARType), new SqlParameter("@ARName", radid.ARName), new SqlParameter("@ARContent", radid.ARContent), new SqlParameter("@ARTime", radid.ARTime) }; flag = DBUnity.ExecuteNonQuery(CommandType.Text, sqlStr, Pars) > 0; } catch { } return(flag); }
/// <summary> /// 修改指定报销单据 /// </summary> /// <param name="arid">报销单据</param> /// <returns>bool</returns> public static bool UpdReimDocuments(BG_ReimDocuments arid) { bool flag = false; try { string sqlStr = @"update BG_ReimDocuments set RDType=@RDType,RDCont=@RDCont,RDTime=@RDTime where ARID=@ARID"; SqlParameter[] Pars = new SqlParameter[] { new SqlParameter("@ARID", arid.ARID), new SqlParameter("@RDType", arid.RDType), new SqlParameter("@RDCont", arid.RDCont), new SqlParameter("@RDTime", arid.RDTime) }; flag = DBUnity.ExecuteNonQuery(CommandType.Text, sqlStr, Pars) > 0; } catch (Exception ex) { flag = false; Log.WriteLog(ex.Message, "BudgetSys.DAL.BGReimDocumentsService.UpdReimDocuments"); } return(flag); }
/// <summary> ///显示退回原因 /// </summary> /// <param name="arid">申请表ID</param> /// <param name="arliststa">申请表状态</param> /// <returns>bool</returns> public static bool UpdApplication(string status, string txt, string idStrs) { bool flag = false; try { string sqlStr = "update BG_ApplyReimbur set ARListSta='{0}', ARReason='{1}' where ARID in ({2})"; //SqlParameter[] Pars = new SqlParameter[]{ // new SqlParameter("@ARID",arid), // new SqlParameter("@ARListSta",arliststa), // }; sqlStr = string.Format(sqlStr, status, txt, idStrs); flag = DBUnity.ExecuteNonQuery(CommandType.Text, sqlStr, null) > 0; } catch (Exception ex) { flag = false; Log.WriteLog(ex.Message, "BudgetSys.DAL.BGApplyReimburService.UpdApplication"); } return(flag); }
public static bool ModifyBG_SysSetting(BG_SysSetting bG_SysSetting) { string sql = "UPDATE BG_SysSetting " + "SET " + "SysName = @SysName, " + "DefaultYear = @DefaultYear, " + "PepNum = @PepNum " + "WHERE SSID = @SSID"; try { SqlParameter[] para = new SqlParameter[] { new SqlParameter("@SSID", bG_SysSetting.SSID), new SqlParameter("@SysName", bG_SysSetting.SysName), new SqlParameter("@DefaultYear", bG_SysSetting.DefaultYear), new SqlParameter("@PepNum", bG_SysSetting.PepNum) }; 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_Mon(BG_Mon bG_Mon) { string sql = "UPDATE BG_Mon " + "SET " + "BGMon = @BGMon, " + "BGYear = @BGYear, " + "IsEditMon = @IsEditMon " + "WHERE BGID = @BGID"; try { SqlParameter[] para = new SqlParameter[] { new SqlParameter("@BGID", bG_Mon.BGID), new SqlParameter("@BGMon", bG_Mon.BGMon), new SqlParameter("@BGYear", bG_Mon.BGYear), new SqlParameter("@IsEditMon", bG_Mon.IsEditMon) }; 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_PayWelExpen GetBG_PayWelExpenByPWEID(int pWEID) { string sql = "SELECT * FROM BG_PayWelExpen WHERE PWEID = @PWEID"; try { SqlParameter para = new SqlParameter("@PWEID", pWEID); DataTable dt = DBUnity.AdapterToTab(sql, para); if (dt.Rows.Count > 0) { BG_PayWelExpen bG_PayWelExpen = new BG_PayWelExpen(); bG_PayWelExpen.PWEID = dt.Rows[0]["PWEID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PWEID"]; bG_PayWelExpen.PWEYear = dt.Rows[0]["PWEYear"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PWEYear"]; bG_PayWelExpen.DepID = dt.Rows[0]["DepID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["DepID"]; bG_PayWelExpen.PWESubTotal = dt.Rows[0]["PWESubTotal"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["PWESubTotal"]; bG_PayWelExpen.PWEBasWage = dt.Rows[0]["PWEBasWage"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["PWEBasWage"]; bG_PayWelExpen.PWEAlloSub = dt.Rows[0]["PWEAlloSub"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["PWEAlloSub"]; bG_PayWelExpen.PWEPrize = dt.Rows[0]["PWEPrize"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["PWEPrize"]; bG_PayWelExpen.PWEPerWage = dt.Rows[0]["PWEPerWage"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["PWEPerWage"]; bG_PayWelExpen.PWESafePay = dt.Rows[0]["PWESafePay"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["PWESafePay"]; bG_PayWelExpen.PWEOth = dt.Rows[0]["PWEOth"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["PWEOth"]; return(bG_PayWelExpen); } else { return(null); } } catch (Exception e) { Console.WriteLine(e.Message); throw e; } }
public static BG_OutlayAna GetBG_OutlayAnaByOAID(int oAID) { string sql = "SELECT * FROM BG_OutlayAna WHERE OAID = @OAID"; try { SqlParameter para = new SqlParameter("@OAID", oAID); DataTable dt = DBUnity.AdapterToTab(sql, para); if (dt.Rows.Count > 0) { BG_OutlayAna bG_OutlayAna = new BG_OutlayAna(); bG_OutlayAna.OAID = dt.Rows[0]["OAID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["OAID"]; bG_OutlayAna.PIID = dt.Rows[0]["PIID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PIID"]; bG_OutlayAna.PPID = dt.Rows[0]["PPID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PPID"]; bG_OutlayAna.DepID = dt.Rows[0]["DepID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["DepID"]; bG_OutlayAna.OABudMon = dt.Rows[0]["OABudMon"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["OABudMon"]; bG_OutlayAna.OAAudMon = dt.Rows[0]["OAAudMon"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["OAAudMon"]; bG_OutlayAna.OACkMon = dt.Rows[0]["OACkMon"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["OACkMon"]; bG_OutlayAna.OAType = dt.Rows[0]["OAType"] == DBNull.Value ? "" : (string)dt.Rows[0]["OAType"]; bG_OutlayAna.OAYear = dt.Rows[0]["OAYear"] == DBNull.Value ? 0 : (int)dt.Rows[0]["OAYear"]; bG_OutlayAna.Mark = dt.Rows[0]["Mark"] == DBNull.Value ? "" : (string)dt.Rows[0]["Mark"]; return(bG_OutlayAna); } else { return(null); } } catch (Exception e) { Console.WriteLine(e.Message); throw e; } }
public static BG_PayWelSupply AddBG_PayWelSupply(BG_PayWelSupply bG_PayWelSupply) { string sql = "INSERT BG_PayWelSupply (GSEYear, DepID, GSETotal, OffSubTot, OffPerPart, OffPubPart, EbbSubTot, EbbPerPart, EbbPubPart, GSEHouPro, GSEMedChar, LifeAllo, GSEOther)" + "VALUES (@GSEYear, @DepID, @GSETotal, @OffSubTot, @OffPerPart, @OffPubPart, @EbbSubTot, @EbbPerPart, @EbbPubPart, @GSEHouPro, @GSEMedChar, @LifeAllo, @GSEOther)"; sql += " ; SELECT @@IDENTITY"; try { SqlParameter[] para = new SqlParameter[] { new SqlParameter("@GSEYear", bG_PayWelSupply.GSEYear), new SqlParameter("@DepID", bG_PayWelSupply.DepID), new SqlParameter("@GSETotal", bG_PayWelSupply.GSETotal), new SqlParameter("@OffSubTot", bG_PayWelSupply.OffSubTot), new SqlParameter("@OffPerPart", bG_PayWelSupply.OffPerPart), new SqlParameter("@OffPubPart", bG_PayWelSupply.OffPubPart), new SqlParameter("@EbbSubTot", bG_PayWelSupply.EbbSubTot), new SqlParameter("@EbbPerPart", bG_PayWelSupply.EbbPerPart), new SqlParameter("@EbbPubPart", bG_PayWelSupply.EbbPubPart), new SqlParameter("@GSEHouPro", bG_PayWelSupply.GSEHouPro), new SqlParameter("@GSEMedChar", bG_PayWelSupply.GSEMedChar), new SqlParameter("@LifeAllo", bG_PayWelSupply.LifeAllo), new SqlParameter("@GSEOther", bG_PayWelSupply.GSEOther) }; string IdStr = DBUnity.ExecuteScalar(CommandType.Text, sql, para); int newId = Convert.ToInt32(IdStr); return(GetBG_PayWelSupplyByGSEID(newId)); } catch (Exception e) { Console.WriteLine(e.Message); throw e; } }
public static BG_MonPayPlan_His GetBG_MonPayPlan_HisByMPPHis(int mPPHis) { string sql = "SELECT * FROM BG_MonPayPlan_His WHERE MPPHis = @MPPHis"; try { SqlParameter para = new SqlParameter("@MPPHis", mPPHis); DataTable dt = DBUnity.AdapterToTab(sql, para); if (dt.Rows.Count > 0) { BG_MonPayPlan_His bG_MonPayPlan_His = new BG_MonPayPlan_His(); bG_MonPayPlan_His.MPPHis = dt.Rows[0]["MPPHis"] == DBNull.Value ? 0 : (int)dt.Rows[0]["MPPHis"]; bG_MonPayPlan_His.PIID = dt.Rows[0]["PIID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PIID"]; bG_MonPayPlan_His.MPFunding = dt.Rows[0]["MPFunding"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["MPFunding"]; bG_MonPayPlan_His.DeptID = dt.Rows[0]["DeptID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["DeptID"]; bG_MonPayPlan_His.MPTime = dt.Rows[0]["MPTime"] == DBNull.Value ? DateTime.MinValue : (DateTime)dt.Rows[0]["MPTime"]; bG_MonPayPlan_His.MPRemark = dt.Rows[0]["MPRemark"] == DBNull.Value ? "" : (string)dt.Rows[0]["MPRemark"]; bG_MonPayPlan_His.CPID = dt.Rows[0]["CPID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["CPID"]; bG_MonPayPlan_His.MPPHisTime = dt.Rows[0]["MPPHisTime"] == DBNull.Value ? DateTime.MinValue : (DateTime)dt.Rows[0]["MPPHisTime"]; bG_MonPayPlan_His.MPFundingAdd = dt.Rows[0]["MPFundingAdd"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["MPFundingAdd"]; bG_MonPayPlan_His.MPFundingAddTimes = dt.Rows[0]["MPFundingAddTimes"] == DBNull.Value ? 0 : (int)dt.Rows[0]["MPFundingAddTimes"]; return(bG_MonPayPlan_His); } else { return(null); } } catch (Exception e) { Console.WriteLine(e.Message); throw e; } }
public static BG_ProBasiPerPayOne GetBG_ProBasiPerPayOneByPOID(int pOID) { string sql = "SELECT * FROM BG_ProBasiPerPayOne WHERE POID = @POID"; try { SqlParameter para = new SqlParameter("@POID", pOID); DataTable dt = DBUnity.AdapterToTab(sql, para); if (dt.Rows.Count > 0) { BG_ProBasiPerPayOne bG_ProBasiPerPayOne = new BG_ProBasiPerPayOne(); bG_ProBasiPerPayOne.POID = dt.Rows[0]["POID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["POID"]; bG_ProBasiPerPayOne.DepID = dt.Rows[0]["DepID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["DepID"]; bG_ProBasiPerPayOne.POYear = dt.Rows[0]["POYear"] == DBNull.Value ? DateTime.MinValue : (DateTime)dt.Rows[0]["POYear"]; bG_ProBasiPerPayOne.POBS = dt.Rows[0]["POBS"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["POBS"]; bG_ProBasiPerPayOne.POAS = dt.Rows[0]["POAS"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["POAS"]; bG_ProBasiPerPayOne.POBonus = dt.Rows[0]["POBonus"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["POBonus"]; bG_ProBasiPerPayOne.POPS = dt.Rows[0]["POPS"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["POPS"]; bG_ProBasiPerPayOne.POSE = dt.Rows[0]["POSE"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["POSE"]; bG_ProBasiPerPayOne.POOther = dt.Rows[0]["POOther"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["POOther"]; bG_ProBasiPerPayOne.POTitol = dt.Rows[0]["POTitol"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["POTitol"]; return(bG_ProBasiPerPayOne); } else { return(null); } } catch (Exception e) { Console.WriteLine(e.Message); throw e; } }
public static bool ModifyBG_PreviewDevide(BG_PreviewDevide bG_PreviewDevide) { string sql = "UPDATE BG_PreviewDevide " + "SET " + "DepID = @DepID, " + "PSID = @PSID, " + "DevMon = @DevMon " + "WHERE PDID = @PDID"; try { SqlParameter[] para = new SqlParameter[] { new SqlParameter("@PDID", bG_PreviewDevide.PDID), new SqlParameter("@DepID", bG_PreviewDevide.DepID), new SqlParameter("@PSID", bG_PreviewDevide.PSID), new SqlParameter("@DevMon", bG_PreviewDevide.DevMon) }; 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_BudCostPro GetBG_BudCostProByCostID(int costID) { string sql = "SELECT * FROM BG_BudCostPro WHERE CostID = @CostID"; try { SqlParameter para = new SqlParameter("@CostID", costID); DataTable dt = DBUnity.AdapterToTab(sql, para); if (dt.Rows.Count > 0) { BG_BudCostPro bG_BudCostPro = new BG_BudCostPro(); bG_BudCostPro.CostID = dt.Rows[0]["CostID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["CostID"]; bG_BudCostPro.BudID = dt.Rows[0]["BudID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["BudID"]; bG_BudCostPro.BCPCurrYear = dt.Rows[0]["BCPCurrYear"] == DBNull.Value ? 0 : (int)dt.Rows[0]["BCPCurrYear"]; bG_BudCostPro.PIID = dt.Rows[0]["PIID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PIID"]; bG_BudCostPro.BCPTotal = dt.Rows[0]["BCPTotal"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["BCPTotal"]; bG_BudCostPro.BCPSubtFinAllo = dt.Rows[0]["BCPSubtFinAllo"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["BCPSubtFinAllo"]; bG_BudCostPro.BCPSubtExp = dt.Rows[0]["BCPSubtExp"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["BCPSubtExp"]; bG_BudCostPro.BCInExpenses = dt.Rows[0]["BCInExpenses"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["BCInExpenses"]; bG_BudCostPro.BCOutFunding = dt.Rows[0]["BCOutFunding"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["BCOutFunding"]; bG_BudCostPro.BCPRemark = dt.Rows[0]["BCPRemark"] == DBNull.Value ? "" : (string)dt.Rows[0]["BCPRemark"]; return(bG_BudCostPro); } else { return(null); } } catch (Exception e) { Console.WriteLine(e.Message); throw e; } }
/// <summary> /// 添加预算项目附件信息 /// </summary> /// <returns>bool</returns> public static bool AddBudAppendix(BG_BudAppendix BudAppendix) { bool flag = false; try { string sqlStr = @"insert into BG_BudAppendix(BudID,APPath,ApName,ApTime) values(@BudID,@APPath,@ApName,@ApTime)"; SqlParameter[] Pars = new SqlParameter[] { new SqlParameter("@BudID", BudAppendix.BudID), new SqlParameter("@APPath", BudAppendix.APPath), new SqlParameter("@ApName", BudAppendix.ApName), new SqlParameter("@ApTime", BudAppendix.ApTime) }; flag = DBUnity.ExecuteNonQuery(CommandType.Text, sqlStr, Pars) > 0; } catch (Exception ex) { flag = false; Log.WriteLog(ex.Message, "BGBudAppendixService--AddBudAppendix"); } return(flag); }
public static bool ModifyBG_Caliber(BG_Caliber bG_Caliber) { string sql = "UPDATE BG_Caliber " + "SET " + "CaliberName = @CaliberName, " + "ParentID = @ParentID ," + "CbLever = @CbLever " + "WHERE CaliberID = @CaliberID"; try { SqlParameter[] para = new SqlParameter[] { new SqlParameter("@CaliberID", bG_Caliber.CaliberID), new SqlParameter("@CaliberName", bG_Caliber.CaliberName), new SqlParameter("@ParentID", bG_Caliber.ParentID), new SqlParameter("@CbLever", bG_Caliber.CbLever) }; 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; } }
/// <summary> /// 查询指定BudID的所有历史操作轨迹 /// </summary> /// <param name="budid"></param> /// <returns></returns> public static DataTable GetDtBIHisByBudid(int budid, int PageSize, int pageIndex, out int RecordCount) { DataTable dt = null; RecordCount = 0; string sqlStr = "select * from BG_BudItemHis"; string filter = " where BudID ={0} order by BudID asc"; filter = string.Format(filter, budid); sqlStr += filter; try { string sql_bc = "select count(*) from BG_BudItemHis where BudID = " + budid.ToString(); string CountStr = DBUnity.ExecuteScalar(CommandType.Text, sql_bc, null); RecordCount = common.IntSafeConvert(CountStr); dt = DBUnity.GetAspNetPager(sqlStr, pageIndex, PageSize); } catch (Exception ex) { dt = new DataTable(); Log.WriteLog(ex.Message, "BG_BudItemHisService--GetDtBIHisByBudid"); } return(dt); }
/// <summary> /// 查询指定部门下所有预算信息 /// </summary> /// <param name="arid">预算信息</param> /// <returns>BGUser</returns> public static DataTable GetApplyReimburByDepIDPager(int DepID, int pageIndex, int PageSize, out int RecordCount) { DataTable dt = new DataTable(); RecordCount = 0; try { string sqlStr = string.Format("select * from BG_BudItems where DepID={0} order by BudID desc", DepID); string sqlRecord = string.Format("select count(*) from BG_BudItems where DepID={0} ", DepID); if (DepID == 0) { sqlStr = string.Format("select * from BG_BudItems order by BudID desc"); sqlRecord = string.Format("select count(*) from BG_BudItems"); } RecordCount = common.IntSafeConvert(DBUnity.ExecuteScalar(CommandType.Text, sqlRecord, null)); dt = DBUnity.GetAspNetPager(sqlStr, pageIndex, PageSize); } catch (Exception ex) { dt = new DataTable(); Log.WriteLog(ex.Message, "BGBudItemsService--GetApplyReimburByDepID"); } return(dt); }
/// <summary> /// 查询一条指定附件信息 /// </summary> /// <param name="arid">附件信息ID</param> /// <returns>BG_ReimAppendix</returns> public static BG_ReimAppendix GetAcc(string arid) { BG_ReimAppendix rm = new BG_ReimAppendix(); try { string sqlStr = "select * from BG_ReimAppendix where ARID={0} "; sqlStr = string.Format(sqlStr, arid); DataTable dt = DBUnity.AdapterToTab(sqlStr); if (dt.Rows.Count > 0) { rm.RADID = common.IntSafeConvert(dt.Rows[0]["RADID"]); rm.ARID = common.IntSafeConvert(dt.Rows[0]["ARID"]); rm.ARType = dt.Rows[0]["ARType"].ToString(); rm.ARTime = DateTime.Parse(dt.Rows[0]["ARTime"].ToString()); rm.ARContent = dt.Rows[0]["ARContent"].ToString(); } } catch { } return(rm); }
public static BG_MonPayPlan_Attach GetBG_MonPayPlan_AttachByCPAID(int cPAID) { string sql = "SELECT * FROM BG_MonPayPlan_Attach WHERE CPAID = @CPAID"; try { SqlParameter para = new SqlParameter("@CPAID", cPAID); DataTable dt = DBUnity.AdapterToTab(sql, para); if (dt.Rows.Count > 0) { BG_MonPayPlan_Attach bG_MonPayPlan_Attach = new BG_MonPayPlan_Attach(); bG_MonPayPlan_Attach.CPAID = dt.Rows[0]["CPAID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["CPAID"]; bG_MonPayPlan_Attach.PIID = dt.Rows[0]["PIID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PIID"]; bG_MonPayPlan_Attach.MPFunding = dt.Rows[0]["MPFunding"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["MPFunding"]; bG_MonPayPlan_Attach.DeptID = dt.Rows[0]["DeptID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["DeptID"]; bG_MonPayPlan_Attach.MPTime = dt.Rows[0]["MPTime"] == DBNull.Value ? DateTime.MinValue : (DateTime)dt.Rows[0]["MPTime"]; bG_MonPayPlan_Attach.MPRemark = dt.Rows[0]["MPRemark"] == DBNull.Value ? "" : (string)dt.Rows[0]["MPRemark"]; bG_MonPayPlan_Attach.MPFundingAdd = dt.Rows[0]["MPFundingAdd"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["MPFundingAdd"]; bG_MonPayPlan_Attach.CPATimes = dt.Rows[0]["CPATimes"] == DBNull.Value ? 0 : (int)dt.Rows[0]["CPATimes"]; bG_MonPayPlan_Attach.CPID = dt.Rows[0]["CPID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["CPID"]; return(bG_MonPayPlan_Attach); } else { return(null); } } catch (Exception e) { Console.WriteLine(e.Message); throw e; } }
public static BG_User AddBG_User(BG_User bG_User) { string sql = "INSERT BG_User (UserName, UserNum, UserIDNum, UserPwd, UserLim, UserSta, DepID, UserRem, IsVIP, UserDescription, IsLogin, ApplyRem)" + "VALUES (@UserName, @UserNum, @UserIDNum, @UserPwd, @UserLim, @UserSta, @DepID, @UserRem, @IsVIP, @UserDescription, @IsLogin, @ApplyRem)"; sql += " ; SELECT @@IDENTITY"; try { SqlParameter[] para = new SqlParameter[] { new SqlParameter("@UserName", bG_User.UserName), new SqlParameter("@UserNum", bG_User.UserNum), new SqlParameter("@UserIDNum", bG_User.UserIDNum), new SqlParameter("@UserPwd", bG_User.UserPwd), new SqlParameter("@UserLim", bG_User.UserLim), new SqlParameter("@UserSta", bG_User.UserSta), new SqlParameter("@DepID", bG_User.DepID), new SqlParameter("@UserRem", bG_User.UserRem), new SqlParameter("@IsVIP", bG_User.IsVIP), new SqlParameter("@UserDescription", bG_User.UserDescription), new SqlParameter("@IsLogin", bG_User.IsLogin), new SqlParameter("@ApplyRem", bG_User.ApplyRem) }; string IdStr = DBUnity.ExecuteScalar(CommandType.Text, sql, para); int newId = Convert.ToInt32(IdStr); return(GetBG_UserByUserID(newId)); } catch (Exception e) { Console.WriteLine(e.Message); throw e; } }
/// <summary> /// 修改指定预算项目附件信息 /// </summary> /// <param name="BudAppendix">BGBudAppendix</param> /// <returns>bool</returns> public static bool UpdBudAppendix(BG_BudAppendix BudAppendix) { bool flag = false; try { string sqlStr = @"update from BG_BudAppendix set APID = @APID,BudID=@BudID,APPath=@APPath, ApName=@ApName,ApTime=@ApTime where APID = @APID"; SqlParameter[] Pars = new SqlParameter[] { new SqlParameter("@APID", BudAppendix.APID), new SqlParameter("@BudID", BudAppendix.BudID), new SqlParameter("@APPath", BudAppendix.APPath), new SqlParameter("@ApName", BudAppendix.ApName), new SqlParameter("@ApTime", BudAppendix.ApTime) }; flag = DBUnity.ExecuteNonQuery(CommandType.Text, sqlStr, Pars) > 0; } catch (Exception ex) { flag = false; Log.WriteLog(ex.Message, "BGBudAppendixService--UpdBudAppendix"); } return(flag); }
public static BG_BudgetAllocationHis AddBG_BudgetAllocationHis(BG_BudgetAllocationHis bG_BudgetAllocationHis) { string sql = "INSERT BG_BudgetAllocationHis (BAAID, DepID, PIID, AddBAAMon, AddSuppMon, UserOp, Crtime, OldBAAMon, OldSuppMon, NewBAAMon, NewSuppMon, DepName)" + "VALUES (@BAAID, @DepID, @PIID, @AddBAAMon, @AddSuppMon, @UserOp, @Crtime, @OldBAAMon, @OldSuppMon, @NewBAAMon, @NewSuppMon, @DepName)"; sql += " ; SELECT @@IDENTITY"; try { SqlParameter[] para = new SqlParameter[] { new SqlParameter("@BAAID", bG_BudgetAllocationHis.BAAID), new SqlParameter("@DepID", bG_BudgetAllocationHis.DepID), new SqlParameter("@PIID", bG_BudgetAllocationHis.PIID), new SqlParameter("@AddBAAMon", bG_BudgetAllocationHis.AddBAAMon), new SqlParameter("@AddSuppMon", bG_BudgetAllocationHis.AddSuppMon), new SqlParameter("@UserOp", bG_BudgetAllocationHis.UserOp), new SqlParameter("@Crtime", bG_BudgetAllocationHis.Crtime), new SqlParameter("@OldBAAMon", bG_BudgetAllocationHis.OldBAAMon), new SqlParameter("@OldSuppMon", bG_BudgetAllocationHis.OldSuppMon), new SqlParameter("@NewBAAMon", bG_BudgetAllocationHis.NewBAAMon), new SqlParameter("@NewSuppMon", bG_BudgetAllocationHis.NewSuppMon), new SqlParameter("@DepName", bG_BudgetAllocationHis.DepName) }; string IdStr = DBUnity.ExecuteScalar(CommandType.Text, sql, para); int newId = Convert.ToInt32(IdStr); return(GetBG_BudgetAllocationHisByBAAHisID(newId)); } catch (Exception e) { Console.WriteLine(e.Message); throw e; } }
public static bool ModifyBG_BudItems(BG_BudItems bG_BudItems) { string sql = "UPDATE BG_BudItems " + "SET " + "BIProType = @BIProType, " + "BIFunSub = @BIFunSub, " + "BICode = @BICode, " + "PPID = @PPID, " + "PIID = @PIID, " + "BIPlanHz = @BIPlanHz, " + "BIStaTime = @BIStaTime, " + "BIEndTime = @BIEndTime, " + "BICharger = @BICharger, " + "BIAttr = @BIAttr, " + "BIAppReaCon = @BIAppReaCon, " + "BIExpGistExp = @BIExpGistExp, " + "BILongGoal = @BILongGoal, " + "BIYearGoal = @BIYearGoal, " + "BIMon = @BIMon, " + "BIAppConMon = @BIAppConMon, " + "BIMonSou = @BIMonSou, " + "BIFinAllo = @BIFinAllo, " + "BILastYearCarry = @BILastYearCarry, " + "BIOthFun = @BIOthFun, " + "BIOthExpProb = @BIOthExpProb, " + "BIBudSta = @BIBudSta, " + "BudSta = @BudSta, " + "BICause = @BICause, " + "DepID = @DepID, " + "BIProName = @BIProName, " + "BIReportTime = @BIReportTime, " + "BIConNum = @BIConNum, " + "BIProDescrip = @BIProDescrip, " + "BIProCategory = @BIProCategory, " + "BIYear = @BIYear " + "WHERE BudID = @BudID"; try { SqlParameter[] para = new SqlParameter[] { new SqlParameter("@BudID", bG_BudItems.BudID), new SqlParameter("@BIProType", bG_BudItems.BIProType), new SqlParameter("@BIFunSub", bG_BudItems.BIFunSub), new SqlParameter("@BICode", bG_BudItems.BICode), new SqlParameter("@PPID", bG_BudItems.PPID), new SqlParameter("@PIID", bG_BudItems.PIID), new SqlParameter("@BIPlanHz", bG_BudItems.BIPlanHz), new SqlParameter("@BIStaTime", bG_BudItems.BIStaTime), new SqlParameter("@BIEndTime", bG_BudItems.BIEndTime), new SqlParameter("@BICharger", bG_BudItems.BICharger), new SqlParameter("@BIAttr", bG_BudItems.BIAttr), new SqlParameter("@BIAppReaCon", bG_BudItems.BIAppReaCon), new SqlParameter("@BIExpGistExp", bG_BudItems.BIExpGistExp), new SqlParameter("@BILongGoal", bG_BudItems.BILongGoal), new SqlParameter("@BIYearGoal", bG_BudItems.BIYearGoal), new SqlParameter("@BIMon", bG_BudItems.BIMon), new SqlParameter("@BIAppConMon", bG_BudItems.BIAppConMon), new SqlParameter("@BIMonSou", bG_BudItems.BIMonSou), new SqlParameter("@BIFinAllo", bG_BudItems.BIFinAllo), new SqlParameter("@BILastYearCarry", bG_BudItems.BILastYearCarry), new SqlParameter("@BIOthFun", bG_BudItems.BIOthFun), new SqlParameter("@BIOthExpProb", bG_BudItems.BIOthExpProb), new SqlParameter("@BIBudSta", bG_BudItems.BIBudSta), new SqlParameter("@BudSta", bG_BudItems.BudSta), new SqlParameter("@BICause", bG_BudItems.BICause), new SqlParameter("@DepID", bG_BudItems.DepID), new SqlParameter("@BIProName", bG_BudItems.BIProName), new SqlParameter("@BIReportTime", bG_BudItems.BIReportTime), new SqlParameter("@BIConNum", bG_BudItems.BIConNum), new SqlParameter("@BIProDescrip", bG_BudItems.BIProDescrip), new SqlParameter("@BIProCategory", bG_BudItems.BIProCategory), new SqlParameter("@BIYear", bG_BudItems.BIYear) }; 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; } }