protected void gvByappyl_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "del") { string Id = e.CommandArgument.ToString(); try { Car_Byapply cars = CarByapplyManager.GetAllCarsByappyById(Convert.ToInt32(Id)); if (cars.State == "待办") { Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('此车还未审批,不能删除!');", true); } else { int num = CarByapplyManager.DeleteByapply(Id); if (num > 0) { Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('删除成功!');", true); } gvByappyl.DataSourceID = null; gvByappyl.DataSource = odsbyappy; gvByappyl.DataBind(); } } catch { Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('删除失败!');", true); return; } } }
protected void gvByappyl_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { HiddenField ByappyId = e.Row.FindControl("lblByappyId") as HiddenField; Car_Byapply cars = CarByapplyManager.GetAllCarsByappyById(Convert.ToInt32(ByappyId.Value)); if (cars.State == "待办") { LinkButton lbReturn = e.Row.FindControl("lbSend") as LinkButton; LinkButton lndel = e.Row.FindControl("lbDel") as LinkButton; lbReturn.Enabled = false; lndel.Enabled = false; } if (cars.State == "终结") { LinkButton lbReturn = e.Row.FindControl("lbSend") as LinkButton; lbReturn.Enabled = false; } //设置行颜色 e.Row.Attributes.Add("onmouseover", "currentcolor=this.style.backgroundColor;this.style.backgroundColor='#ff9900'"); e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=currentcolor"); } }
public void Bind(int id) { Car_Byapply car = CarByapplyManager.GetAllCarsByappyById(Id); txtOutData.Text = car.ByData.ToString(); drpDept.DataSourceID = null; drpDept.DataSource = DepartmentManager.GetAllDepartment(); drpDept.DataTextField = "departmentName"; drpDept.DataValueField = "Id"; drpDept.DataBind(); drpDept.SelectedValue = car.ByDept.Id.ToString(); txtMan.Text = car.ByMan.ToString(); txtReMark.Text = car.ByCause.ToString(); txtDirection.Text = car.ByDttion.ToString(); txtReturnDate.Text = car.ByReData.ToString(); if (car.ByTypeid.TypeId == 1) { rdo1.Checked = true; } else if (car.ByTypeid.TypeId == 2) { rdo2.Checked = true; } else if (car.ByTypeid.TypeId == 3) { rdo3.Checked = true; } else { rdo4.Checked = true; } }
public Car_Byapply GetAllCarsByappyById(int Id) { string sql = "usp_CarSelcectByapplyById"; using (SqlDataReader reader = DBHelper.ExecuteReaderProc(sql, new SqlParameter("@ByapplyId", Id))) { if (reader.Read()) { Car_Byapply Car = new Car_Byapply(); Car.ByapplyId = (int)reader["ByapplyId"]; Car.ByCause = (string)reader["ByCause"]; Car.ByData = (DateTime)reader["ByData"]; Car.ByDept = dept.GetAllDepartementById((int)reader["ByDept"]); Car.ByMan = (string)reader["ByMan"]; Car.ByDttion = (string)reader["ByDttion"]; Car.ByReData = (DateTime)reader["ByReData"]; Car.ByTypeid = carType.GetAllCarsById((int)reader["ByTypeid"]); Car.State = (string)reader["State"]; return(Car); } else { reader.Close(); return(null); } } }
public Car_Byapply getBind(Car_Byapply byapply) { byapply.ByCause = txtByCause.Text.Trim(); byapply.ByData = DateTime.Parse(txtByData.Value.Trim()); byapply.ByDept.Departmentname = txtDept.Text.ToString(); byapply.ByDttion = txtByttion.Text.Trim(); byapply.ByMan = txtMan.Text.ToString(); byapply.ByReData = DateTime.Parse(txtReData.Value.Trim()); if (rdo1.Checked == true) { byapply.ByTypeid.TypeId = 1; } if (rdo2.Checked == true) { byapply.ByTypeid.TypeId = 2; } if (rdo3.Checked == true) { byapply.ByTypeid.TypeId = 3; } if (rdo4.Checked == true) { byapply.ByTypeid.TypeId = 4; } return(byapply); }
protected void btnShenPi_Click(object sender, EventArgs e) { Car_Byapply car = CarByapplyManager.GetAllCarsByappyById(Id); Response.Redirect("~/PedingMatter/Auditing.aspx?type=用车申请&id=" + Id.ToString()); }
/// <summary> /// 详细 /// </summary> /// <param name="id"></param> public void Bind(int id) { Car_Byapply car = CarByapplyManager.GetAllCarsByappyById(Id); txtByCause.Text = car.ByCause.ToString(); txtByData.Value = car.ByData.ToString(); txtByttion.Text = car.ByDttion.ToString(); txtDept.Text = car.ByDept.Departmentname.ToString(); txtMan.Text = car.ByMan.ToString(); txtReData.Value = car.ByReData.ToString(); if (car.ByTypeid.TypeId == 1) { rdo1.Checked = true; } else if (car.ByTypeid.TypeId == 2) { rdo2.Checked = true; } else if (car.ByTypeid.TypeId == 3) { rdo3.Checked = true; } else { rdo4.Checked = true; } }
public Car_Byapply getBind(Car_Byapply byapply) { byapply.ByCause = Server.HtmlDecode(txtByCause.Text); byapply.ByData = DateTime.Parse(txtByData.Text.Trim()); byapply.ByDept.Id = Convert.ToInt32(user.Department.Id); byapply.ByDttion = txtByttion.Text.Trim(); byapply.ByMan = txtMan.Text.ToString(); byapply.ByReData = DateTime.Parse(txtReData.Text.Trim()); if (rdo1.Checked == true) { byapply.ByTypeid.TypeId = 1; } if (rdo2.Checked == true) { byapply.ByTypeid.TypeId = 2; } if (rdo3.Checked == true) { byapply.ByTypeid.TypeId = 3; } if (rdo4.Checked == true) { byapply.ByTypeid.TypeId = 4; } return(byapply); }
/// <summary> /// 申请用车 /// </summary> /// <param name="byapply"></param> /// <returns></returns> public static int InsertByCar(Car_Byapply byapply) { try { return(carService.InsertByCar(byapply)); } catch (Exception ex) { throw new Exception(ex.ToString()); } }
/// <summary> /// 用车申请 /// </summary> /// <param name="byapply"></param> /// <returns></returns> public int InsertByCar(Car_Byapply byapply) { SqlParameter[] para = new SqlParameter[] { new SqlParameter("@ByData", byapply.ByData), new SqlParameter("@ByDept", byapply.ByDept.Id), new SqlParameter("@ByMan", byapply.ByMan), new SqlParameter("@ByTypeid", byapply.ByTypeid.TypeId), new SqlParameter("@ByCause", byapply.ByCause), new SqlParameter("@ByDttion", byapply.ByDttion), new SqlParameter("@ByreData", byapply.ByReData) }; int num = DBHelper.ExecuteNonQueryProc("usp_CarInsetBuyApply", para); return(num); }
/// <summary> /// 通用 /// </summary> /// <param name="reader"></param> /// <returns></returns> public List <Car_Byapply> GetCars(SqlDataReader reader) { List <Car_Byapply> list = new List <Car_Byapply>(); while (reader.Read()) { Car_Byapply Car = new Car_Byapply(); Car.ByapplyId = (int)reader["ByapplyId"]; Car.ByCause = (string)reader["ByCause"]; Car.ByData = (DateTime)reader["ByData"]; Car.ByDept = dept.GetAllDepartementById((int)reader["ByDept"]); Car.ByMan = (string)reader["ByMan"]; Car.ByDttion = (string)reader["ByDttion"]; Car.ByReData = (DateTime)reader["ByReData"]; Car.ByTypeid = carType.GetAllCarsById((int)reader["ByTypeid"]); Car.State = (string)reader["State"]; list.Add(Car); } return(list); }
public IList <Car_Byapply> GetAllCarByapply() { string cars = "up_CarSelectByApply"; DataTable tb = DBHelper.GetDataTableProc(cars, null); IList <Car_Byapply> list = new List <Car_Byapply>(); foreach (DataRow r in tb.Rows) { Car_Byapply Car = new Car_Byapply(); Car.ByapplyId = (int)r["ByapplyId"]; Car.ByCause = (string)r["ByCause"]; Car.ByData = (DateTime)r["ByData"]; Car.ByDept = dept.GetAllDepartementById((int)r["ByDept"]); Car.ByMan = (string)r["ByMan"]; Car.ByDttion = (string)r["ByDttion"]; Car.ByReData = (DateTime)r["ByReData"]; Car.ByTypeid = carType.GetAllCarsById((int)r["ByTypeid"]); Car.State = (string)r["State"]; list.Add(Car); } return(list); }
protected void btnSubmit_Click(object sender, EventArgs e) { Car_Byapply byapply = new Car_Byapply(); try { byapply = getBind(byapply); int num = CarByapplyManager.InsertByCar(byapply); if (num > 0) { Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('申请成功!,请等待审核!');window.location.href='shenlist.aspx';</script>"); } else { Page.ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('添加失败!');</script>"); } } catch (Exception) { Page.ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('添加失败!');</script>"); } }