/// <summary> /// 添加一条信息 /// </summary> /// <param name="dr"></param> /// <returns></returns> public int addDisobeyRecord(DisobeyRecord dr) { string sql = "pro_AddDisobeyRecord"; SqlParameter[] parms = new SqlParameter[] { new SqlParameter("@BillPhoto", dr.BillPhoto), new SqlParameter("@CarMark", dr.CarMark), new SqlParameter("@Dr_CarType", dr.Dr_CarType), new SqlParameter("@DR_Circs", dr.DR_Circs), new SqlParameter("@DR_Date", dr.DR_Date), new SqlParameter("@DR_Department", dr.DR_Department), new SqlParameter("@DR_Expense", dr.DR_Expense), new SqlParameter("@DR_Explain", dr.DR_Explain), new SqlParameter("@DR_Locus", dr.DR_Locus), new SqlParameter("@DR_People", dr.DR_People), new SqlParameter("@DR_Sum", dr.DR_Sum), new SqlParameter("@DR_Type", dr.DR_Type), new SqlParameter("@FactCost", dr.FactCost), new SqlParameter("@Remark", dr.Remark) }; int result = DBHelper.ExecuteNonQueryProc(sql, parms); return(result); }
/// <summary> /// 根据ID查看一条详细信息 /// </summary> /// <param name="c_Id"></param> /// <returns></returns> public DisobeyRecord getDisobeyRecordById(int DR_Id) { string sql = "pro_getDisobeyRecordById"; DisobeyRecord dr = null; SqlParameter[] parms = new SqlParameter[] { new SqlParameter("@DR_Id", DR_Id) }; using (SqlDataReader reader = DBHelper.ExecuteReaderProc(sql, parms)) { if (reader.Read()) { dr = new DisobeyRecord(); dr.BillPhoto = (string)reader["BillPhoto"]; dr.CarMark = (string)reader["CarMark"]; dr.Dr_CarType = (string)reader["Dr_CarType"]; dr.DR_Circs = (string)reader["DR_Circs"]; dr.DR_Date = (DateTime)reader["DR_Date"]; dr.DR_Department = (string)reader["DR_Department"]; dr.DR_Expense = Convert.ToDouble(reader["DR_Expense"]); dr.DR_Explain = (string)reader["DR_Explain"]; dr.DR_Id = (int)reader["DR_Id"]; dr.DR_Locus = (string)reader["DR_Locus"]; dr.DR_People = (string)reader["DR_People"]; dr.DR_Sum = Convert.ToDouble(reader["DR_Sum"]); dr.DR_Type = (string)reader["DR_Type"]; dr.FactCost = Convert.ToDouble(reader["FactCost"]); dr.Remark = (string)reader["Remark"]; } reader.Close(); } return(dr); }
private void Dasoue() { DR_Id = Convert.ToInt32(Request.QueryString["DR_Id"]); DisobeyRecord dr = DisobeyRecordManager.getDisobeyRecordById(DR_Id); image.ImageUrl = dr.BillPhoto; rblDR_CarType.SelectedValue = dr.Dr_CarType; txtDR_Circs.Text = dr.DR_Circs; txtDR_Date.Value = dr.DR_Date.ToShortDateString(); txtDR_Expense.Text = dr.DR_Expense.ToString(); txtDR_Explain.Value = dr.DR_Explain; txtDR_Locus.Text = dr.DR_Locus; txtDR_Sum.Text = dr.DR_Sum.ToString(); ddlDR_Type.SelectedValue = dr.DR_Type; txtFactCost.Text = dr.FactCost.ToString(); txtRemark.Value = dr.Remark; image.ImageUrl = dr.BillPhoto; ddlDR_Department.DataSourceID = null; ddlDR_Department.DataSource = DepartmentManager.GetAllDepartment(); ddlDR_Department.DataTextField = "Departmentname"; ddlDR_Department.DataValueField = "Id"; ddlDR_Department.DataBind(); ddlDR_Department.SelectedValue = ddlDR_Department.Items.FindByText(dr.DR_Department).Value; NewMethod(); ddlDR_People.SelectedValue = ddlDR_People.Items.FindByText(dr.DR_People).Value; ddlCarMark.DataSourceID = null; ddlCarMark.DataSource = CarsManager.GetAllCars();; ddlCarMark.DataTextField = "CarMark"; ddlCarMark.DataValueField = "Car_Id"; ddlCarMark.DataBind(); ddlCarMark.SelectedValue = ddlCarMark.Items.FindByText(dr.CarMark).Value; NewMethod(); }
/// <summary> /// 跟新一条信息 /// </summary> /// <param name="dr"></param> /// <returns></returns> public static int updateDisobeyRecord(DisobeyRecord dr) { try { return(DisobeyRecordService.updateDisobeyRecord(dr)); } catch (Exception ex) { throw new Exception(ex.ToString()); } }
/// <summary> /// 查询事故违章的所有车牌号 /// </summary> /// <returns></returns> public IList <DisobeyRecord> getDisobeyRecordByMark() { IList <DisobeyRecord> list = new List <DisobeyRecord>(); string sql = "pro_getDisobeyRecordByMark"; using (SqlDataReader reader = DBHelper.ExecuteReaderProc(sql, null)) { while (reader.Read()) { DisobeyRecord dr = new DisobeyRecord(); dr.CarMark = (string)reader["CarMark"]; list.Add(dr); } reader.Close(); } return(list); }
/// <summary> /// 按条件查询事故违章记录 /// </summary> /// <param name="statime"></param> /// <param name="endtime"></param> /// <param name="c_CarType"></param> /// <param name="c_Station"></param> /// <returns></returns> public IList <DisobeyRecord> getAllDisobeyRecord(string statime, string endtime, string dr_CarType, string carMark) { IList <DisobeyRecord> list = new List <DisobeyRecord>(); string sql = "prc_getAllDisobeyRecord"; SqlParameter[] parms = new SqlParameter[] { new SqlParameter("@Statime", statime), new SqlParameter("@Endtime", endtime), new SqlParameter("@DR_CarType", dr_CarType), new SqlParameter("@CarMark", carMark) }; using (SqlDataReader reader = DBHelper.ExecuteReaderProc(sql, parms)) { while (reader.Read()) { DisobeyRecord dr = new DisobeyRecord(); dr.BillPhoto = (string)reader["BillPhoto"]; dr.CarMark = (string)reader["CarMark"]; dr.Dr_CarType = (string)reader["Dr_CarType"]; dr.DR_Circs = (string)reader["DR_Circs"]; dr.DR_Date = (DateTime)reader["DR_Date"]; dr.DR_Department = (string)reader["DR_Department"]; dr.DR_Expense = Convert.ToDouble(reader["DR_Expense"]); dr.DR_Explain = (string)reader["DR_Explain"]; dr.DR_Id = (int)reader["DR_Id"]; dr.DR_Locus = (string)reader["DR_Locus"]; dr.DR_People = (string)reader["DR_People"]; dr.DR_Sum = Convert.ToDouble(reader["DR_Sum"]); dr.DR_Type = (string)reader["DR_Type"]; dr.FactCost = Convert.ToDouble(reader["FactCost"]); dr.Remark = (string)reader["Remark"]; list.Add(dr); } reader.Close(); } return(list); }
protected void btnSave_Click(object sender, EventArgs e) { string name = "0"; name = Request.QueryString["DR_name"]; DisobeyRecord dr = new DisobeyRecord(); dr.DR_Id = Convert.ToInt32(Request.QueryString["DR_Id"]); string FileName = System.IO.Path.GetFileName(fuBillPhoto.PostedFile.FileName).ToLower(); if (!string.IsNullOrEmpty(FileName)) { fuBillPhoto.PostedFile.SaveAs(Server.MapPath("~/images/UpLoad/" + FileName)); dr.BillPhoto = "~/images/UpLoad/" + FileName; } else { dr.BillPhoto = ""; } dr.CarMark = ddlCarMark.SelectedItem.Text; dr.Dr_CarType = rblDR_CarType.SelectedValue; dr.DR_Circs = txtDR_Circs.Text; dr.DR_Date = Convert.ToDateTime(txtDR_Date.Value); dr.DR_Department = ddlDR_Department.SelectedItem.Text; dr.DR_Expense = Convert.ToDouble(txtDR_Expense.Text); dr.DR_Explain = txtDR_Explain.Value; dr.DR_Locus = txtDR_Locus.Text; dr.DR_People = ddlDR_People.SelectedItem.Text; dr.DR_Sum = Convert.ToDouble(txtDR_Sum.Text); dr.DR_Type = ddlDR_Type.SelectedValue; dr.FactCost = Convert.ToDouble(txtFactCost.Text); dr.Remark = txtRemark.Value; image.ImageUrl = dr.BillPhoto; if (name == "Up") { int result = DisobeyRecordManager.updateDisobeyRecord(dr); if (result != 0) { Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('更新成功!');window.location.href='DisobeyRecordlist.aspx'", true); } else { Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('更新失败!');", true); return; } } else { int result = DisobeyRecordManager.addDisobeyRecord(dr); if (result != 0) { Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('添加成功!');window.location.href='DisobeyRecordlist.aspx'", true); } else { Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('添加失败!');", true); return; } } }
protected void btnSave_Click(object sender, EventArgs e) { try { string name = "0"; name = Request.QueryString["DR_name"]; DisobeyRecord dr = new DisobeyRecord(); dr.DR_Id = Convert.ToInt32(Request.QueryString["DR_Id"]); if (ddlCarMark.SelectedItem.Text == "请选择") { Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('温馨提示:请选择正确的车牌号!')", true); return; } else { dr.CarMark = ddlCarMark.SelectedItem.Text; } dr.Dr_CarType = rblDR_CarType.SelectedValue; dr.DR_Date = Convert.ToDateTime(txtDR_Date.Value); if (ddlDR_Department.SelectedItem.Text == "请选择") { Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('温馨提示:请选择正确的部门!')", true); return; } else { dr.DR_Department = ddlDR_Department.SelectedItem.Text; } dr.DR_Explain = Server.HtmlDecode(txtDR_Explain.Value.Trim()); dr.DR_Locus = txtDR_Locus.Text.Trim(); if (ddlDR_People.SelectedItem.Text == "") { Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('温馨提示:该部门没人,请选择其它部门!')", true); return; } else { dr.DR_People = ddlDR_People.SelectedItem.Text; } dr.DR_Type = ddlDR_Type.SelectedValue; //类型(违章,事故) dr.DR_Expense = Convert.ToDouble(txtDR_Expense.Text); //经 济 损 失 dr.DR_Sum = Convert.ToDouble(txtDR_Sum.Text.Trim()); //罚 款 金额 dr.FactCost = Convert.ToDouble(txtFactCost.Text.Trim()); //实际赔偿费 dr.DR_Circs = txtDR_Circs.Text.Trim(); dr.Remark = Server.HtmlDecode(txtRemark.Value.Trim()); //图片上传判断 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)); dr.BillPhoto = "~/images/UpLoad/" + FileName; } else { dr.BillPhoto = image.ImageUrl; } image.ImageUrl = dr.BillPhoto; if (name == "Up") { int result = DisobeyRecordManager.updateDisobeyRecord(dr); if (result != 0) { Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('更新成功!');window.location.href='DisobeyRecordlist.aspx'", true); } else { Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('更新失败!');", true); return; } } else { int result = DisobeyRecordManager.addDisobeyRecord(dr); if (result != 0) { Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('添加成功!');window.location.href='DisobeyRecordlist.aspx'", true); } else { Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('添加失败!');", true); return; } } } catch (Exception ex) { throw new Exception(ex.ToString()); return; } }