protected void btnSure_Click(object sender, EventArgs e) { int bid = common.IntSafeConvert(Hidbuid.Value); BG_BudItemsLibraries bi = new BG_BudItemsLibraries(); if (HidFlag.Value == "1") { bi = BG_BudItemsLibrariesManager.GetBG_BudItemsLibrariesByBudItID(bid); } bi.BILAppReaCon = txtBIAppReaCon.Text.Trim(); bi.BILAttr = ddlProProper.SelectedValue; bi.BILExpGistExp = txtBIExpGistExp.Text.Trim(); bi.BILFunSub = ddlFunSub.SelectedValue; bi.BILMon = Convert.ToDecimal(txtBILMon.Text); bi.BILLongGoal = txtBILongGoal.Text.Trim(); bi.BILOthExpProb = txtBIOthExpProb.Text.Trim(); bi.BILProType = ddlPayProType.SelectedItem.Text; bi.BILYearGoal = txtBIYearGoal.Text.Trim(); bi.DepID = common.IntSafeConvert(ddlDeptName.SelectedValue); bi.PPID = common.IntSafeConvert(ddlPayProType.SelectedValue); bi.BILProName = txtProName.Text.Trim(); bi.BILProDescrip = txtProDesc.Text.Trim(); bi.BILProCategory = ddlProType.SelectedValue; bi.PIID = BG_PayProjectManager.GetBG_PayProjectByPPID(bi.PPID).PIID; if (HidFlag.Value == "0") { BG_BudItemsLibrariesManager.AddBG_BudItemsLibraries(bi); txtBIAppReaCon.Text = ""; txtBIExpGistExp.Text = ""; txtBILongGoal.Text = ""; txtBILMon.Text = ""; txtBIOthExpProb.Text = ""; txtBIYearGoal.Text = ""; txtProDesc.Text = ""; txtProName.Text = ""; lblShowResult.Text = "添加成功"; } else { BG_BudItemsLibrariesManager.ModifyBG_BudItemsLibraries(bi); txtBIAppReaCon.Text = ""; txtBIExpGistExp.Text = ""; txtBILongGoal.Text = ""; txtBILMon.Text = ""; txtBIOthExpProb.Text = ""; txtBIYearGoal.Text = ""; txtProDesc.Text = ""; txtProName.Text = ""; lblShowResult.Text = "修改成功"; Response.Redirect("LibrariesEditList.aspx", true); } }
public static BG_BudItemsLibraries GetBG_BudItemsLibrariesByBudItID(int budItID) { string sql = "SELECT * FROM BG_BudItemsLibraries WHERE BudItID = @BudItID"; try { SqlParameter para = new SqlParameter("@BudItID", budItID); DataTable dt = DBUnity.AdapterToTab(sql, para); if (dt.Rows.Count > 0) { BG_BudItemsLibraries bG_BudItemsLibraries = new BG_BudItemsLibraries(); bG_BudItemsLibraries.BudItID = dt.Rows[0]["BudItID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["BudItID"]; bG_BudItemsLibraries.BILProType = dt.Rows[0]["BILProType"] == DBNull.Value ? "" : (string)dt.Rows[0]["BILProType"]; bG_BudItemsLibraries.BILFunSub = dt.Rows[0]["BILFunSub"] == DBNull.Value ? "" : (string)dt.Rows[0]["BILFunSub"]; bG_BudItemsLibraries.PPID = dt.Rows[0]["PPID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PPID"]; bG_BudItemsLibraries.PIID = dt.Rows[0]["PIID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PIID"]; bG_BudItemsLibraries.BILAttr = dt.Rows[0]["BILAttr"] == DBNull.Value ? "" : (string)dt.Rows[0]["BILAttr"]; bG_BudItemsLibraries.BILAppReaCon = dt.Rows[0]["BILAppReaCon"] == DBNull.Value ? "" : (string)dt.Rows[0]["BILAppReaCon"]; bG_BudItemsLibraries.BILExpGistExp = dt.Rows[0]["BILExpGistExp"] == DBNull.Value ? "" : (string)dt.Rows[0]["BILExpGistExp"]; bG_BudItemsLibraries.BILLongGoal = dt.Rows[0]["BILLongGoal"] == DBNull.Value ? "" : (string)dt.Rows[0]["BILLongGoal"]; bG_BudItemsLibraries.BILYearGoal = dt.Rows[0]["BILYearGoal"] == DBNull.Value ? "" : (string)dt.Rows[0]["BILYearGoal"]; bG_BudItemsLibraries.BILMon = dt.Rows[0]["BILMon"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["BILMon"]; bG_BudItemsLibraries.BILMonSou = dt.Rows[0]["BILMonSou"] == DBNull.Value ? "" : (string)dt.Rows[0]["BILMonSou"]; bG_BudItemsLibraries.BILFinAllo = dt.Rows[0]["BILFinAllo"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["BILFinAllo"]; bG_BudItemsLibraries.BILLastYearCarry = dt.Rows[0]["BILLastYearCarry"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["BILLastYearCarry"]; bG_BudItemsLibraries.BILOthFun = dt.Rows[0]["BILOthFun"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["BILOthFun"]; bG_BudItemsLibraries.BILOthExpProb = dt.Rows[0]["BILOthExpProb"] == DBNull.Value ? "" : (string)dt.Rows[0]["BILOthExpProb"]; bG_BudItemsLibraries.DepID = dt.Rows[0]["DepID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["DepID"]; bG_BudItemsLibraries.BILProName = dt.Rows[0]["BILProName"] == DBNull.Value ? "" : (string)dt.Rows[0]["BILProName"]; bG_BudItemsLibraries.BILProDescrip = dt.Rows[0]["BILProDescrip"] == DBNull.Value ? "" : (string)dt.Rows[0]["BILProDescrip"]; bG_BudItemsLibraries.BILProCategory = dt.Rows[0]["BILProCategory"] == DBNull.Value ? "" : (string)dt.Rows[0]["BILProCategory"]; bG_BudItemsLibraries.BILPlanHz = dt.Rows[0]["BILPlanHz"] == DBNull.Value ? "" : (string)dt.Rows[0]["BILPlanHz"]; return(bG_BudItemsLibraries); } else { return(null); } } catch (Exception e) { Console.WriteLine(e.Message); throw e; } }
public static BG_BudItemsLibraries AddBG_BudItemsLibraries(BG_BudItemsLibraries bG_BudItemsLibraries) { string sql = "INSERT BG_BudItemsLibraries (BILProType, BILFunSub, PPID, PIID, BILAttr, BILAppReaCon, BILExpGistExp, BILLongGoal, BILYearGoal, BILMon, BILMonSou, BILFinAllo, BILLastYearCarry, BILOthFun, BILOthExpProb, DepID, BILProName, BILProDescrip, BILProCategory, BILPlanHz)" + "VALUES (@BILProType, @BILFunSub, @PPID, @PIID, @BILAttr, @BILAppReaCon, @BILExpGistExp, @BILLongGoal, @BILYearGoal, @BILMon, @BILMonSou, @BILFinAllo, @BILLastYearCarry, @BILOthFun, @BILOthExpProb, @DepID, @BILProName, @BILProDescrip, @BILProCategory, @BILPlanHz)"; sql += " ; SELECT @@IDENTITY"; try { SqlParameter[] para = new SqlParameter[] { new SqlParameter("@BILProType", bG_BudItemsLibraries.BILProType), new SqlParameter("@BILFunSub", bG_BudItemsLibraries.BILFunSub), new SqlParameter("@PPID", bG_BudItemsLibraries.PPID), new SqlParameter("@PIID", bG_BudItemsLibraries.PIID), new SqlParameter("@BILAttr", bG_BudItemsLibraries.BILAttr), new SqlParameter("@BILAppReaCon", bG_BudItemsLibraries.BILAppReaCon), new SqlParameter("@BILExpGistExp", bG_BudItemsLibraries.BILExpGistExp), new SqlParameter("@BILLongGoal", bG_BudItemsLibraries.BILLongGoal), new SqlParameter("@BILYearGoal", bG_BudItemsLibraries.BILYearGoal), new SqlParameter("@BILMon", bG_BudItemsLibraries.BILMon), new SqlParameter("@BILMonSou", bG_BudItemsLibraries.BILMonSou), new SqlParameter("@BILFinAllo", bG_BudItemsLibraries.BILFinAllo), new SqlParameter("@BILLastYearCarry", bG_BudItemsLibraries.BILLastYearCarry), new SqlParameter("@BILOthFun", bG_BudItemsLibraries.BILOthFun), new SqlParameter("@BILOthExpProb", bG_BudItemsLibraries.BILOthExpProb), new SqlParameter("@DepID", bG_BudItemsLibraries.DepID), new SqlParameter("@BILProName", bG_BudItemsLibraries.BILProName), new SqlParameter("@BILProDescrip", bG_BudItemsLibraries.BILProDescrip), new SqlParameter("@BILProCategory", bG_BudItemsLibraries.BILProCategory), new SqlParameter("@BILPlanHz", bG_BudItemsLibraries.BILPlanHz) }; string IdStr = DBUnity.ExecuteScalar(CommandType.Text, sql, para); int newId = Convert.ToInt32(IdStr); return(GetBG_BudItemsLibrariesByBudItID(newId)); } catch (Exception e) { Console.WriteLine(e.Message); throw e; } }
private void txtBind(int buid) { BG_BudItemsLibraries bi = BG_BudItemsLibrariesManager.GetBG_BudItemsLibrariesByBudItID(buid);// if (bi != null) { txtBIAppReaCon.Text = bi.BILAppReaCon; ddlProProper.SelectedValue = bi.BILAttr; txtBIExpGistExp.Text = bi.BILExpGistExp; ddlFunSub.SelectedValue = bi.BILFunSub; txtBILMon.Text = bi.BILMon.ToString(); ddlDeptName.SelectedValue = bi.DepID.ToString(); txtBILongGoal.Text = bi.BILLongGoal; txtBIOthExpProb.Text = bi.BILOthExpProb; txtBIYearGoal.Text = bi.BILYearGoal; ddlPayProType.SelectedValue = bi.PPID.ToString(); txtProName.Text = bi.BILProName.ToString(); txtProDesc.Text = bi.BILProDescrip.ToString(); ddlProType.SelectedValue = bi.BILProCategory; } }
public static bool ModifyBG_BudItemsLibraries(BG_BudItemsLibraries bG_BudItemsLibraries) { return(BG_BudItemsLibrariesService.ModifyBG_BudItemsLibraries(bG_BudItemsLibraries)); }
public static bool DeleteBG_BudItemsLibraries(BG_BudItemsLibraries bG_BudItemsLibraries) { return(BG_BudItemsLibrariesService.DeleteBG_BudItemsLibraries(bG_BudItemsLibraries)); }
public static BG_BudItemsLibraries AddBG_BudItemsLibraries(BG_BudItemsLibraries bG_BudItemsLibraries) { return(BG_BudItemsLibrariesService.AddBG_BudItemsLibraries(bG_BudItemsLibraries)); }
public static bool ModifyBG_BudItemsLibraries(BG_BudItemsLibraries bG_BudItemsLibraries) { string sql = "UPDATE BG_BudItemsLibraries " + "SET " + "BILProType = @BILProType, " + "BILFunSub = @BILFunSub, " + "PPID = @PPID, " + "PIID = @PIID, " + "BILAttr = @BILAttr, " + "BILAppReaCon = @BILAppReaCon, " + "BILExpGistExp = @BILExpGistExp, " + "BILLongGoal = @BILLongGoal, " + "BILYearGoal = @BILYearGoal, " + "BILMon = @BILMon, " + "BILMonSou = @BILMonSou, " + "BILFinAllo = @BILFinAllo, " + "BILLastYearCarry = @BILLastYearCarry, " + "BILOthFun = @BILOthFun, " + "BILOthExpProb = @BILOthExpProb, " + "DepID = @DepID, " + "BILProName = @BILProName, " + "BILProDescrip = @BILProDescrip, " + "BILProCategory = @BILProCategory, " + "BILPlanHz = @BILPlanHz " + "WHERE BudItID = @BudItID"; try { SqlParameter[] para = new SqlParameter[] { new SqlParameter("@BudItID", bG_BudItemsLibraries.BudItID), new SqlParameter("@BILProType", bG_BudItemsLibraries.BILProType), new SqlParameter("@BILFunSub", bG_BudItemsLibraries.BILFunSub), new SqlParameter("@PPID", bG_BudItemsLibraries.PPID), new SqlParameter("@PIID", bG_BudItemsLibraries.PIID), new SqlParameter("@BILAttr", bG_BudItemsLibraries.BILAttr), new SqlParameter("@BILAppReaCon", bG_BudItemsLibraries.BILAppReaCon), new SqlParameter("@BILExpGistExp", bG_BudItemsLibraries.BILExpGistExp), new SqlParameter("@BILLongGoal", bG_BudItemsLibraries.BILLongGoal), new SqlParameter("@BILYearGoal", bG_BudItemsLibraries.BILYearGoal), new SqlParameter("@BILMon", bG_BudItemsLibraries.BILMon), new SqlParameter("@BILMonSou", bG_BudItemsLibraries.BILMonSou), new SqlParameter("@BILFinAllo", bG_BudItemsLibraries.BILFinAllo), new SqlParameter("@BILLastYearCarry", bG_BudItemsLibraries.BILLastYearCarry), new SqlParameter("@BILOthFun", bG_BudItemsLibraries.BILOthFun), new SqlParameter("@BILOthExpProb", bG_BudItemsLibraries.BILOthExpProb), new SqlParameter("@DepID", bG_BudItemsLibraries.DepID), new SqlParameter("@BILProName", bG_BudItemsLibraries.BILProName), new SqlParameter("@BILProDescrip", bG_BudItemsLibraries.BILProDescrip), new SqlParameter("@BILProCategory", bG_BudItemsLibraries.BILProCategory), new SqlParameter("@BILPlanHz", bG_BudItemsLibraries.BILPlanHz) }; 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_BudItemsLibraries(BG_BudItemsLibraries bG_BudItemsLibraries) { return(DeleteBG_BudItemsLibrariesByBudItID(bG_BudItemsLibraries.BudItID)); }