protected void btnUpdate_Click(object sender, EventArgs e) { if (this.FormCheck()) { try { TB_CarOilMaintenance carModel = new TB_CarOilMaintenance(); carModel.CardNo = ddlCarNo.Text; carModel.CreateTime = DateTime.Now; carModel.CreateUser = Convert.ToInt32(Session["currentUserId"]); carModel.MaintenanceTime = Convert.ToDateTime(txtMaintenanceTime.Text); carModel.Remark = txtRemark.Text; if (txtChongZhiTime.Text != "") { carModel.ChongZhiDate = Convert.ToDateTime(txtChongZhiTime.Text); } if (txtOilTotal.Text != "") { carModel.OilTotal = Convert.ToDecimal(txtOilTotal.Text); } if (txtAddTotal.Text != "") { carModel.AddTotal = Convert.ToDecimal(txtAddTotal.Text); } if (txtTotal.Text != "") { carModel.Total = Convert.ToDecimal(txtTotal.Text); } if (txtUpTotal.Text != "") { carModel.UpTotal = Convert.ToDecimal(txtUpTotal.Text); } carModel.Id = Convert.ToInt32(base.Request["Id"]); if (this.carMaintenanceSer.Update(carModel)) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('修改成功!');</script>"); } else { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('修改失败!');</script>"); } } catch (Exception ex) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('" + ex.Message + "!');</script>"); } } }
protected void Page_Load(object sender, EventArgs e) { if (!base.IsPostBack) { DataTable carInfos = DBHelp.getDataTable("select ''as CarNO union select CarNO from TB_CarInfo where IsStop=0"); ddlCarNo.DataSource = carInfos; ddlCarNo.DataBind(); ddlCarNo.Text = ""; if (base.Request["Id"] != null) { this.btnAdd.Visible = false; TB_CarOilMaintenance CarMaiModel = this.carMaintenanceSer.GetModel(Convert.ToInt32(base.Request["Id"])); ddlCarNo.Text = CarMaiModel.CardNo; txtMaintenanceTime.Text = CarMaiModel.MaintenanceTime.ToString(); txtRemark.Text = CarMaiModel.Remark; if (CarMaiModel.ChongZhiDate != null) { txtChongZhiTime.Text = CarMaiModel.ChongZhiDate.ToString(); } if (CarMaiModel.Total != null) { txtTotal.Text = CarMaiModel.Total.ToString(); } if (CarMaiModel.UpTotal != null) { txtUpTotal.Text = CarMaiModel.UpTotal.ToString(); } if (CarMaiModel.AddTotal != null) { txtAddTotal.Text = CarMaiModel.AddTotal.ToString(); } if (CarMaiModel.OilTotal != null) { txtOilTotal.Text = CarMaiModel.OilTotal.ToString(); } //ddlCarNo.Enabled = false; //判断是否是最后一次填写的信息 //object obj = DBHelp.ExeScalar(string.Format("select max(MaintenanceTime) from TB_CarOilMaintenance where CardNo='{0}' and UseState='加油'", ddlCarNo.Text)); //if (obj != null) //{ //} //txtAddTotal.Enabled = false; //txtOilTotal.Enabled = false; //txtTotal.Enabled = false; //txtUpTotal.Enabled = false; //txtMaintenanceTime.Enabled = false; //txtRemark.Enabled = false; //txtChongZhiTime.Enabled = false; //this.btnUpdate.Visible = false; if (Request["Type"] != null) { this.btnUpdate.Visible = true; } } else { this.btnUpdate.Visible = false; } } }