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