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();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
dvDisobeyRecord.DataSource = DisobeyRecordManager.getAllDisobeyRecord("", "", "全部", "全部");
dvDisobeyRecord.DataBind();
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
string statime = txtStatime.Value;
string endtime = txtEndtime.Value;
string carType = ddlCharType.SelectedValue;
string carMark = ddlCarMark.SelectedValue;
dvDisobeyRecord.DataSource = DisobeyRecordManager.getAllDisobeyRecord(statime, endtime, carType, carMark);
dvDisobeyRecord.DataBind();
}
protected void btnDel_Click(object sender, EventArgs e)
{
for (int i = 0; i < dvDisobeyRecord.Rows.Count; i++)
{
CheckBox cb = (CheckBox)dvDisobeyRecord.Rows[i].FindControl("input") as CheckBox;
if (cb.Checked == true)
{
HiddenField lfCarID = dvDisobeyRecord.Rows[i].FindControl("lblDR_Id") as HiddenField;
int id = Convert.ToInt32(lfCarID.Value);
DisobeyRecordManager.delDisobeyRecordById(id);
}
}
Response.Redirect("~/CarManager/DisobeyRecordlist.aspx");
}
/// <summary>
/// 利用PagedDataSource做数据源绑定数据分页
/// </summary>
/// <param name="pageIndex"></param>
private void DataBind(int pageIndex)
{
string statime = txtStatime.Value;
string endtime = txtEndtime.Value;
string carType = ddlCharType.SelectedValue;
string carMark = ddlCarMark.SelectedValue;
PagedDataSource pds = new PagedDataSource();
pds.AllowPaging = true;
pds.PageSize = CommHelper.GetPageCount;
IList <DisobeyRecord> list = null;
if (statime == "" && endtime == "" && carType == "全部" && carMark == "全部")
{
list = DisobeyRecordManager.getAllDisobeyRecord("", "", "全部", "全部");
}
else
{
list = DisobeyRecordManager.getAllDisobeyRecord(statime, endtime, carType, carMark);
}
if (list.Count == 0)
{
lblMessage.Visible = true;
lblMessage.Text = "无相应的记录";
}
else
{
lblMessage.Visible = false;
}
pds.DataSource = list;
pds.CurrentPageIndex = pageIndex; //取得当前页索引
Pager1.DataCount = list.Count; //获取记录数 并赋值
Pager1.PageCount = pds.PageCount;
dvDisobeyRecord.DataSourceID = null;
dvDisobeyRecord.DataSource = pds;
dvDisobeyRecord.DataBind();
}
protected void btnDel_Click(object sender, EventArgs e)
{
try
{
for (int i = 0; i < dvDisobeyRecord.Rows.Count; i++)
{
CheckBox cb = (CheckBox)dvDisobeyRecord.Rows[i].FindControl("input") as CheckBox;
if (cb.Checked == true)
{
HiddenField lfCarID = dvDisobeyRecord.Rows[i].FindControl("lblDR_Id") as HiddenField;
int id = Convert.ToInt32(lfCarID.Value);
DisobeyRecordManager.delDisobeyRecordById(id);
}
}
Response.Redirect("~/CarManager/DisobeyRecordlist.aspx");
}
catch (Exception ex)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('删除失败！');", true);
return;
}
}
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;
}
}
