public static BG_DayPubBudget GetBG_DayPubBudgetByDPBID(int dPBID) { string sql = "SELECT * FROM BG_DayPubBudget WHERE DPBID = @DPBID"; try { SqlParameter para = new SqlParameter("@DPBID", dPBID); DataTable dt = DBUnity.AdapterToTab(sql, para); if (dt.Rows.Count > 0) { BG_DayPubBudget bG_DayPubBudget = new BG_DayPubBudget(); bG_DayPubBudget.DPBID = dt.Rows[0]["DPBID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["DPBID"]; bG_DayPubBudget.DPBYear = dt.Rows[0]["DPBYear"] == DBNull.Value ? 0 : (int)dt.Rows[0]["DPBYear"]; bG_DayPubBudget.DepID = dt.Rows[0]["DepID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["DepID"]; bG_DayPubBudget.DPBTotal = dt.Rows[0]["DPBTotal"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["DPBTotal"]; bG_DayPubBudget.DPBSubTotal = dt.Rows[0]["DPBSubTotal"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["DPBSubTotal"]; bG_DayPubBudget.DPBOffCost = dt.Rows[0]["DPBOffCost"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["DPBOffCost"]; bG_DayPubBudget.DPBWatEleCost = dt.Rows[0]["DPBWatEleCost"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["DPBWatEleCost"]; bG_DayPubBudget.DPBPostCost = dt.Rows[0]["DPBPostCost"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["DPBPostCost"]; bG_DayPubBudget.DPBCarMaiCost = dt.Rows[0]["DPBCarMaiCost"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["DPBCarMaiCost"]; bG_DayPubBudget.DPBTraCost = dt.Rows[0]["DPBTraCost"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["DPBTraCost"]; bG_DayPubBudget.DPBMaiCost = dt.Rows[0]["DPBMaiCost"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["DPBMaiCost"]; bG_DayPubBudget.DPBMeetCost = dt.Rows[0]["DPBMeetCost"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["DPBMeetCost"]; bG_DayPubBudget.DPBCulCost = dt.Rows[0]["DPBCulCost"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["DPBCulCost"]; bG_DayPubBudget.DPBOffRecCost = dt.Rows[0]["DPBOffRecCost"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["DPBOffRecCost"]; bG_DayPubBudget.DPBOffAbrCost = dt.Rows[0]["DPBOffAbrCost"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["DPBOffAbrCost"]; bG_DayPubBudget.DPBTraUniCost = dt.Rows[0]["DPBTraUniCost"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["DPBTraUniCost"]; bG_DayPubBudget.DPBWelCost = dt.Rows[0]["DPBWelCost"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["DPBWelCost"]; bG_DayPubBudget.DPBComOther = dt.Rows[0]["DPBComOther"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["DPBComOther"]; bG_DayPubBudget.DPBOffSubTotal = dt.Rows[0]["DPBOffSubTotal"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["DPBOffSubTotal"]; bG_DayPubBudget.DPBOffEquAcqExp = dt.Rows[0]["DPBOffEquAcqExp"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["DPBOffEquAcqExp"]; bG_DayPubBudget.DPBCapOther = dt.Rows[0]["DPBCapOther"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["DPBCapOther"]; return(bG_DayPubBudget); } else { return(null); } } catch (Exception e) { Console.WriteLine(e.Message); throw e; } }
public static BG_DayPubBudget AddBG_DayPubBudget(BG_DayPubBudget bG_DayPubBudget) { string sql = "INSERT BG_DayPubBudget (DPBYear, DepID, DPBTotal, DPBSubTotal, DPBOffCost, DPBWatEleCost, DPBPostCost, DPBCarMaiCost, DPBTraCost, DPBMaiCost, DPBMeetCost, DPBCulCost, DPBOffRecCost, DPBOffAbrCost, DPBTraUniCost, DPBWelCost, DPBComOther, DPBOffSubTotal, DPBOffEquAcqExp, DPBCapOther)" + "VALUES (@DPBYear, @DepID, @DPBTotal, @DPBSubTotal, @DPBOffCost, @DPBWatEleCost, @DPBPostCost, @DPBCarMaiCost, @DPBTraCost, @DPBMaiCost, @DPBMeetCost, @DPBCulCost, @DPBOffRecCost, @DPBOffAbrCost, @DPBTraUniCost, @DPBWelCost, @DPBComOther, @DPBOffSubTotal, @DPBOffEquAcqExp, @DPBCapOther)"; sql += " ; SELECT @@IDENTITY"; try { SqlParameter[] para = new SqlParameter[] { new SqlParameter("@DPBYear", bG_DayPubBudget.DPBYear), new SqlParameter("@DepID", bG_DayPubBudget.DepID), new SqlParameter("@DPBTotal", bG_DayPubBudget.DPBTotal), new SqlParameter("@DPBSubTotal", bG_DayPubBudget.DPBSubTotal), new SqlParameter("@DPBOffCost", bG_DayPubBudget.DPBOffCost), new SqlParameter("@DPBWatEleCost", bG_DayPubBudget.DPBWatEleCost), new SqlParameter("@DPBPostCost", bG_DayPubBudget.DPBPostCost), new SqlParameter("@DPBCarMaiCost", bG_DayPubBudget.DPBCarMaiCost), new SqlParameter("@DPBTraCost", bG_DayPubBudget.DPBTraCost), new SqlParameter("@DPBMaiCost", bG_DayPubBudget.DPBMaiCost), new SqlParameter("@DPBMeetCost", bG_DayPubBudget.DPBMeetCost), new SqlParameter("@DPBCulCost", bG_DayPubBudget.DPBCulCost), new SqlParameter("@DPBOffRecCost", bG_DayPubBudget.DPBOffRecCost), new SqlParameter("@DPBOffAbrCost", bG_DayPubBudget.DPBOffAbrCost), new SqlParameter("@DPBTraUniCost", bG_DayPubBudget.DPBTraUniCost), new SqlParameter("@DPBWelCost", bG_DayPubBudget.DPBWelCost), new SqlParameter("@DPBComOther", bG_DayPubBudget.DPBComOther), new SqlParameter("@DPBOffSubTotal", bG_DayPubBudget.DPBOffSubTotal), new SqlParameter("@DPBOffEquAcqExp", bG_DayPubBudget.DPBOffEquAcqExp), new SqlParameter("@DPBCapOther", bG_DayPubBudget.DPBCapOther) }; string IdStr = DBUnity.ExecuteScalar(CommandType.Text, sql, para); int newId = Convert.ToInt32(IdStr); return(GetBG_DayPubBudgetByDPBID(newId)); } catch (Exception e) { Console.WriteLine(e.Message); throw e; } }
/// <summary> /// 添加一条【日常公用支出预算】记录BG_DayPubBudget /// </summary> /// <param name="dpb">BGDayPubBudget</param> /// <returns>bool</returns> public static bool AddDPB(BG_DayPubBudget dpb) { bool falg = false; try { string sqlStr = @"insert into BG_DayPubBudget(DPBYear,DepID ,DPBTotal,DPBSubTotal,DPBOffCost,DPBWatEleCost,DPBPostCost,DPBCarMaiCost,DPBTraCost,DPBMaiCost, DPBMeetCost,DPBCulCost,DPBOffRecCost,DPBOffAbrCost,DPBTraUniCost,DPBWelCost,DPBComOther,DPBOffSubTotal,DPBOffEquAcqExp,DPBCapOther) values(@DPBYear,@DepID ,@DPBTotal,@DPBSubTotal,@DPBOffCost,@DPBWatEleCost,@DPBPostCost,@DPBCarMaiCost,@DPBTraCost,@DPBMaiCost,@DPBMeetCost, @DPBCulCost,@DPBOffRecCost,@DPBOffAbrCost,@DPBTraUniCost,@DPBWelCost,@DPBComOther,@DPBOffSubTotal,@DPBOffEquAcqExp,@DPBCapOther)"; SqlParameter[] Pars = new SqlParameter[] { new SqlParameter("@DPBYear", dpb.DPBYear), new SqlParameter("@DepID", dpb.DepID), new SqlParameter("@DPBTotal", dpb.DPBTotal), new SqlParameter("@DPBSubTotal", dpb.DPBSubTotal), new SqlParameter("@DPBOffCost", dpb.DPBOffCost), new SqlParameter("@DPBWatEleCost", dpb.DPBWatEleCost), new SqlParameter("@DPBPostCost", dpb.DPBPostCost), new SqlParameter("@DPBCarMaiCost", dpb.DPBCarMaiCost), new SqlParameter("@DPBTraCost", dpb.DPBTraCost), new SqlParameter("@DPBMaiCost", dpb.DPBMaiCost), new SqlParameter("@DPBMeetCost", dpb.DPBMeetCost), new SqlParameter("@DPBCulCost", dpb.DPBCulCost), new SqlParameter("@DPBOffRecCost", dpb.DPBOffRecCost), new SqlParameter("@DPBOffAbrCost", dpb.DPBOffAbrCost), new SqlParameter("@DPBTraUniCost", dpb.DPBTraUniCost), new SqlParameter("@DPBWelCost", dpb.DPBWelCost), new SqlParameter("@DPBComOther", dpb.DPBComOther), new SqlParameter("@DPBOffSubTotal", dpb.DPBOffSubTotal), new SqlParameter("@DPBOffEquAcqExp", dpb.DPBOffEquAcqExp), new SqlParameter("@DPBCapOther", dpb.DPBCapOther) }; falg = DBUnity.ExecuteNonQuery(CommandType.Text, sqlStr, Pars) > 0; } catch (Exception ex) { falg = false; Log.WriteLog(ex.Message, "BGDayPubBudgetService--AddDPB"); } return(falg); }
public static bool ModifyBG_DayPubBudget(BG_DayPubBudget bG_DayPubBudget) { string sql = "UPDATE BG_DayPubBudget " + "SET " + "DPBYear = @DPBYear, " + "DepID = @DepID, " + "DPBTotal = @DPBTotal, " + "DPBSubTotal = @DPBSubTotal, " + "DPBOffCost = @DPBOffCost, " + "DPBWatEleCost = @DPBWatEleCost, " + "DPBPostCost = @DPBPostCost, " + "DPBCarMaiCost = @DPBCarMaiCost, " + "DPBTraCost = @DPBTraCost, " + "DPBMaiCost = @DPBMaiCost, " + "DPBMeetCost = @DPBMeetCost, " + "DPBCulCost = @DPBCulCost, " + "DPBOffRecCost = @DPBOffRecCost, " + "DPBOffAbrCost = @DPBOffAbrCost, " + "DPBTraUniCost = @DPBTraUniCost, " + "DPBWelCost = @DPBWelCost, " + "DPBComOther = @DPBComOther, " + "DPBOffSubTotal = @DPBOffSubTotal, " + "DPBOffEquAcqExp = @DPBOffEquAcqExp, " + "DPBCapOther = @DPBCapOther " + "WHERE DPBID = @DPBID"; try { SqlParameter[] para = new SqlParameter[] { new SqlParameter("@DPBID", bG_DayPubBudget.DPBID), new SqlParameter("@DPBYear", bG_DayPubBudget.DPBYear), new SqlParameter("@DepID", bG_DayPubBudget.DepID), new SqlParameter("@DPBTotal", bG_DayPubBudget.DPBTotal), new SqlParameter("@DPBSubTotal", bG_DayPubBudget.DPBSubTotal), new SqlParameter("@DPBOffCost", bG_DayPubBudget.DPBOffCost), new SqlParameter("@DPBWatEleCost", bG_DayPubBudget.DPBWatEleCost), new SqlParameter("@DPBPostCost", bG_DayPubBudget.DPBPostCost), new SqlParameter("@DPBCarMaiCost", bG_DayPubBudget.DPBCarMaiCost), new SqlParameter("@DPBTraCost", bG_DayPubBudget.DPBTraCost), new SqlParameter("@DPBMaiCost", bG_DayPubBudget.DPBMaiCost), new SqlParameter("@DPBMeetCost", bG_DayPubBudget.DPBMeetCost), new SqlParameter("@DPBCulCost", bG_DayPubBudget.DPBCulCost), new SqlParameter("@DPBOffRecCost", bG_DayPubBudget.DPBOffRecCost), new SqlParameter("@DPBOffAbrCost", bG_DayPubBudget.DPBOffAbrCost), new SqlParameter("@DPBTraUniCost", bG_DayPubBudget.DPBTraUniCost), new SqlParameter("@DPBWelCost", bG_DayPubBudget.DPBWelCost), new SqlParameter("@DPBComOther", bG_DayPubBudget.DPBComOther), new SqlParameter("@DPBOffSubTotal", bG_DayPubBudget.DPBOffSubTotal), new SqlParameter("@DPBOffEquAcqExp", bG_DayPubBudget.DPBOffEquAcqExp), new SqlParameter("@DPBCapOther", bG_DayPubBudget.DPBCapOther) }; 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 DeleteBG_DayPubBudget(BG_DayPubBudget bG_DayPubBudget) { return(DeleteBG_DayPubBudgetByDPBID(bG_DayPubBudget.DPBID)); }
public static bool ModifyBG_DayPubBudget(BG_DayPubBudget bG_DayPubBudget) { return(BG_DayPubBudgetService.ModifyBG_DayPubBudget(bG_DayPubBudget)); }
public static bool DeleteBG_DayPubBudget(BG_DayPubBudget bG_DayPubBudget) { return(BG_DayPubBudgetService.DeleteBG_DayPubBudget(bG_DayPubBudget)); }
public static BG_DayPubBudget AddBG_DayPubBudget(BG_DayPubBudget bG_DayPubBudget) { return(BG_DayPubBudgetService.AddBG_DayPubBudget(bG_DayPubBudget)); }
/// <summary> /// 添加一条【日常公用支出预算】记录BG_DayPubBudget /// </summary> /// <param name="dpb">BGDayPubBudget</param> /// <returns>bool</returns> public static bool AddDPB(BG_DayPubBudget dpb) { return(BGDayPubBudgetService.AddDPB(dpb)); }