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) { 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); }
public static bool DeleteBG_DayPubBudget(BG_DayPubBudget bG_DayPubBudget) { return DeleteBG_DayPubBudgetByDPBID( bG_DayPubBudget.DPBID ); }
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 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; } }