private List <YearlyBudgetSingle> getBudgetList()
{
List <YearlyBudgetSingle> result = new List <YearlyBudgetSingle>();
//添加单品
int row_num = Convert.ToInt16(ViewState["count"]);
int year = Convert.ToInt16(year_txt.Text);
string[] ak = Request.Form.AllKeys;
for (int i = 0; i < Request.Form.Count; i++)
{
//只筛选出动态生成的三个控件的值
int counter = 0;
if (ak[i].IndexOf("box") > -1)
{
YearlyBudgetSingle item = new YearlyBudgetSingle();
item.ItemType = Request.Form[i++].ToString();
item.ItemDetail = Request.Form[i++].ToString();
item.Budget = Convert.ToDouble(Request.Form[i]);
item.Year = year;
result.Add(item);
}
}
return(result);
}
/// <summary>
/// 根据编号获取年度概算记录
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static YearlyBudget GetYearlyBudgetApplyByID(int id)
{
SqlConnection conn = new SqlConnection(connString);
SqlCommand cmd = new SqlCommand("SELECT * FROM [YearlyBudgetApplies] WHERE [ApplyID] = @ApplyID", conn);
cmd.Parameters.Add("@ApplyID", SqlDbType.Int).Value = id;
conn.Open();
SqlDataReader sdr = cmd.ExecuteReader();
YearlyBudget yi = null;
if (sdr.Read())
{
yi = new YearlyBudget();
yi.budgetList = new List <YearlyBudgetSingle>();
yi.staffName = (string)sdr["StaffName"];
yi.applyDate = Convert.ToDateTime(sdr["ApplyDate"]);
yi.ApproveProcess = sdr["ApproveProcess"] == DBNull.Value ? "" : (string)sdr["ApproveProcess"];
}
sdr.Close();
conn.Close();
double all = 0.0;
List <YearlyBudgetSingle> result = YearlyBudgetSingle.GetYearlyBudgetListByID(id, ref all);
yi.sum = all;
yi.budgetList.AddRange(result);
return(yi);
}
private static void SetSingleBudget(YearlyBudgetSingle os, int applyID, SqlConnection conn)
{
SqlCommand cmd = new SqlCommand("INSERT INTO [YearlyBudgetSingle] ([ApplyID], [ItemType], [ItemDetail], [Budget], [Year]) VALUES (@ApplyID, @ItemType, @ItemDetail, @Budget, @Year)", conn);
cmd.Parameters.Add("@ApplyID", SqlDbType.Int).Value = applyID;
cmd.Parameters.Add("@ItemType", SqlDbType.VarChar).Value = os.itemType;
cmd.Parameters.Add("@ItemDetail", SqlDbType.VarChar).Value = os.itemDetail;
cmd.Parameters.Add("@Budget", SqlDbType.Float).Value = os.budget;
cmd.Parameters.Add("@Year", SqlDbType.Int).Value = os.year;
cmd.ExecuteNonQuery();
}
protected void confirm_Click(object sender, EventArgs e)
{
Users usr = (Users)Session["Identify"];
BasicInfo info = BasicInfo.GetBasicInfoByID(usr.UserID);
YearlyBudget yi = new YearlyBudget();
yi.StaffName = info.StaffName;
yi.ApplyDate = DateTime.Today;
yi.ApproveProcess = "";
int recordid = YearlyBudget.SetYearlyBudgetByID(-1, yi, info.StaffName);
List <YearlyBudgetSingle> budgetList = getBudgetList();
YearlyBudgetSingle.SetOfficeSupplySingle(budgetList, recordid);
Response.Redirect("~/Account/ApplyListPage.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
int recordID = Convert.ToInt32(Request["RecordID"]);
int year = Convert.ToInt16(Request["year"]);
int month = Convert.ToInt16(Request["month"]);
bool approveFinished = Convert.ToBoolean(Request["finished"]);
if (recordID != 0)
{
YearlyBudget yi = YearlyBudget.GetYearlyBudgetApplyByID(recordID);
yearlyBudgetRowsTemp.Text = transResult(yi.BudgetList);
}
else
{
List <YearlyBudgetSingle> result = YearlyBudgetSingle.GetYearlyBudgetListByYear(year);
yearlyBudgetRowsTemp.Text = transResult(result);
}
}
/// <summary>
/// 根据年份得到年度概算表记录
/// </summary>
/// <param name="year"></param>
/// <returns></returns>
public static List <YearlyBudgetSingle> GetYearlyBudgetListByYear(int year)
{
SqlConnection conn = new SqlConnection(connString);
SqlCommand cmd = new SqlCommand("SELECT * FROM [YearlyBudgetSingle] WHERE [Year] = @Year ORDER BY [ItemType]", conn);
cmd.Parameters.Add("@Year", SqlDbType.Int).Value = year;
conn.Open();
SqlDataReader sdr = cmd.ExecuteReader();
List <YearlyBudgetSingle> result = new List <YearlyBudgetSingle>();
while (sdr.Read())
{
YearlyBudgetSingle temp = new YearlyBudgetSingle();
temp.itemType = (string)sdr["ItemType"];
temp.itemDetail = (string)sdr["ItemDetail"];
temp.budget = Convert.ToDouble(sdr["Budget"]);
temp.year = Convert.ToInt16(sdr["Year"]);
result.Add(temp);
}
conn.Close();
return(result);
}
