protected void gvUserInfo_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "del")
{
string Id = e.CommandArgument.ToString();
try
{
Car_UserInfo cars = CarUserInfoManager.GetAllCarsById(Convert.ToInt32(Id));
if (cars.State == "已出车" || cars.State == "维修中")
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('此车不是未出车状态不可删除！');", true);
}
else
{
int num = CarUserInfoManager.DeleteDriver(Id);
if (num > 0)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('删除成功！');", true);
}
gvUserInfo.DataSourceID = null;
gvUserInfo.DataSource = odsUserInfo;
gvUserInfo.DataBind();
}
}
catch
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('删除失败！');", true);
return;
}
}
}
/// <summary>
///添加驾驶员信息
/// </summary>
/// <param name="userinfo"></param>
/// <returns></returns>
public static int AddDavte(Car_UserInfo userinfo)
{
try
{
return(carService.AddDavte(userinfo));
}
catch (Exception ex)
{
throw new Exception(ex.ToString());
}
}
public IList <Car_UserInfo> usp_CarUserNameState(string State)
{
string proName = "usp_CarUserNameState";
DataTable tb = DBHelper.GetDataTableProc(proName, new SqlParameter("@State", State));
IList <Car_UserInfo> list = new List <Car_UserInfo>();
foreach (DataRow r in tb.Rows)
{
Car_UserInfo car = new Car_UserInfo();
car.UserName = (string)r["UserName"];
list.Add(car);
}
return(list);
}
/// <summary>
/// 添加驾驶员
/// </summary>
/// <param name="dav"></param>
/// <returns></returns>
public int AddDavte(Car_UserInfo userinfo)
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@UserName", userinfo.UserName),
new SqlParameter("@Age", userinfo.Age),
new SqlParameter("@Sex", userinfo.Sex),
new SqlParameter("@Address", userinfo.Address),
new SqlParameter("@phone", userinfo.Phone),
new SqlParameter("@state", userinfo.State)
};
int num = DBHelper.ExecuteNonQueryProc("usp_CasAddUserInfo", para);
return(num);
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
Car_UserInfo davnote = new Car_UserInfo();
davnote = getdavs(ref davnote);
int num = CarUserInfoManager.AddDavte(davnote);
if (num > 0)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('添加成功！');window.location.href='driverInfo.aspx';</script>");
}
else
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('添加失败！');", true);
return;
}
}
public IList <Car_UserInfo> GetAllUserInfo()
{
string cars = "usp_CarSelectUserInfo";
DataTable tb = DBHelper.GetDataTableProc(cars, null);
IList <Car_UserInfo> list = new List <Car_UserInfo>();
foreach (DataRow reader in tb.Rows)
{
Car_UserInfo userInfo = new Car_UserInfo();
userInfo.UserId = (int)reader["UserId"];
userInfo.UserName = (string)reader["UserName"];
userInfo.Address = (string)reader["Address"];
userInfo.Age = (int)reader["Age"];
userInfo.Phone = (string)reader["Phone"];
userInfo.Sex = (string)reader["Sex"];
userInfo.State = (string)reader["State"];
list.Add(userInfo);
}
return(list);
}
public Car_UserInfo getdavs(ref Car_UserInfo dav)
{
dav.Address = txtAddRess.Text.ToString();
dav.Age = Convert.ToInt32(txtAge.Text.Trim());
dav.Phone = txtPhone.Text.ToString();
dav.State = txtState.Text.ToString();
dav.UserName = txtName.Text.ToString();
if (rdoMan.Checked)
{
dav.Sex = "男";
}
if (rdoGril.Checked)
{
dav.Sex = "女";
}
return(dav);
}
/// <summary>
/// 根据姓名查看驾驶员
/// </summary>
/// <param name="userName"></param>
/// <returns></returns>
public IList <Car_UserInfo> SelectCarsDark(string userName)
{
string proName = "usp_CarSelectName";
DataTable tb = DBHelper.GetDataTableProc(proName, new SqlParameter("@UserName", userName));
IList <Car_UserInfo> list = new List <Car_UserInfo>();
foreach (DataRow r in tb.Rows)
{
Car_UserInfo car = new Car_UserInfo();
car.UserName = (string)r["UserName"];
car.State = (string)r["State"];
car.Address = (string)r["Address"];
car.Age = (int)r["Age"];
car.Phone = (string)r["Phone"];
car.Sex = (string)r["Sex"];
car.UserId = (int)r["UserId"];
list.Add(car);
}
return(list);
}
/// <summary>
/// 根据ID查看所有驾驶员
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public Car_UserInfo GetAllCarsById(int Id)
{
string sql = "usp_CarSelectUserInfoById";
using (SqlDataReader reader = DBHelper.ExecuteReaderProc(sql, new SqlParameter("@UserId", Id)))
{
if (reader.Read())
{
Car_UserInfo userIfo = new Car_UserInfo();
userIfo.UserId = (int)reader["UserId"];
userIfo.Address = (string)reader["Address"];
userIfo.Age = (int)reader["Age"];
userIfo.Phone = (string)reader["Phone"];
userIfo.Sex = (string)reader["Sex"];
userIfo.State = (string)reader["State"];
return(userIfo);
}
else
{
reader.Close();
return(null);
}
}
}
