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); }