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>");
}
}
