public static bool AddSingleBudgetConCell(BG_BudgetConCell cell)
{
//添加单条记录
//
bool flag = false;
try
{
string sqlstr = @"insert into BG_BudgetConCell(PIID,BCCName,BCCStan,BCCUseSta)
values(@PIID,@BCCName,@BCCStan,@BCCUseSta)";
SqlParameter[] Pars = new SqlParameter[] {
new SqlParameter("@PIID",cell.PIID),
new SqlParameter("@BCCName",cell.BCCName),
new SqlParameter("@BCCStan",cell.BCCStan),
new SqlParameter("@BCCUseSta",cell.BCCUseSta)
};
flag = DBUnity.ExecuteNonQuery(CommandType.Text, sqlstr, Pars) > 0;
}
catch (Exception ex)
{
flag = false;
Log.WriteLog(ex.Message, "BGBudgetConCellService--AddSingleBudgetConCell");
}
return flag;
}
public static BG_BudgetConCell AddBG_BudgetConCell(BG_BudgetConCell bG_BudgetConCell)
{
string sql =
"INSERT BG_BudgetConCell (PIID, BCCName, BCCStan, BCCUseSta)" +
"VALUES (@PIID, @BCCName, @BCCStan, @BCCUseSta)";
sql += " ; SELECT @@IDENTITY";
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@PIID", bG_BudgetConCell.PIID),
new SqlParameter("@BCCName", bG_BudgetConCell.BCCName),
new SqlParameter("@BCCStan", bG_BudgetConCell.BCCStan),
new SqlParameter("@BCCUseSta", bG_BudgetConCell.BCCUseSta)
};
string IdStr = DBUnity.ExecuteScalar(CommandType.Text, sql, para);
int newId = Convert.ToInt32(IdStr);
return GetBG_BudgetConCellByBCCID(newId);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
/// <summary>
/// 单项添加
/// </summary>
/// <param name="cell">Cell</param>
/// <returns></returns>
public static bool AddSingleBudgetConCell(BG_BudgetConCell cell)
{
return BGBudgetConCellService.AddSingleBudgetConCell(cell);
}
protected void btnMod_Click(object sender, EventArgs e)
{
//添加-->
BG_BudgetConCell cell = null;
List<BG_BudgetConCell> list = new List<BG_BudgetConCell>();
int piidInt = common.IntSafeConvert(piid);
if (ckA.Checked)
{
//启用
cell = new BG_BudgetConCell();
cell.PIID = piidInt;
cell.BCCName = common.RemoveUnsafeHtml(tbA.Text.Trim());
cell.BCCStan = ParseUtil.ToDecimal(tbCtrA.Text.Trim(), 0);
cell.BCCUseSta = "启用";
list.Add(cell);
}
if (ckB.Checked)
{
//启用
cell = new BG_BudgetConCell();
cell.PIID = piidInt;
cell.BCCName = common.RemoveUnsafeHtml(tbB.Text.Trim());
cell.BCCStan = ParseUtil.ToDecimal(tbCtrB.Text.Trim(), 0);
cell.BCCUseSta = "启用";
list.Add(cell);
}
if (ckC.Checked)
{
//启用
cell = new BG_BudgetConCell();
cell.PIID = piidInt;
cell.BCCName = common.RemoveUnsafeHtml(tbC.Text.Trim());
cell.BCCStan = ParseUtil.ToDecimal(tbCtrC.Text.Trim(), 0);
cell.BCCUseSta = "启用";
list.Add(cell);
}
if (ckD.Checked)
{
//启用
cell = new BG_BudgetConCell();
cell.PIID = piidInt;
cell.BCCName = common.RemoveUnsafeHtml(tbD.Text.Trim());
cell.BCCStan = ParseUtil.ToDecimal(tbCtrD.Text.Trim(), 0);
cell.BCCUseSta = "启用";
list.Add(cell);
}
if (ckE.Checked)
{
//启用
cell = new BG_BudgetConCell();
cell.PIID = piidInt;
cell.BCCName = common.RemoveUnsafeHtml(tbE.Text.Trim());
cell.BCCStan = ParseUtil.ToDecimal(tbCtrE.Text.Trim(), 0);
cell.BCCUseSta = "启用";
list.Add(cell);
}
if (ckF.Checked)
{
//启用
cell = new BG_BudgetConCell();
cell.PIID = piidInt;
cell.BCCName = common.RemoveUnsafeHtml(tbF.Text.Trim());
cell.BCCStan = ParseUtil.ToDecimal(tbCtrF.Text.Trim(), 0);
cell.BCCUseSta = "启用";
list.Add(cell);
}
bool flag = BGBudgetConCellManager.UpdateBantch(list, piid);
if (flag)
{
Response.Redirect("BudProjectList.aspx", true);
}
}
public static bool ModifyBG_BudgetConCell(BG_BudgetConCell bG_BudgetConCell)
{
return BG_BudgetConCellService.ModifyBG_BudgetConCell(bG_BudgetConCell);
}
public static bool DeleteBG_BudgetConCell(BG_BudgetConCell bG_BudgetConCell)
{
return BG_BudgetConCellService.DeleteBG_BudgetConCell(bG_BudgetConCell);
}
public static BG_BudgetConCell AddBG_BudgetConCell(BG_BudgetConCell bG_BudgetConCell)
{
return BG_BudgetConCellService.AddBG_BudgetConCell(bG_BudgetConCell);
}
protected void btnAdd_Click(object sender, EventArgs e)
{
//添加-->
string piid = ddlPayIncome.SelectedItem.Value;
int piidInt = common.IntSafeConvert(piid);
BG_BudgetConCell cell = null;
List<BG_BudgetConCell> list = new List<BG_BudgetConCell>();
if (ckA.Checked)
{
//A启用
cell = new BG_BudgetConCell();
cell.PIID = piidInt;
cell.BCCName = common.RemoveUnsafeHtml(tbA.Text.Trim());
cell.BCCStan = ParseUtil.ToDecimal(tbCtrA.Text.Trim(), 0);
cell.BCCUseSta = "启用";
list.Add(cell);
}
if (ckB.Checked)
{
//B启用
cell = new BG_BudgetConCell();
cell.PIID = piidInt;
cell.BCCName = common.RemoveUnsafeHtml(tbB.Text .Trim ());
cell.BCCStan = ParseUtil.ToDecimal(tbCtrB .Text .Trim (),0);
cell.BCCUseSta = "启用";
list.Add(cell);
}
if (ckC.Checked)
{
//C启用
cell = new BG_BudgetConCell();
cell.PIID = piidInt;
cell.BCCName = common.RemoveUnsafeHtml(tbC.Text.Trim());
cell.BCCStan = ParseUtil.ToDecimal(tbCtrC.Text.Trim(), 0);
cell.BCCUseSta = "启用";
list.Add(cell);
}
if (ckD.Checked)
{
//D启用
cell = new BG_BudgetConCell();
cell.PIID = piidInt;
cell.BCCName = common.RemoveUnsafeHtml(tbD.Text.Trim());
cell.BCCStan = ParseUtil.ToDecimal(tbCtrD.Text.Trim(), 0);
cell.BCCUseSta = "启用";
list.Add(cell);
}
if (ckE.Checked)
{
//E启用
cell = new BG_BudgetConCell();
cell.PIID = piidInt;
cell.BCCName = common.RemoveUnsafeHtml(tbE.Text.Trim());
cell.BCCStan = ParseUtil.ToDecimal(tbCtrE.Text.Trim(), 0);
cell.BCCUseSta = "启用";
list.Add(cell);
}
if (ckF.Checked)
{
//F启用
cell = new BG_BudgetConCell();
cell.PIID = piidInt;
cell.BCCName = common.RemoveUnsafeHtml(tbF.Text.Trim());
cell.BCCStan = ParseUtil.ToDecimal(tbCtrF.Text.Trim(), 0);
cell.BCCUseSta = "启用";
list.Add(cell);
}
//添加项目预算控制记录
BG_BudgetCon bgBudget = new BG_BudgetCon();
bgBudget.PIID = piidInt;
bgBudget.YNUse = "启用";
bgBudget.BCRemark = "备注";
BGBudgetConManager.AddBudgetCon(bgBudget);
//批量添加项目预算控制单元记录
BGBudgetConCellManager.AddBudgetConCell(list);
Response.Redirect("BudProjectList.aspx", true);
}
public static BG_BudgetConCell GetBG_BudgetConCellByBCCID(int bCCID)
{
string sql = "SELECT * FROM BG_BudgetConCell WHERE BCCID = @BCCID";
try
{
SqlParameter para = new SqlParameter("@BCCID", bCCID);
DataTable dt = DBUnity.AdapterToTab(sql, para);
if(dt.Rows.Count > 0)
{
BG_BudgetConCell bG_BudgetConCell = new BG_BudgetConCell();
bG_BudgetConCell.BCCID = dt.Rows[0]["BCCID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["BCCID"];
bG_BudgetConCell.PIID = dt.Rows[0]["PIID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PIID"];
bG_BudgetConCell.BCCName = dt.Rows[0]["BCCName"] == DBNull.Value ? "" : (string)dt.Rows[0]["BCCName"];
bG_BudgetConCell.BCCStan = dt.Rows[0]["BCCStan"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["BCCStan"];
bG_BudgetConCell.BCCUseSta = dt.Rows[0]["BCCUseSta"] == DBNull.Value ? "" : (string)dt.Rows[0]["BCCUseSta"];
return bG_BudgetConCell;
}
else
{
return null;
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
public static bool DeleteBG_BudgetConCell(BG_BudgetConCell bG_BudgetConCell)
{
return DeleteBG_BudgetConCellByBCCID( bG_BudgetConCell.BCCID );
}
public static bool ModifyBG_BudgetConCell(BG_BudgetConCell bG_BudgetConCell)
{
string sql =
"UPDATE BG_BudgetConCell " +
"SET " +
"PIID = @PIID, " +
"BCCName = @BCCName, " +
"BCCStan = @BCCStan, " +
"BCCUseSta = @BCCUseSta " +
"WHERE BCCID = @BCCID";
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@BCCID", bG_BudgetConCell.BCCID),
new SqlParameter("@PIID", bG_BudgetConCell.PIID),
new SqlParameter("@BCCName", bG_BudgetConCell.BCCName),
new SqlParameter("@BCCStan", bG_BudgetConCell.BCCStan),
new SqlParameter("@BCCUseSta", bG_BudgetConCell.BCCUseSta)
};
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;
}
}