protected void btnSave_Click(object sender, EventArgs e)
{
AdminBusBiz biz = new AdminBusBiz();
D_BusInfo bi = this.BusInfo;
if (bi.vehicleId < 0)
{
bi.vehicleId = biz.Add();
}
if (biz.Update(bi))
{
txtToolMessage.Text = "����ɹ���";
txtToolMessage.ForeColor = System.Drawing.Color.DarkGreen;
this.BusInfo = bi;
}
else
{
txtToolMessage.Text = "����ʧ�ܣ����顣";
txtToolMessage.ForeColor = System.Drawing.Color.Red;
}
}
public D_BusInfo GetVehicleDetail(int vehicleId)
{
string SQL = "SELECT * FROM vehicles WHERE vehicleId=@vehicleId";
SqlParameter[] para = { new SqlParameter("@vehicleId", vehicleId) };
IDataReader dr = m_dao.ExecuteReader(SQL, para);
D_BusInfo bi = new D_BusInfo();
if (dr.Read())
{
bi.vehicleId = (int)dr["vehicleId"];
bi.vehicleName = (string)dr["vehicleName"];
bi.vehicleType = (byte)dr["vehicleType"];
bi.customerSeatNum = (int)dr["customerSeatNum"];
bi.plateNumber = (string)dr["plateNumber"];
bi.vinNumber = (string)dr["vinNumber"];
bi.inspectionDate = (DateTime)dr["inspectionDate"];
bi.status = (byte)dr["status"];
bi.notes = (string)dr["notes"];
bi.own = (byte)dr["own"];
}
return bi;
}
public bool Update(D_BusInfo businfo)
{
string sql = @"
update vehicles
set
vehicleName=@vehicleName, vehicleType=@vehicleType,
customerSeatNum=@customerSeatNum, plateNumber=@plateNumber, vinNumber=@vinNumber,
inspectionDate=@inspectionDate, notes=@notes,
status=@status, own=@own
where vehicleId=@vehicleId
";
SqlParameter[] para = {
new SqlParameter("@vehicleId", businfo.vehicleId),
new SqlParameter("@vehicleName", businfo.vehicleName),
new SqlParameter("@vehicleType", businfo.vehicleType),
new SqlParameter("@customerSeatNum", businfo.customerSeatNum),
new SqlParameter("@plateNumber", businfo.plateNumber),
new SqlParameter("@vinNumber", businfo.vinNumber),
new SqlParameter("@inspectionDate", businfo.inspectionDate),
new SqlParameter("@status", businfo.status),
new SqlParameter("@notes", businfo.notes),
new SqlParameter("@own", businfo.own)
};
int i = m_dao.ExecuteNoQuery(sql, para);
return (i==1);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["id"] == null)
Response.Redirect("BusList.aspx");
if (!Page.IsPostBack)
{
int vehicleId = int.Parse(Request.QueryString["id"]);
AdminBusBiz biz = new AdminBusBiz();
this.BusInfo = biz.GetVehicleDetail(vehicleId);
}
}
