/// <summary> /// 按条件查询费用记录 /// </summary> /// <param name="statime"></param> /// <param name="endtime"></param> /// <param name="cs_CarType"></param> /// <param name="carMark"></param> /// <returns></returns> public IList <CostSupervise> getAllCostSupervise(string statime, string endtime, string cs_CarType, string carMark) { IList <CostSupervise> list = new List <CostSupervise>(); string sql = "prc_getAllCostSupervise"; SqlParameter[] parms = new SqlParameter[] { new SqlParameter("@Statime", statime), new SqlParameter("@Endtime", endtime), new SqlParameter("@CS_CarType", cs_CarType), new SqlParameter("@CarMark", carMark) }; using (SqlDataReader reader = DBHelper.ExecuteReaderProc(sql, parms)) { while (reader.Read()) { CostSupervise cs = new CostSupervise(); cs.BillPhoto = (string)reader["BillPhoto"]; cs.CarMark = (string)reader["CarMark"]; cs.CS_CarType = (string)reader["CS_CarType"]; cs.CS_Cost = Convert.ToDouble(reader["CS_Cost"]); cs.CS_Date = (DateTime)reader["CS_Date"]; cs.CS_Id = (int)reader["CS_Id"]; cs.CS_Item = (string)reader["CS_Item"]; cs.Remark = (string)reader["Remark"]; list.Add(cs); } reader.Close(); } return(list); }
/// <summary> /// 根据ID查看一条详细信息 /// </summary> /// <param name="c_Id"></param> /// <returns></returns> public CostSupervise getCostSuperviseById(int cs_Id) { IList <Cheer> list = new List <Cheer>(); string sql = "pro_getCostSuperviseById"; CostSupervise cs = null; SqlParameter[] parms = new SqlParameter[] { new SqlParameter("@CS_Id", cs_Id) }; using (SqlDataReader reader = DBHelper.ExecuteReaderProc(sql, parms)) { if (reader.Read()) { cs = new CostSupervise(); cs.BillPhoto = (string)reader["BillPhoto"]; cs.CarMark = (string)reader["CarMark"]; cs.CS_CarType = (string)reader["CS_CarType"]; cs.CS_Cost = Convert.ToDouble(reader["CS_Cost"]); cs.CS_Date = (DateTime)reader["CS_Date"]; cs.CS_Id = (int)reader["CS_Id"]; cs.CS_Item = (string)reader["CS_Item"]; cs.Remark = (string)reader["Remark"]; } reader.Close(); } return(cs); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string name = "0"; CS_Id = Convert.ToInt32(Request.QueryString["CS_Id"]); name = Request.QueryString["CS_name"]; if (CS_Id != 0) { CostSupervise cs = CostSuperviseManager.getCostSuperviseById(CS_Id); txtCS_Date.Value = cs.CS_Date.ToShortDateString(); ddlMark.DataSourceID = null; ddlMark.DataSource = CarsManager.GetAllCars(); ddlMark.DataTextField = "CarMark"; ddlMark.DataValueField = "Car_Id"; ddlMark.DataBind(); ddlMark.SelectedItem.Text = cs.CarMark; ddlCS_Item.SelectedValue = cs.CS_Item; txtC_Sum.Text = cs.CS_Cost.ToString(); rblCarType.SelectedValue = cs.CS_CarType; image.ImageUrl = cs.BillPhoto; txtRemark.Value = cs.Remark; } if (name == "Up") { rblCarType.Enabled = false; ddlMark.Enabled = false; } //else //{ // rblCarType.Enabled = false; //} } }
/// <summary> /// 添加一条信息 /// </summary> /// <param name="ch"></param> public static int addCostSupervise(CostSupervise cs) { try { return(CostSuperviseService.addCostSupervise(cs)); } catch (Exception ex) { throw new Exception(ex.ToString()); } }
/// <summary> /// 查询费用表所有的车牌号 /// </summary> /// <returns></returns> public IList <CostSupervise> getCostSupervise() { IList <CostSupervise> list = new List <CostSupervise>(); string sql = "pro_getCostSupervise"; using (SqlDataReader reader = DBHelper.ExecuteReaderProc(sql, null)) { while (reader.Read()) { CostSupervise cs = new CostSupervise(); cs.CarMark = (string)reader["CarMark"]; list.Add(cs); } reader.Close(); } return(list); }
/// <summary> /// 更新一条信息 /// </summary> /// <param name="cs"></param> /// <returns></returns> public int updateCostSupervise(CostSupervise cs) { string sql = "pro_updateCostSupervise"; SqlParameter[] parms = new SqlParameter[] { new SqlParameter("@CS_Id", cs.CS_Id), new SqlParameter("@CS_Date", cs.CS_Date), new SqlParameter("@CarMark", cs.CarMark), new SqlParameter("@CS_Item", cs.CS_Item), new SqlParameter("@CS_Cost", cs.CS_Cost), new SqlParameter("@CS_CarType", cs.CS_CarType), new SqlParameter("@Remark", cs.Remark), new SqlParameter("@BillPhoto", cs.BillPhoto) }; int result = DBHelper.ExecuteNonQueryProc(sql, parms); return(result); }
protected void btnSave_Click(object sender, EventArgs e) { string name = "0"; name = Request.QueryString["CS_name"]; CostSupervise cs = new CostSupervise(); cs.CS_Id = CS_Id; cs.CS_Date = Convert.ToDateTime(txtCS_Date.Value); cs.CarMark = ddlMark.SelectedItem.Text; cs.CS_Item = ddlCS_Item.SelectedValue; cs.CS_Cost = Convert.ToDouble(txtC_Sum.Text); cs.CS_CarType = rblCarType.SelectedValue; if (ddlMark.SelectedItem.Text == "请选择") { Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('请选择正确的车牌号!');", true); return; } //图片上传判断 string FileName = ""; if (fuBillPhoto.PostedFile != null) { FileName = System.IO.Path.GetFileName(fuBillPhoto.PostedFile.FileName).ToLower(); if (FileName == "") { Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('清单照片不能为空!');", true); return; } fuBillPhoto.PostedFile.SaveAs(Server.MapPath("~/images/UpLoad/" + FileName)); cs.BillPhoto = "~/images/UpLoad/" + FileName; } else { cs.BillPhoto = image.ImageUrl; } image.ImageUrl = cs.BillPhoto; cs.Remark = Server.HtmlDecode(txtRemark.Value); if (name == "Up") { int result = CostSuperviseManager.updateCostSupervise(cs); if (result != 0) { Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('更新成功!');window.location.href='ElseCostlist.aspx'", true); } else { Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('更新失败!');", true); txtCS_Date.Value = ""; txtC_Sum.Text = ""; txtRemark.Value = ""; return; } } else { int result = CostSuperviseManager.addCostSupervise(cs); if (result != 0) { Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('添加成功!');window.location.href='ElseCostlist.aspx'", true); } else { Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('添加失败!');", true); txtCS_Date.Value = ""; txtC_Sum.Text = ""; txtRemark.Value = ""; return; } } }