public Car_Davnote getdavs(ref Car_Davnote dav)
{
dav.DavDept.Id = Convert.ToInt32(drpDept.SelectedValue.ToString());
dav.DavTtion = txtDirection.Text.ToString();
dav.DavDriver = drpDriver.SelectedItem.Text;
dav.DavCourse = Decimal.Parse(txtLiCheng.Text.ToString());
dav.DavMan = drpMan.SelectedItem.Text;
dav.DavMark = dllMark.SelectedItem.Text;
dav.DavData = DateTime.Parse(txtOutData.Text.ToString());
dav.DavRemark = txtReMark.Text.ToString();
dav.DavReturnData = DateTime.Parse(txtReturnDate.Text.ToString());
dav.DavPlace = txtStartAddr.Text.ToString();
if (rdo1.Checked)
{
dav.DavTypeId.TypeId = 1;
}
if (rdo2.Checked)
{
dav.DavTypeId.TypeId = 2;
}
if (rdo3.Checked)
{
dav.DavTypeId.TypeId = 3;
}
if (rdo4.Checked)
{
dav.DavTypeId.TypeId = 4;
}
return(dav);
}
/// <summary>
/// 通用
/// </summary>
/// <param name="reader"></param>
/// <returns></returns>
public List <Car_Davnote> GetDavnote(SqlDataReader reader)
{
List <Car_Davnote> list = new List <Car_Davnote>();
while (reader.Read())
{
Car_Davnote dav = new Car_Davnote();
dav.DavCourse = Decimal.Parse(reader["DavCourse"].ToString());
dav.DavData = DateTime.Parse(reader["DavData"].ToString());
dav.DavDept = dept.GetAllDepartementById((int)reader["DavDept"]);
dav.DavDriver = reader["DavDriver"].ToString();
dav.DavMan = reader["DavMan"].ToString();
dav.DavMark = reader["DavMark"].ToString();
dav.DavPlace = reader["DavPlace"].ToString();
dav.DavReturnData = DateTime.Parse(reader["DavReturnData"].ToString());
dav.DavRemark = reader["DavRemark"].ToString();
dav.DavTtion = reader["Davttion"].ToString();
dav.DavTypeId = carType.GetAllCarsById((int)reader["DavTypeId"]);
dav.DavnoteId = Convert.ToInt32(reader["DavnoteId"].ToString());
list.Add(dav);
}
return(list);
}
/// <summary>
/// 详细
/// </summary>
/// <param name="id"></param>
public void Bind(int id)
{
Car_Davnote dav = CarDavnoteManager.SelectDavnoteById(Id);
txtDept.Text = dav.DavDept.Departmentname.ToString();
txtDirection.Text = dav.DavTtion.ToString();
txtLiCheng.Text = dav.DavCourse.ToString();
txtMan.Text = dav.DavMan.Trim().ToString();
txtDriver.Text = dav.DavDriver.Trim().ToString();
txtMark.Text = dav.DavMark.ToString();
txtOutDate.Text = dav.DavData.ToString();
txtReMark.Text = dav.DavRemark.ToString();
txtReturnDate.Text = dav.DavReturnData.ToString();
txtStartAddr.Text = dav.DavPlace.ToString();
if (dav.DavTypeId.TypeId == 1)
{
rdo1.Checked = true;
}
else if (dav.DavTypeId.TypeId == 2)
{
rdo2.Checked = true;
}
else if (dav.DavTypeId.TypeId == 3)
{
rdo3.Checked = true;
}
else
{
rdo4.Checked = true;
}
}
public Car_Davnote getdavs(ref Car_Davnote dav)
{
//dav.DavDept.DepartmentName = drpDept.SelectedItem.Text;
//dav.DavTtion = txtDirection.Text.ToString();
////dav.DavDriver = drpDriver.SelectedItem.Text;
//dav.DavCourse = Decimal.Parse(txtLiCheng.Text.ToString());
//dav.DavMan = drpMan.SelectedItem.Text;
//dav.DavMark = txtMark.Text.ToString();
//dav.DavData = DateTime.Parse(txtOutDate.Value.ToString());
//dav.DavRemark = txtReMark.Text.ToString();
//dav.DavReturnData = DateTime.Parse(txtReturnDate.Value.ToString());
//dav.DavPlace = txtStartAddr.Text.ToString();
//if (rdo1.Checked)
//{
// dav.DavTypeId.TypeId = 1;
//}
//if (rdo2.Checked)
//{
// dav.DavTypeId.TypeId = 2;
//}
//if (rdo3.Checked)
//{
// dav.DavTypeId.TypeId = 3;
//}
//if (rdo4.Checked)
//{
// dav.DavTypeId.TypeId = 4;
//}
//return dav;
return(null);
}
/// <summary>
/// 修改出车记录
/// </summary>
/// <param name="dav"></param>
/// <returns></returns>
public static int UpdateDavte(Car_Davnote dav)
{
try
{
return(carService.UpdateDavte(dav));
}
catch (Exception ex)
{
throw new Exception(ex.ToString());
}
}
/// <summary>
/// 根据查看详细信息
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public Car_Davnote SelectDavnoteById(int Id)
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@DavnoteId", Id)
};
SqlDataReader reader = (SqlDataReader)DBHelper.ExecuteReaderProc("usp_SelectDavnoteById", para);
List <Car_Davnote> list = GetDavnote(reader);
Car_Davnote dav = list[0];
return(dav);
}
/// <summary>
/// 添加
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSubmit_Click(object sender, EventArgs e)
{
Car_Davnote davnote = new Car_Davnote();
davnote = getdavs(ref davnote);
int num = CarDavnoteManager.AddDavte(davnote);
if (num > 0)
{
Page.ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('保存成功！');window.location.href=Davnotelist.aspx';</script>");
}
else
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('添加失败！');", true);
}
}
/// <summary>
/// 添加一条出车信息
/// </summary>
/// <param name="dav"></param>
/// <returns></returns>
public int AddDavte(Car_Davnote dav)
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@DavData", dav.DavData),
new SqlParameter("@DavDept", dav.DavDept.Id),
new SqlParameter("@DavMan", dav.DavMan),
new SqlParameter("@DavTypeid", dav.DavTypeId.TypeId),
new SqlParameter("@DavMark", dav.DavMark),
new SqlParameter("@DavDriver", dav.DavDriver),
new SqlParameter("@DavPlace", dav.DavPlace),
new SqlParameter("@DavCouse", dav.DavCourse),
new SqlParameter("@Davttion", dav.DavTtion),
new SqlParameter("@DavreData", dav.DavReturnData),
new SqlParameter("@DavRemark", dav.DavRemark)
};
int num = DBHelper.ExecuteNonQueryProc("usp_AddCarDavnote", para);
return(num);
}
public void Bind(int id)
{
Car_Davnote dav = CarDavnoteManager.SelectDavnoteById(Id);
ddlDepartment.DataSourceID = null;
ddlDepartment.DataSource = DepartmentManager.GetAllDepartment();
ddlDepartment.DataTextField = "departmentName";
ddlDepartment.DataValueField = "Id";
ddlDepartment.DataBind();
ddlDepartment.SelectedValue = dav.DavDept.Id.ToString();
txtDirection.Text = dav.DavTtion.ToString();
txtLiCheng.Text = dav.DavCourse.ToString();
txtMan.Text = dav.DavMan.Trim().ToString();
txtDriver.Text = dav.DavDriver.Trim().ToString();
txtMark.Text = dav.DavMark.ToString();
txtOutDate.Value = dav.DavData.ToString();
txtReMark.Text = dav.DavRemark.ToString();
txtReturnDate.Value = dav.DavReturnData.ToString();
txtStartAddr.Text = dav.DavPlace.ToString();
if (dav.DavTypeId.TypeId == 1)
{
rdo1.Checked = true;
}
else if (dav.DavTypeId.TypeId == 2)
{
rdo2.Checked = true;
}
else if (dav.DavTypeId.TypeId == 3)
{
rdo3.Checked = true;
}
else
{
rdo4.Checked = true;
}
}
