/// <summary>
/// 获取项目自增编号
/// </summary>
/// <returns></returns>
public static string GetBICode(string year)
{
string ac = ConfigurationManager.AppSettings["AreaCode"].ToString();
//string year = DateTime.Now.Year.ToString();
//string codeTwo = ac + year;
int bicode = common.IntSafeConvert(year + "0001");
try
{
string sqlStr = "select max(BudID) from BG_BudItems";
string budidStr = DBUnity.ExecuteScalar(CommandType.Text, sqlStr, null);
int budid = common.IntSafeConvert(budidStr);
if (budid > 0)
{
BG_BudItems bi = GetBudItemsByBudid(budid);
bicode = common.IntSafeConvert(bi.BICode.Replace(ac, string.Empty)) + 1;
}
}
catch (Exception ex)
{
Log.WriteLog(ex.Message, "BGBudItemsService--GetBICode");
}
ac += bicode.ToString();
return(ac);
}
private void txtBind(int buid)
{
BG_BudItems bi = BGBudItemsManager.GetBudItemsByBudid(buid);
if (bi != null)
{
txtBIAppReaCon.Text = bi.BIAppReaCon;
// txtProName.Text = bi
ddlProProper.SelectedValue = bi.BIAttr;
txtBICharger.Text = bi.BICharger;
txtItemNumber.Text = bi.BICode.ToString();
txtBIExpGistExp.Text = bi.BIExpGistExp;
ddlFunSub.SelectedValue = bi.BIFunSub;
txtBILongGoal.Text = bi.BILongGoal;
txtBIOthExpProb.Text = bi.BIOthExpProb;
ddlBIPlanHz.Text = bi.BIPlanHz.ToString();
//ddlPayProType.SelectedValue = bi.BIProType;
txtBIStaTime.Text = bi.BIStaTime.ToString("yyyy-MM-dd");
txtBIEndTime.Text = bi.BIEndTime.ToString("yyyy-MM-dd");
txtBITime.Text = bi.BIReportTime.ToString("yyyy-MM-dd");
txtBIYearGoal.Text = bi.BIYearGoal;
ddlPayProType.SelectedValue = bi.PPID.ToString();
hidPPID.Value = bi.PPID.ToString();
txtProName.Text = bi.BIProName.ToString();
txtProDesc.Text = bi.BIProDescrip.ToString();
txtBIMon.Text = bi.BIMon.ToString();
txtBackReason.Text = bi.BICause;
txtBudConNumber.Text = bi.BIConNum.ToString();
Hiddepid.Value = bi.DepID.ToString();
ddlProType.SelectedValue = bi.BIProCategory;
hidSta.Value = bi.BudSta;
}
}
public static BG_BudItems GetBG_BudItemsByBudID(int budID)
{
string sql = "SELECT * FROM BG_BudItems WHERE BudID = @BudID";
try
{
SqlParameter para = new SqlParameter("@BudID", budID);
DataTable dt = DBUnity.AdapterToTab(sql, para);
if (dt.Rows.Count > 0)
{
BG_BudItems bG_BudItems = new BG_BudItems();
bG_BudItems.BudID = dt.Rows[0]["BudID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["BudID"];
bG_BudItems.BIProType = dt.Rows[0]["BIProType"] == DBNull.Value ? "" : (string)dt.Rows[0]["BIProType"];
bG_BudItems.BIFunSub = dt.Rows[0]["BIFunSub"] == DBNull.Value ? "" : (string)dt.Rows[0]["BIFunSub"];
bG_BudItems.BICode = dt.Rows[0]["BICode"] == DBNull.Value ? "" : (string)dt.Rows[0]["BICode"];
bG_BudItems.PPID = dt.Rows[0]["PPID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PPID"];
bG_BudItems.PIID = dt.Rows[0]["PIID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PIID"];
bG_BudItems.BIPlanHz = dt.Rows[0]["BIPlanHz"] == DBNull.Value ? "" : (string)dt.Rows[0]["BIPlanHz"];
bG_BudItems.BIStaTime = dt.Rows[0]["BIStaTime"] == DBNull.Value ? DateTime.MinValue : (DateTime)dt.Rows[0]["BIStaTime"];
bG_BudItems.BIEndTime = dt.Rows[0]["BIEndTime"] == DBNull.Value ? DateTime.MinValue : (DateTime)dt.Rows[0]["BIEndTime"];
bG_BudItems.BICharger = dt.Rows[0]["BICharger"] == DBNull.Value ? "" : (string)dt.Rows[0]["BICharger"];
bG_BudItems.BIAttr = dt.Rows[0]["BIAttr"] == DBNull.Value ? "" : (string)dt.Rows[0]["BIAttr"];
bG_BudItems.BIAppReaCon = dt.Rows[0]["BIAppReaCon"] == DBNull.Value ? "" : (string)dt.Rows[0]["BIAppReaCon"];
bG_BudItems.BIExpGistExp = dt.Rows[0]["BIExpGistExp"] == DBNull.Value ? "" : (string)dt.Rows[0]["BIExpGistExp"];
bG_BudItems.BILongGoal = dt.Rows[0]["BILongGoal"] == DBNull.Value ? "" : (string)dt.Rows[0]["BILongGoal"];
bG_BudItems.BIYearGoal = dt.Rows[0]["BIYearGoal"] == DBNull.Value ? "" : (string)dt.Rows[0]["BIYearGoal"];
bG_BudItems.BIMon = dt.Rows[0]["BIMon"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["BIMon"];
bG_BudItems.BIAppConMon = dt.Rows[0]["BIAppConMon"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["BIAppConMon"];
bG_BudItems.BIMonSou = dt.Rows[0]["BIMonSou"] == DBNull.Value ? "" : (string)dt.Rows[0]["BIMonSou"];
bG_BudItems.BIFinAllo = dt.Rows[0]["BIFinAllo"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["BIFinAllo"];
bG_BudItems.BILastYearCarry = dt.Rows[0]["BILastYearCarry"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["BILastYearCarry"];
bG_BudItems.BIOthFun = dt.Rows[0]["BIOthFun"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["BIOthFun"];
bG_BudItems.BIOthExpProb = dt.Rows[0]["BIOthExpProb"] == DBNull.Value ? "" : (string)dt.Rows[0]["BIOthExpProb"];
bG_BudItems.BIBudSta = dt.Rows[0]["BIBudSta"] == DBNull.Value ? "" : (string)dt.Rows[0]["BIBudSta"];
bG_BudItems.BudSta = dt.Rows[0]["BudSta"] == DBNull.Value ? "" : (string)dt.Rows[0]["BudSta"];
bG_BudItems.BICause = dt.Rows[0]["BICause"] == DBNull.Value ? "" : (string)dt.Rows[0]["BICause"];
bG_BudItems.DepID = dt.Rows[0]["DepID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["DepID"];
bG_BudItems.BIProName = dt.Rows[0]["BIProName"] == DBNull.Value ? "" : (string)dt.Rows[0]["BIProName"];
bG_BudItems.BIReportTime = dt.Rows[0]["BIReportTime"] == DBNull.Value ? DateTime.MinValue : (DateTime)dt.Rows[0]["BIReportTime"];
bG_BudItems.BIConNum = dt.Rows[0]["BIConNum"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["BIConNum"];
bG_BudItems.BIProDescrip = dt.Rows[0]["BIProDescrip"] == DBNull.Value ? "" : (string)dt.Rows[0]["BIProDescrip"];
bG_BudItems.BIProCategory = dt.Rows[0]["BIProCategory"] == DBNull.Value ? "" : (string)dt.Rows[0]["BIProCategory"];
bG_BudItems.BIYear = dt.Rows[0]["BIYear"] == DBNull.Value ? 0 : (int)dt.Rows[0]["BIYear"];
return(bG_BudItems);
}
else
{
return(null);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
protected void btnReturn_Click(object sender, EventArgs e)
{
BG_BudItems bi = BGBudItemsManager.GetBudItemsByBudid(budid);
bi.BudSta = "退回";
bi.BIConNum = ParseUtil.ToDecimal(txtBudConNumber.Text.Trim(), 0);
bi.BICause = txtBackReason.Text.Trim();
BG_BudItemHis hisbi = new BG_BudItemHis();
hisbi.BudID = budid;
hisbi.BIAppConMon = 0;// decimal.Parse(txtBudConNumber.Text.Trim());审批控制金额，应该是预算控制数
hisbi.BIAppReaCon = txtBIAppReaCon.Text.Trim();
hisbi.BIAttr = ddlProProper.SelectedValue;
hisbi.BIBudSta = "等下对接"; //Session[Constant.UserName].ToString();
hisbi.BICause = txtBackReason.Text.Trim(); //退回原因
hisbi.BICharger = txtBICharger.Text.Trim();
hisbi.BICode = txtItemNumber.Text.Trim(); //项目编号
hisbi.BIEndTime = DateTime.Parse(txtBIEndTime.Text.Trim());
hisbi.BIExpGistExp = txtBIExpGistExp.Text.Trim();
hisbi.BIConNum = ParseUtil.ToDecimal(txtBudConNumber.Text, 0);
hisbi.BIFinAllo = 0; // decimal.Parse(txtBudConNumber.Text.Trim());财政拨款
hisbi.BIFunSub = ddlFunSub.Text.Trim();
hisbi.BILastYearCarry = 0; // decimal.Parse(txtBudConNumber.Text.Trim());上年结账
hisbi.BILongGoal = txtBILongGoal.Text.Trim();
hisbi.BIMon = common.IntSafeConvert(txtBIMon.Text); //GetBIMon(coll.GetValues("txt4"));
hisbi.BIMonSou = ""; //资金来源
hisbi.BIOthExpProb = txtBIOthExpProb.Text.Trim();
hisbi.BIOthFun = 0; // decimal.Parse(txtBudConNumber.Text.Trim());其他资金
hisbi.BIPlanHz = ddlBIPlanHz.SelectedValue; //项目频度
hisbi.BIProType = ddlPayProType.SelectedItem.Text;
hisbi.BIStaTime = DateTime.Parse(txtBIStaTime.Text.Trim());
hisbi.BIYearGoal = txtBIYearGoal.Text.Trim();
hisbi.PPID = common.IntSafeConvert(ddlPayProType.SelectedValue); //
hisbi.BudSta = "退回"; //
hisbi.PIID = BG_PayProjectManager.GetBG_PayProjectByPPID(bi.PPID).PIID; //common.IntSafeConvert(ddlFunSub.SelectedValue);//yj
hisbi.BIProName = txtProName.Text.Trim();
hisbi.BIReportTime = ParseUtil.ToDateTime(txtBITime.Text.Trim(), DateTime.Now);
//hisbi.BIConNum = 0;//预算控制数
hisbi.BIProDescrip = txtProDesc.Text.Trim();
hisbi.DepID = common.IntSafeConvert(Hiddepid.Value);
hisbi.BIProCategory = ddlProType.SelectedItem.Text;
int flaid = BG_BudItemHisManager.AddBG_BudItemHis(hisbi).BudHisID;
if (BGBudItemsManager.UpdBudItems(bi) && flaid > 0)
{
btnAppo.ForeColor = Color.Gray;
btnAppo.Enabled = false;
btnElimin.ForeColor = Color.Gray;
btnElimin.Enabled = false;
lblShowResult.Text = "项目已退回";
}
else
{
lblShowResult.Text = "操作失败、请重试";
}
}
protected void btnElimin_Click(object sender, EventArgs e)
{
string message = "被淘汰的项目不可以恢复，是否淘汰?";
Response.Write("<script language=javascript>alert(\"" + message.Trim() + "\");window.top.close();</script>");
BG_BudItems bi = BGBudItemsManager.GetBudItemsByBudid(budid);
bi.BudSta = "淘汰";
bi.BIConNum = ParseUtil.ToDecimal(txtBudConNumber.Text.Trim(), 0);
bi.BICause = txtBackReason.Text.Trim();
if (BGBudItemsManager.UpdBudItems(bi))
{
BG_BudItemHis hisbi = new BG_BudItemHis();
hisbi.BudID = budid;
hisbi.BIAppConMon = bi.BIAppConMon;
hisbi.BIAppReaCon = bi.BIAppReaCon;
hisbi.BIAttr = bi.BIAttr;
hisbi.BIBudSta = bi.BIBudSta;
hisbi.BICause = bi.BICause;
hisbi.BICharger = bi.BICharger;
hisbi.BICode = bi.BICode;
hisbi.BIEndTime = bi.BIEndTime;
hisbi.BIExpGistExp = bi.BIExpGistExp;
hisbi.BIFinAllo = bi.BIFinAllo;
hisbi.BIFunSub = bi.BIFunSub;
hisbi.BILastYearCarry = bi.BILastYearCarry;
hisbi.BILongGoal = bi.BILongGoal;
hisbi.BIMon = bi.BIMon;
hisbi.BIMonSou = bi.BIMonSou;
hisbi.BIOthExpProb = bi.BIOthExpProb;
hisbi.BIOthFun = bi.BIOthFun;
hisbi.BIPlanHz = bi.BIPlanHz;
hisbi.BIProType = bi.BIProType;
hisbi.BIStaTime = bi.BIStaTime;
hisbi.BIYearGoal = bi.BIYearGoal;
hisbi.PPID = bi.PPID;
hisbi.BudSta = bi.BudSta;
hisbi.PIID = bi.PIID;
hisbi.BIProName = bi.BIProName;
hisbi.BIReportTime = bi.BIReportTime;
hisbi.BIConNum = bi.BIConNum;
hisbi.BIProDescrip = bi.BIProDescrip;
hisbi.DepID = bi.DepID;
hisbi.BIProCategory = bi.BIProCategory;
BG_BudItemHisManager.AddBG_BudItemHis(hisbi);
btnAppo.ForeColor = Color.Gray;
btnAppo.Enabled = false;
btnReturn.ForeColor = Color.Gray;
btnReturn.Enabled = false;
lblShowResult.Text = "项目已淘汰";
}
else
{
lblShowResult.Text = "操作失败、请重试";
}
}
public static BG_BudItems AddBG_BudItems(BG_BudItems bG_BudItems)
{
string sql =
"INSERT BG_BudItems (BIProType, BIFunSub, BICode, PPID, PIID, BIPlanHz, BIStaTime, BIEndTime, BICharger, BIAttr, BIAppReaCon, BIExpGistExp, BILongGoal, BIYearGoal, BIMon, BIAppConMon, BIMonSou, BIFinAllo, BILastYearCarry, BIOthFun, BIOthExpProb, BIBudSta, BudSta, BICause, DepID, BIProName, BIReportTime, BIConNum, BIProDescrip, BIProCategory, BIYear)" +
"VALUES (@BIProType, @BIFunSub, @BICode, @PPID, @PIID, @BIPlanHz, @BIStaTime, @BIEndTime, @BICharger, @BIAttr, @BIAppReaCon, @BIExpGistExp, @BILongGoal, @BIYearGoal, @BIMon, @BIAppConMon, @BIMonSou, @BIFinAllo, @BILastYearCarry, @BIOthFun, @BIOthExpProb, @BIBudSta, @BudSta, @BICause, @DepID, @BIProName, @BIReportTime, @BIConNum, @BIProDescrip, @BIProCategory, @BIYear)";
sql += " ; SELECT @@IDENTITY";
try
{
SqlParameter[] para = new SqlParameter[]
{
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)
};
string IdStr = DBUnity.ExecuteScalar(CommandType.Text, sql, para);
int newId = Convert.ToInt32(IdStr);
return(GetBG_BudItemsByBudID(newId));
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
/// <summary>
/// 根据Budid获取单条BGBudItems记录
/// </summary>
/// <param name="biid"></param>
/// <returns></returns>
public static BG_BudItems GetBudItemsByBudid(int Budid)
{
BG_BudItems budItems = new BG_BudItems();
string sqlStr = "select * from BG_BudItems where BudID=@BudID";
SqlParameter[] Pars = new SqlParameter[] {
new SqlParameter("@BudID", Budid)
};
try
{
SqlDataReader dr = DBUnity.ExecuteReader(CommandType.Text, sqlStr, Pars);
while (dr.Read())
{
budItems.BudID = common.IntSafeConvert(dr["BudID"]);
budItems.BIProType = dr["BIProType"].ToString();
budItems.BIFunSub = dr["BIFunSub"].ToString();
budItems.BICode = dr["BICode"].ToString();
budItems.PPID = common.IntSafeConvert(dr["PPID"]);
budItems.PIID = common.IntSafeConvert(dr["PIID"]);
budItems.BIPlanHz = dr["BIPlanHz"].ToString();
budItems.BIStaTime = ParseUtil.ToDateTime(dr["BIStaTime"].ToString(), DateTime.Now);
budItems.BIEndTime = ParseUtil.ToDateTime(dr["BIEndTime"].ToString(), DateTime.Now);
budItems.BICharger = dr["BICharger"].ToString();
budItems.BIAttr = dr["BIAttr"].ToString();
budItems.BIAppReaCon = dr["BIAppReaCon"].ToString();
budItems.BIExpGistExp = dr["BIExpGistExp"].ToString();
budItems.BILongGoal = dr["BILongGoal"].ToString();
budItems.BIYearGoal = dr["BIYearGoal"].ToString();
budItems.BIMon = ParseUtil.ToDecimal(dr["BIMon"].ToString(), 0);
budItems.BIAppConMon = ParseUtil.ToDecimal(dr["BIAppConMon"].ToString(), 0);
budItems.BIMonSou = dr["BIMonSou"].ToString();
budItems.BIFinAllo = ParseUtil.ToDecimal(dr["BIFinAllo"].ToString(), 0);
budItems.BILastYearCarry = ParseUtil.ToDecimal(dr["BILastYearCarry"].ToString(), 0);
budItems.BIOthFun = ParseUtil.ToDecimal(dr["BIOthFun"].ToString(), 0);
budItems.BIOthExpProb = dr["BIOthExpProb"].ToString();
budItems.BIBudSta = dr["BIBudSta"].ToString();
budItems.BudSta = dr["BudSta"].ToString();
budItems.BICause = dr["BICause"].ToString();
budItems.DepID = common.IntSafeConvert(dr["DepID"]);
budItems.BIProName = dr["BIProName"].ToString();
budItems.BIReportTime = ParseUtil.ToDateTime(dr["BIReportTime"].ToString(), DateTime.Now);
budItems.BIConNum = ParseUtil.ToDecimal(dr["BIConNum"].ToString(), 0);
budItems.BIProDescrip = dr["BIProDescrip"].ToString();
budItems.BIProCategory = dr["BIProCategory"].ToString();
}
dr.Close();
}
catch (Exception ex)
{
budItems = null;
Log.WriteLog(ex.Message, "BGBudItemsService--GetBudItemsByBiid");
}
return(budItems);
}
/// <summary>
/// 添加一条预算项目信息
/// </summary>
/// <param name="budItems">一条预算项目实例</param>
/// <returns>bool</returns>
public static bool AddbudItems(BG_BudItems budItems)
{
bool flag = false;
try
{
string sqlStr = @"insert into BG_BudItems(BIProType,BIFunSub,BICode,PPID,PIID,BIPlanHz,BIStaTime,BIEndTime,BICharger,BIAttr,BIAppReaCon,
BIExpGistExp,BILongGoal,BIYearGoal,BIMon,BIAppConMon,BIMonSou,BIFinAllo,BILastYearCarry,BIOthFun,BIOthExpProb,BIBudSta,BudSta,BICause,DepID,BIProName,BIReportTime,BIConNum,BIProDescrip,BIProCategory)
values(@BIProType,@BIFunSub,@BICode,@PPID,@PIID,@BIPlanHz,@BIStaTime,@BIEndTime,@BICharger,@BIAttr,@BIAppReaCon,@BIExpGistExp,@BILongGoal,
@BIYearGoal,@BIMon,@BIAppConMon,@BIMonSou,@BIFinAllo,@BILastYearCarry,@BIOthFun,@BIOthExpProb,@BIBudSta,@BudSta,@BICause,@DepID,@BIProName,@BIReportTime,@BIConNum,@BIProDescrip,@BIProCategory)";
SqlParameter[] Pars = new SqlParameter[] {
new SqlParameter("@BIProType", budItems.BIProType),
new SqlParameter("@BIFunSub", budItems.BIFunSub),
new SqlParameter("@BICode", budItems.BICode),
new SqlParameter("@PPID", budItems.PPID),
new SqlParameter("@PIID", budItems.PIID),
new SqlParameter("@BIPlanHz", budItems.BIPlanHz),
new SqlParameter("@BIStaTime", budItems.BIStaTime),
new SqlParameter("@BIEndTime", budItems.BIEndTime),
new SqlParameter("@BICharger", budItems.BICharger),
new SqlParameter("@BIAttr", budItems.BIAttr),
new SqlParameter("@BIAppReaCon", budItems.BIAppReaCon),
new SqlParameter("@BIExpGistExp", budItems.BIExpGistExp),
new SqlParameter("@BILongGoal", budItems.BILongGoal),
new SqlParameter("@BIYearGoal", budItems.BIYearGoal),
new SqlParameter("@BIMon", budItems.BIMon),
new SqlParameter("@BIAppConMon", budItems.BIAppConMon),
new SqlParameter("@BIMonSou", budItems.BIMonSou),
new SqlParameter("@BIFinAllo", budItems.BIFinAllo),
new SqlParameter("@BILastYearCarry", budItems.BILastYearCarry),
new SqlParameter("@BIOthFun", budItems.BIOthFun),
new SqlParameter("@BIOthExpProb", budItems.BIOthExpProb),
new SqlParameter("@BIBudSta", budItems.BIBudSta),
new SqlParameter("@BudSta", budItems.BudSta),
new SqlParameter("@BICause", budItems.BICause),
new SqlParameter("@DepID", budItems.DepID),
new SqlParameter("@BIProName", budItems.BIProName),
new SqlParameter("@BIReportTime", budItems.BIReportTime),
new SqlParameter("@BIConNum", budItems.BIConNum),
new SqlParameter("@BIProDescrip", budItems.BIProDescrip),
new SqlParameter("@BIProCategory", budItems.BIProCategory)
};
flag = DBUnity.ExecuteNonQuery(CommandType.Text, sqlStr, Pars) > 0;
}
catch (Exception ex)
{
flag = false;
Log.WriteLog(ex.Message, "BGBudItemsService--AddbudItems");
}
return(flag);
}
/// <summary>
/// 修改指定预算项目信息
/// </summary>
/// <param name="budItems">BGBudItems</param>
/// <returns>bool</returns>
public static bool UpdBudItems(BG_BudItems budItems)
{
bool flag = false;
try
{
string sqlStr = @"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 ,BIProName=@BIProName,BIReportTime=@BIReportTime,BIConNum=@BIConNum,BIProDescrip=@BIProDescrip,BIProCategory =@BIProCategory where BudID = @BudID";
SqlParameter[] Pars = new SqlParameter[] {
new SqlParameter("@BudID", budItems.BudID),
new SqlParameter("@BIProType", budItems.BIProType),
new SqlParameter("@BIFunSub", budItems.BIFunSub),
new SqlParameter("@BICode", budItems.BICode),
new SqlParameter("@PPID", budItems.PPID),
new SqlParameter("@PIID", budItems.PIID),
new SqlParameter("@BIPlanHz", budItems.BIPlanHz),
new SqlParameter("@BIStaTime", budItems.BIStaTime),
new SqlParameter("@BIEndTime", budItems.BIEndTime),
new SqlParameter("@BICharger", budItems.BICharger),
new SqlParameter("@BIAttr", budItems.BIAttr),
new SqlParameter("@BIAppReaCon", budItems.BIAppReaCon),
new SqlParameter("@BIExpGistExp", budItems.BIExpGistExp),
new SqlParameter("@BILongGoal", budItems.BILongGoal),
new SqlParameter("@BIYearGoal", budItems.BIYearGoal),
new SqlParameter("@BIMon", budItems.BIMon),
new SqlParameter("@BIAppConMon", budItems.BIAppConMon),
new SqlParameter("@BIMonSou", budItems.BIMonSou),
new SqlParameter("@BIFinAllo", budItems.BIFinAllo),
new SqlParameter("@BILastYearCarry", budItems.BILastYearCarry),
new SqlParameter("@BIOthFun", budItems.BIOthFun),
new SqlParameter("@BIOthExpProb", budItems.BIOthExpProb),
new SqlParameter("@BIBudSta", budItems.BIBudSta),
new SqlParameter("@BudSta", budItems.BudSta),
new SqlParameter("@BICause", budItems.BICause),
new SqlParameter("@BIProName", budItems.BIProName),
new SqlParameter("@BIReportTime", budItems.BIReportTime),
new SqlParameter("@BIConNum", budItems.BIConNum),
new SqlParameter("@BIProDescrip", budItems.BIProDescrip),
new SqlParameter("@BIProCategory", budItems.BIProCategory)
};
flag = DBUnity.ExecuteNonQuery(CommandType.Text, sqlStr, Pars) > 0;
}
catch (Exception ex)
{
Log.WriteLog(ex.Message, "BGBudItemsService--UpdBudItems");
}
return(flag);
}
/// <summary>
/// 添加BGBudItems并返回其ID
/// </summary>
/// <param name="budItems"></param>
/// <returns>int</returns>
public static int AddBudItemsBackbuid(BG_BudItems budItems)
{
int biid = 0;
try
{
string sqlStr = @"insert into BG_BudItems(BIProType,BIFunSub,BICode,PPID,PIID,BIPlanHz,BIStaTime,BIEndTime,BICharger,BIAttr,BIAppReaCon,
BIExpGistExp,BILongGoal,BIYearGoal,BIMon,BIAppConMon,BIMonSou,BIFinAllo,BILastYearCarry,BIOthFun,BIOthExpProb,BIBudSta,BudSta,BICause,DepID,BIProName,BIReportTime,BIConNum,BIProDescrip,BIProCategory)
values(@BIProType,@BIFunSub,@BICode,@PPID,@PIID,@BIPlanHz,@BIStaTime,@BIEndTime,@BICharger,@BIAttr,@BIAppReaCon,@BIExpGistExp,@BILongGoal,
@BIYearGoal,@BIMon,@BIAppConMon,@BIMonSou,@BIFinAllo,@BILastYearCarry,@BIOthFun,@BIOthExpProb,@BIBudSta,@BudSta,@BICause,@DepID,@BIProName,@BIReportTime,@BIConNum,@BIProDescrip,@BIProCategory);SELECT SCOPE_IDENTITY()";
SqlParameter[] Pars = new SqlParameter[] {
new SqlParameter("@BIProType", budItems.BIProType),
new SqlParameter("@BIFunSub", budItems.BIFunSub),
new SqlParameter("@BICode", budItems.BICode),
new SqlParameter("@PPID", budItems.PPID),
new SqlParameter("@PIID", budItems.PIID),
new SqlParameter("@BIPlanHz", budItems.BIPlanHz),
new SqlParameter("@BIStaTime", budItems.BIStaTime),
new SqlParameter("@BIEndTime", budItems.BIEndTime),
new SqlParameter("@BICharger", budItems.BICharger),
new SqlParameter("@BIAttr", budItems.BIAttr),
new SqlParameter("@BIAppReaCon", budItems.BIAppReaCon),
new SqlParameter("@BIExpGistExp", budItems.BIExpGistExp),
new SqlParameter("@BILongGoal", budItems.BILongGoal),
new SqlParameter("@BIYearGoal", budItems.BIYearGoal),
new SqlParameter("@BIMon", budItems.BIMon),
new SqlParameter("@BIAppConMon", budItems.BIAppConMon),
new SqlParameter("@BIMonSou", budItems.BIMonSou),
new SqlParameter("@BIFinAllo", budItems.BIFinAllo),
new SqlParameter("@BILastYearCarry", budItems.BILastYearCarry),
new SqlParameter("@BIOthFun", budItems.BIOthFun),
new SqlParameter("@BIOthExpProb", budItems.BIOthExpProb),
new SqlParameter("@BIBudSta", budItems.BIBudSta),
new SqlParameter("@BudSta", budItems.BudSta),
new SqlParameter("@BICause", budItems.BICause),
new SqlParameter("@DepID", budItems.DepID),
new SqlParameter("@BIProName", budItems.BIProName),
new SqlParameter("@BIReportTime", budItems.BIReportTime),
new SqlParameter("@BIConNum", budItems.BIConNum),
new SqlParameter("@BIProDescrip", budItems.BIProDescrip),
new SqlParameter("@BIProCategory", budItems.BIProCategory)
};
biid = common.IntSafeConvert(DBUnity.ExecuteScalar(CommandType.Text, sqlStr, Pars));
}
catch (Exception ex)
{
biid = 0;
Log.WriteLog(ex.Message, "BGBudItemsService--AddbudItems");
}
return(biid);
}
protected void btnAppo_Click(object sender, EventArgs e)
{
bool flag = BGBudItemsManager.UpdBudSta(budid, "审核通过");
if (flag)
{
BG_BudItems bi = BGBudItemsManager.GetBudItemsByBudid(budid);
BG_BudItemHis hisbi = new BG_BudItemHis();
hisbi.BudID = budid;
hisbi.BIAppConMon = bi.BIAppConMon;
hisbi.BIAppReaCon = bi.BIAppReaCon;
hisbi.BIAttr = bi.BIAttr;
hisbi.BIBudSta = bi.BIBudSta;
hisbi.BICause = bi.BICause;
hisbi.BICharger = bi.BICharger;
hisbi.BICode = bi.BICode;
hisbi.BIEndTime = bi.BIEndTime;
hisbi.BIExpGistExp = bi.BIExpGistExp;
hisbi.BIFinAllo = bi.BIFinAllo;
hisbi.BIFunSub = bi.BIFunSub;
hisbi.BILastYearCarry = bi.BILastYearCarry;
hisbi.BILongGoal = bi.BILongGoal;
hisbi.BIMon = bi.BIMon;
hisbi.BIConNum = ParseUtil.ToDecimal(txtBudConNumber.Text, 0);
hisbi.BIMonSou = bi.BIMonSou;
hisbi.BIOthExpProb = bi.BIOthExpProb;
hisbi.BIOthFun = bi.BIOthFun;
hisbi.BIPlanHz = bi.BIPlanHz;
hisbi.BIProType = bi.BIProType;
hisbi.BIStaTime = bi.BIStaTime;
hisbi.BIYearGoal = bi.BIYearGoal;
hisbi.PPID = bi.PPID;
hisbi.BudSta = bi.BudSta;
hisbi.PIID = bi.PIID;
hisbi.BIProName = bi.BIProName;
hisbi.BIReportTime = bi.BIReportTime;
hisbi.BIProDescrip = bi.BIProDescrip;
hisbi.DepID = bi.DepID;
hisbi.BIProCategory = bi.BIProCategory;
BG_BudItemHisManager.AddBG_BudItemHis(hisbi);
btnElimin.ForeColor = Color.Gray;
btnElimin.Enabled = false;
btnReturn.ForeColor = Color.Gray;
btnReturn.Enabled = false;
lblShowResult.Text = "项目上报成功";
}
else
{
lblShowResult.Text = "操作失败、请重试";
}
}
public void SubMit_Handler(int budId)
{
if (BGBudItemsManager.UpdBudSta(budId, "提交"))
{
Bind();
BG_BudItems bi = BGBudItemsManager.GetBudItemsByBudid(budId);
BG_BudItemHis hisbi = new BG_BudItemHis();
hisbi.BudID = budId;
hisbi.BIAppConMon = bi.BIAppConMon;
hisbi.BIAppReaCon = bi.BIAppReaCon;
hisbi.BIAttr = bi.BIAttr;
hisbi.BIBudSta = bi.BIBudSta;
hisbi.BICause = bi.BICause;
hisbi.BICharger = bi.BICharger;
hisbi.BICode = bi.BICode;
hisbi.BIEndTime = bi.BIEndTime;
hisbi.BIExpGistExp = bi.BIExpGistExp;
hisbi.BIFinAllo = bi.BIFinAllo;
hisbi.BIFunSub = bi.BIFunSub;
hisbi.BILastYearCarry = bi.BILastYearCarry;
hisbi.BILongGoal = bi.BILongGoal;
hisbi.BIMon = bi.BIMon;
hisbi.BIMonSou = bi.BIMonSou;
hisbi.BIOthExpProb = bi.BIOthExpProb;
hisbi.BIOthFun = bi.BIOthFun;
hisbi.BIPlanHz = bi.BIPlanHz;
hisbi.BIProType = bi.BIProType;
hisbi.BIStaTime = bi.BIStaTime;
hisbi.BIYearGoal = bi.BIYearGoal;
hisbi.PPID = bi.PPID;
hisbi.BudSta = bi.BudSta;
hisbi.PIID = bi.PIID;
hisbi.BIProName = bi.BIProName;
hisbi.BIReportTime = bi.BIReportTime;
hisbi.BIConNum = bi.BIConNum;
hisbi.BIProDescrip = bi.BIProDescrip;
hisbi.DepID = bi.DepID;
hisbi.BIProCategory = bi.BIProCategory;
hisbi.BIYear = bi.BIYear;
BG_BudItemHisManager.AddBG_BudItemHis(hisbi);
}
}
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;
}
}
/// <summary>
/// 添加一条预算项目历史实例
/// </summary>
/// <param name="budItems"></param>
/// <returns></returns>
public static bool InsertBudItemHis(BG_BudItems budItems)
{
return(BGBudItemHisService.InsertBudItemHis(budItems));
}
public static bool DeleteBG_BudItems(BG_BudItems bG_BudItems)
{
return(BG_BudItemsService.DeleteBG_BudItems(bG_BudItems));
}
public static bool ModifyBG_BudItems(BG_BudItems bG_BudItems)
{
return(BG_BudItemsService.ModifyBG_BudItems(bG_BudItems));
}
public static BG_BudItems AddBG_BudItems(BG_BudItems bG_BudItems)
{
return(BG_BudItemsService.AddBG_BudItems(bG_BudItems));
}
protected void btnUpd_Click(object sender, EventArgs e)
{
int bid = common.IntSafeConvert(Hidbuid.Value);
BG_BudItems bi = BGBudItemsManager.GetBudItemsByBudid(bid);
bi.BIAppReaCon = txtBIAppReaCon.Text.Trim();
bi.BIAttr = ddlProProper.SelectedValue;
bi.BIBudSta = ""; //Session[Constant.UserName].ToString();
bi.BudSta = "未提交";
bi.BICharger = txtBICharger.Text.Trim();
//bi.BICode =txtItemNumber.Text.Trim();
bi.BIEndTime = DateTime.Parse(txtBIEndTime.Text.Trim());
bi.BIExpGistExp = txtBIExpGistExp.Text.Trim();
bi.BIFunSub = ddlFunSub.SelectedValue;
bi.BILongGoal = txtBILongGoal.Text.Trim();
bi.BIOthExpProb = txtBIOthExpProb.Text.Trim();
bi.BIPlanHz = ddlBIPlanHz.SelectedValue;
bi.BIProType = ddlPayProType.SelectedItem.Text;
bi.BIStaTime = DateTime.Parse(txtBIStaTime.Text.Trim());
bi.BIYearGoal = txtBIYearGoal.Text.Trim();
bi.PPID = common.IntSafeConvert(ddlPayProType.SelectedValue);
bi.BIProName = txtProName.Text.Trim();
bi.BIReportTime = ParseUtil.ToDateTime(txtBITime.Text.Trim(), DateTime.Now);
// bi.BIConNum = 0;
bi.BIProDescrip = txtProDesc.Text.Trim();
bi.BIProCategory = ddlProType.SelectedValue;
decimal bimon = ParseUtil.ToDecimal(HidMonTotal.Value, 0); //GetBIMon(coll.GetValues("txt4"));
bi.BIMon = bimon;
int buid = bi.BudID;
int depid = bi.DepID;
int bcn = (int)ParseUtil.ToDecimal(txtBudConNumber.Text, 0);
if (bcn != 0)
{
decimal bunconnum = bi.BIConNum;
if (bunconnum < bimon)
{
lblShowResult.Text = "*预算金额超标！";
return;
}
}
if (BGBudItemsManager.UpdBudItems(bi))
{
string idStrs = BGBudCostProManager.GetDelIdsStr(buid);
bool delFlag = BGBudCostProManager.DelBCPByIdStrs(idStrs);
if (delFlag)
{
NameValueCollection coll = Request.Form;
string selectVal = HidSelectVal.Value.TrimEnd(',');
string[] arrs = selectVal.Split(',');
string[] txt1 = coll.GetValues("txt1"); //行号
string[] txt2 = coll.GetValues("txt2"); //当前年度
string[] txt3 = arrs; //经济科目
string[] txt4 = coll.GetValues("txt4"); //总计
string[] txt5 = coll.GetValues("txt5"); //小计(财政拨款)
string[] txt6 = coll.GetValues("txt6"); //小计(经费)
string[] txt7 = coll.GetValues("txt7"); //内部开支(经费)
string[] txt8 = coll.GetValues("txt8"); //外部拨款(经费)
int rowCount = common.IntSafeConvert(HidRowCount.Value);
bool flag = false;
if (rowCount > 0)
{
for (int j = 0; j < rowCount; j++)
{
BG_BudCostPro bcp = new BG_BudCostPro();
bcp.BudID = buid;
bcp.BCPCurrYear = common.IntSafeConvert(txt2[j]);
bcp.BCPRemark = "";
bcp.PIID = common.IntSafeConvert(txt3[j]);
bcp.BCPTotal = ParseUtil.ToDecimal(txt4[j], 0);
bcp.BCPSubtFinAllo = ParseUtil.ToDecimal(txt5[j], 0);
bcp.BCPSubtExp = ParseUtil.ToDecimal(txt6[j], 0);
bcp.BCInExpenses = ParseUtil.ToDecimal(txt7[j], 0);
bcp.BCOutFunding = ParseUtil.ToDecimal(txt8[j], 0);
flag = BGBudCostProManager.AddBGBudCostPro(bcp);
}
}
if (flag)
{
txtBind(buid);
repPayProjectBind(buid);
lblShowResult.Text = "修改成功";
//string PostUrl = "BudgetEditList.aspx?depid=" + depid;
// Response.Write("<script language='javascript'>alert('修改成功！');window.location.href='" + PostUrl + "';</script>");
}
else
{
lblShowResult.Text = "操作失败、请检查数据后重试";
}
}
else
{
lblShowResult.Text = "操作失败、请检查数据后重试";
}
}
else
{
lblShowResult.Text = "操作失败、请检查数据后重试";
}
}
/// <summary>
/// 修改指定预算项目信息
/// </summary>
/// <param name="budItems">BGBudItems</param>
/// <returns>bool</returns>
public static bool UpdBudItems(BG_BudItems budItems)
{
return(BGBudItemsService.UpdBudItems(budItems));
}
/// <summary>
/// 添加一条预算项目信息
/// </summary>
/// <param name="budItems">一条预算项目实例</param>
/// <returns>bool</returns>
public static bool AddbudItems(BG_BudItems budItems)
{
return(BGBudItemsService.AddbudItems(budItems));
}
/// <summary>
/// 添加BGBudItems并返回其ID
/// </summary>
/// <param name="budItems"></param>
/// <returns>int</returns>
public static int AddBudItemsBackbuid(BG_BudItems budItems)
{
return(BGBudItemsService.AddBudItemsBackbuid(budItems));
}
public static bool DeleteBG_BudItems(BG_BudItems bG_BudItems)
{
return(DeleteBG_BudItemsByBudID(bG_BudItems.BudID));
}
protected void btnSure_Click(object sender, EventArgs e)
{
BG_BudItems bi = new BG_BudItems();
bi.BIAppConMon = 0;// decimal.Parse(txtBudConNumber.Text.Trim());审批控制金额，应该是预算控制数
bi.BIAppReaCon = txtBIAppReaCon1.Text.Trim();
bi.BIAttr = ddlProProper1.SelectedValue;
bi.BIBudSta = "等下对接"; //Session[Constant.UserName].ToString();
bi.BICause = ""; //退回原因
bi.BICharger = txtBICharger1.Text.Trim();
bi.BICode = txtItemNumber1.Text.Trim(); //项目编号
bi.BIEndTime = DateTime.Parse(txtBIEndTime1.Text.Trim());
bi.BIExpGistExp = txtBIExpGistExp1.Text.Trim();
bi.BIFinAllo = 0; // decimal.Parse(txtBudConNumber.Text.Trim());财政拨款
bi.BIFunSub = ddlFunSub1.Text.Trim();
bi.BILastYearCarry = 0; // decimal.Parse(txtBudConNumber.Text.Trim());上年结账
bi.BILongGoal = txtBILongGoal1.Text.Trim();
bi.BIMon = common.IntSafeConvert(HidMonTotal.Value); //GetBIMon(coll.GetValues("txt4"));
bi.BIMonSou = ""; //资金来源
bi.BIOthExpProb = txtBIOthExpProb1.Text.Trim();
bi.BIOthFun = 0; // decimal.Parse(txtBudConNumber.Text.Trim());其他资金
bi.BIPlanHz = ddlBIPlanHz1.SelectedValue; //项目频度
bi.BIProType = ddlPayProType1.SelectedItem.Text;
bi.BIStaTime = DateTime.Parse(txtBIStaTime1.Text.Trim());
bi.BIYearGoal = txtBIYearGoal1.Text.Trim();
bi.PPID = common.IntSafeConvert(ddlPayProType1.SelectedValue); //
bi.BudSta = "未提交"; //
bi.PIID = BG_PayProjectManager.GetBG_PayProjectByPPID(bi.PPID).PIID; //common.IntSafeConvert(ddlFunSub.SelectedValue);//yj
bi.BIProName = txtProName1.Text.Trim();
bi.BIReportTime = ParseUtil.ToDateTime(txtBITime1.Text.Trim(), DateTime.Now);
bi.BIConNum = 0;//预算控制数
bi.BIProDescrip = txtProDesc1.Text.Trim();
bi.DepID = common.IntSafeConvert(Hiddepid.Value);
bi.BIProCategory = ddlProType1.SelectedItem.Text;
bi.BIYear = common.IntSafeConvert(txtyear.Text);
int buid = BG_BudItemsManager.AddBG_BudItems(bi).BudID;//yj
if (buid > 0)
{
BG_BudItemHis hisbi = new BG_BudItemHis();
hisbi.BudID = buid;
hisbi.BIAppConMon = 0;// decimal.Parse(txtBudConNumber.Text.Trim());审批控制金额，应该是预算控制数
hisbi.BIAppReaCon = txtBIAppReaCon.Text.Trim();
hisbi.BIAttr = ddlProProper.SelectedValue;
hisbi.BIBudSta = "等下对接"; //Session[Constant.UserName].ToString();
hisbi.BICause = ""; //退回原因
hisbi.BICharger = txtBICharger.Text.Trim();
hisbi.BICode = txtItemNumber.Text.Trim(); //项目编号
hisbi.BIEndTime = DateTime.Parse(txtBIEndTime.Text.Trim());
hisbi.BIExpGistExp = txtBIExpGistExp.Text.Trim();
hisbi.BIFinAllo = 0; // decimal.Parse(txtBudConNumber.Text.Trim());财政拨款
hisbi.BIFunSub = ddlFunSub.Text.Trim();
hisbi.BILastYearCarry = 0; // decimal.Parse(txtBudConNumber.Text.Trim());上年结账
hisbi.BILongGoal = txtBILongGoal.Text.Trim();
hisbi.BIMon = common.IntSafeConvert(HidMonTotal.Value); //GetBIMon(coll.GetValues("txt4"));
hisbi.BIMonSou = ""; //资金来源
hisbi.BIOthExpProb = txtBIOthExpProb.Text.Trim();
hisbi.BIOthFun = 0; // decimal.Parse(txtBudConNumber.Text.Trim());其他资金
hisbi.BIPlanHz = ddlBIPlanHz.SelectedValue; //项目频度
hisbi.BIProType = ddlPayProType.SelectedItem.Text;
hisbi.BIStaTime = DateTime.Parse(txtBIStaTime.Text.Trim());
hisbi.BIYearGoal = txtBIYearGoal.Text.Trim();
hisbi.PPID = common.IntSafeConvert(ddlPayProType.SelectedValue); //
hisbi.BudSta = "未提交"; //
hisbi.PIID = BG_PayProjectManager.GetBG_PayProjectByPPID(bi.PPID).PIID; //common.IntSafeConvert(ddlFunSub.SelectedValue);//yj
hisbi.BIProName = txtProName.Text.Trim();
hisbi.BIReportTime = ParseUtil.ToDateTime(txtBITime.Text.Trim(), DateTime.Now);
hisbi.BIConNum = 0;//预算控制数
hisbi.BIProDescrip = txtProDesc.Text.Trim();
hisbi.DepID = common.IntSafeConvert(Hiddepid.Value);
hisbi.BIProCategory = ddlProType.SelectedItem.Text;
hisbi.BIYear = common.IntSafeConvert(txtyear.Text);
int flaid = BG_BudItemHisManager.AddBG_BudItemHis(hisbi).BudHisID;
NameValueCollection coll = Request.Form;
string[] txt1 = coll.GetValues("txt1"); //行号
string[] txt2 = coll.GetValues("txt2"); //当前年度
string[] txt3 = coll.GetValues("ddlIncome"); //经济科目
string[] txt4 = coll.GetValues("txt4"); //总计
string[] txt5 = coll.GetValues("txt5"); //小计(财政拨款)
string[] txt6 = coll.GetValues("txt6"); //小计(经费)
string[] txt7 = coll.GetValues("txt7"); //内部开支(经费)
string[] txt8 = coll.GetValues("txt8"); //外部拨款(经费)
int rowCount = common.IntSafeConvert(HidRowCount.Value);
bool flag = false;
if (rowCount > 0 && flaid > 0)
{
for (int j = 0; j < rowCount; j++)
{
BG_BudCostPro bcp = new BG_BudCostPro();
bcp.BudID = buid;
bcp.BCPCurrYear = common.IntSafeConvert(txt2[j]);
bcp.BCPRemark = "";
DataTable dtpiid = BG_PayIncomeLogic.GetBG_PayIncomeByname(txt3[j]);
int piid = common.IntSafeConvert(dtpiid.Rows[0]["PIID"]);
bcp.PIID = piid;
bcp.BCPTotal = ParseUtil.ToDecimal(txt4[j], 0);
bcp.BCPSubtFinAllo = ParseUtil.ToDecimal(txt5[j], 0);
bcp.BCPSubtExp = ParseUtil.ToDecimal(txt6[j], 0);
bcp.BCInExpenses = ParseUtil.ToDecimal(txt7[j], 0);
bcp.BCOutFunding = ParseUtil.ToDecimal(txt8[j], 0);
flag = BGBudCostProManager.AddBGBudCostPro(bcp);//yj
}
}
if (flag)
{
lblShowResult.Text = "添加成功";
BGBudItemHisManage.InsertBudItemHis(bi);
string PostUrl = "BudgetEditList.aspx?depid=" + Hiddepid.Value;
Response.Write("<script language='javascript'>if(confirm('是否继续添加?')){window.location.reload();}else{window.location.href='" + PostUrl + "';}</script>");
}
else
{
lblShowResult.Text = "操作失败、请检查数据后重试";
}
}
else
{
lblShowResult.Text = "操作失败、请检查数据后重试";
}
}
