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