public List <Car_Enter> GetDavnote(SqlDataReader reader) { List <Car_Enter> list = new List <Car_Enter>(); while (reader.Read()) { Car_Enter dav = new Car_Enter(); dav.Course = Decimal.Parse(reader["Course"].ToString()); dav.EnterData = DateTime.Parse(reader["EnterData"].ToString()); dav.Dept = dept.GetAllDepartementById((int)reader["Dept"]); dav.Dirver = reader["Driver"].ToString(); dav.Man = reader["Man"].ToString(); dav.Mark = reader["Mark"].ToString(); dav.Place = reader["Place"].ToString(); dav.ReturnData = DateTime.Parse(reader["ReturnData"].ToString()); dav.Remark = reader["Remark"].ToString(); dav.Ttion = reader["Ttion"].ToString(); dav.Typeid = carType.GetAllCarsById((int)reader["Typeid"]); dav.HuiCheLiCheng = Decimal.Parse(reader["HuiCheLiCheng"].ToString());; dav.ShiJiReturnDatd = DateTime.Parse(reader["ShiJiReturnDatd"].ToString()); dav.EnterId = Convert.ToInt32(reader["EnterId"].ToString()); list.Add(dav); } return(list); }
public Car_Enter getdavs(ref Car_Enter dav) { dav.Dept.Id = Convert.ToInt32(ddlDepartment.SelectedValue); dav.Ttion = txtDirection.Text.ToString(); dav.Dirver = txtDriver.Text.ToString(); dav.Course = Decimal.Parse(txtLiCheng.Text.ToString()); dav.Man = txtMan.Text.ToString(); dav.Mark = txtMark.Text.ToString(); dav.EnterData = DateTime.Parse(txtOutDate.Value.ToString()); dav.Remark = txtReMark.Text.ToString(); dav.ReturnData = DateTime.Parse(txtReturnDate.Value.ToString()); dav.Place = txtStartAddr.Text.ToString(); dav.ShiJiReturnDatd = DateTime.Parse(txtShiJireturnDate.Text.ToString()); dav.HuiCheLiCheng = Decimal.Parse(txtHuiCheLiCheng.Text.ToString()); if (rdo1.Checked) { dav.Typeid.TypeId = 1; } if (rdo2.Checked) { dav.Typeid.TypeId = 2; } if (rdo3.Checked) { dav.Typeid.TypeId = 3; } if (rdo4.Checked) { dav.Typeid.TypeId = 4; } return(dav); }
/// <summary> /// 回车登记 /// </summary> /// <param name="dav"></param> /// <returns></returns> public static int AddEnter(Car_Enter dav) { try { return(carService.AddEnter(dav)); } catch (Exception ex) { throw new Exception(ex.ToString()); } }
protected void btnHuiChe_Click1(object sender, EventArgs e) { Car_Enter davnote = new Car_Enter(); davnote = getdavs(ref davnote); int num = CarEnterManager.AddEnter(davnote); if (num > 0) { Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('回车成功!');window.location.href='Davnotelist.aspx';</script>"); } else { Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('回车失败!');", true); } }
public int AddEnter(Car_Enter dav) { SqlParameter[] para = new SqlParameter[] { new SqlParameter("@EnterData", dav.EnterData), new SqlParameter("@Dept", dav.Dept.Id), new SqlParameter("@Man", dav.Man), new SqlParameter("@Typeid", dav.Typeid.TypeId), new SqlParameter("@Mark", dav.Mark), new SqlParameter("@Driver", dav.Dirver), new SqlParameter("@Place", dav.Place), new SqlParameter("@Couse", dav.Course), new SqlParameter("@ttion", dav.Ttion), new SqlParameter("@Remark", dav.Remark), new SqlParameter("@ReturnData", dav.ReturnData), new SqlParameter("@ShiJiReturnDatd", dav.ShiJiReturnDatd), new SqlParameter("@HuiCheLiCheng", dav.HuiCheLiCheng) }; int num = DBHelper.ExecuteNonQueryProc("usp_CarRetuanDate", para); return(num); }