/// <summary> /// 更新一条数据 /// </summary> public bool Update(CarSpirits.Model.OwnCar model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update OwnCar set "); strSql.Append("CustomerID=@CustomerID,"); strSql.Append("PlateNumber=@PlateNumber,"); strSql.Append("GasOline=@GasOline,"); strSql.Append("Brand=@Brand,"); strSql.Append("Style=@Style,"); strSql.Append("Color=@Color,"); strSql.Append("OilMass=@OilMass,"); strSql.Append("Mileage=@Mileage,"); strSql.Append("CarBreakDown=@CarBreakDown"); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@CustomerID", SqlDbType.NVarChar, 50), new SqlParameter("@PlateNumber", SqlDbType.NVarChar, 20), new SqlParameter("@GasOline", SqlDbType.NVarChar, 20), new SqlParameter("@Brand", SqlDbType.NVarChar, 50), new SqlParameter("@Style", SqlDbType.NVarChar, 50), new SqlParameter("@Color", SqlDbType.NVarChar, 20), new SqlParameter("@OilMass", SqlDbType.NVarChar, 50), new SqlParameter("@Mileage", SqlDbType.NVarChar, 50), new SqlParameter("@CarBreakDown", SqlDbType.NVarChar, 50), new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = model.CustomerID; parameters[1].Value = model.PlateNumber; parameters[2].Value = model.GasOline; parameters[3].Value = model.Brand; parameters[4].Value = model.Style; parameters[5].Value = model.Color; parameters[6].Value = model.OilMass; parameters[7].Value = model.Mileage; parameters[8].Value = model.CarBreakDown; parameters[9].Value = model.ID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public CarSpirits.Model.OwnCar DataRowToModel(DataRow row) { CarSpirits.Model.OwnCar model = new CarSpirits.Model.OwnCar(); if (row != null) { if (row["ID"] != null && row["ID"].ToString() != "") { model.ID = int.Parse(row["ID"].ToString()); } if (row["CustomerID"] != null) { model.CustomerID = row["CustomerID"].ToString(); } if (row["PlateNumber"] != null) { model.PlateNumber = row["PlateNumber"].ToString(); } if (row["GasOline"] != null) { model.GasOline = row["GasOline"].ToString(); } if (row["Brand"] != null) { model.Brand = row["Brand"].ToString(); } if (row["Style"] != null) { model.Style = row["Style"].ToString(); } if (row["Color"] != null) { model.Color = row["Color"].ToString(); } if (row["OilMass"] != null) { model.OilMass = row["OilMass"].ToString(); } if (row["Mileage"] != null) { model.Mileage = row["Mileage"].ToString(); } if (row["CarBreakDown"] != null) { model.CarBreakDown = row["CarBreakDown"].ToString(); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(CarSpirits.Model.OwnCar model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into OwnCar("); strSql.Append("CustomerID,PlateNumber,GasOline,Brand,Style,Color,OilMass,Mileage,CarBreakDown)"); strSql.Append(" values ("); strSql.Append("@CustomerID,@PlateNumber,@GasOline,@Brand,@Style,@Color,@OilMass,@Mileage,@CarBreakDown)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@CustomerID", SqlDbType.NVarChar, 50), new SqlParameter("@PlateNumber", SqlDbType.NVarChar, 20), new SqlParameter("@GasOline", SqlDbType.NVarChar, 20), new SqlParameter("@Brand", SqlDbType.NVarChar, 50), new SqlParameter("@Style", SqlDbType.NVarChar, 50), new SqlParameter("@Color", SqlDbType.NVarChar, 20), new SqlParameter("@OilMass", SqlDbType.NVarChar, 50), new SqlParameter("@Mileage", SqlDbType.NVarChar, 50), new SqlParameter("@CarBreakDown", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.CustomerID; parameters[1].Value = model.PlateNumber; parameters[2].Value = model.GasOline; parameters[3].Value = model.Brand; parameters[4].Value = model.Style; parameters[5].Value = model.Color; parameters[6].Value = model.OilMass; parameters[7].Value = model.Mileage; parameters[8].Value = model.CarBreakDown; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 取得数据 /// </summary> /// <param name="id"></param> /// <returns></returns> private CarSpirits.Model.OwnCar GetData(int id) { CarSpirits.Model.OwnCar model = new CarSpirits.Model.OwnCar(); if (id > 0) { model = bll.GetModel(id); } else { } model.PlateNumber = Request.Form["ipt_platenumber"] != "" ? Request.Form["ipt_platenumber"] : ""; model.GasOline = Request.Form["ipt_gasoline"] != "" ? Request.Form["ipt_gasoline"] : ""; model.Brand = Request.Form["ipt_brand"] != "" ? Request.Form["ipt_brand"] : ""; model.Style = Request.Form["ipt_style"] != "" ? Request.Form["ipt_style"] : ""; model.Color = Request.Form["ipt_color"] != "" ? Request.Form["ipt_color"] : ""; model.OilMass = Request.Form["ipt_oilmass"] != "" ? Request.Form["ipt_oilmass"] : ""; model.Mileage = Request.Form["ipt_mileage"] != "" ? Request.Form["ipt_mileage"] : ""; model.CarBreakDown = Request.Form["ipt_carbreakdown"] != "" ? Request.Form["ipt_carbreakdown"] : ""; return(model); }
public CarSpirits.Model.OwnCar GetModel(string PlateNumber) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,CustomerID,PlateNumber,GasOline,Brand,Style,Color,OilMass,Mileage,CarBreakDown from OwnCar "); strSql.Append(" where PlateNumber=@PlateNumber"); SqlParameter[] parameters = { new SqlParameter("@PlateNumber", SqlDbType.NVarChar, 20) }; parameters[0].Value = PlateNumber; CarSpirits.Model.OwnCar model = new CarSpirits.Model.OwnCar(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 添加或修改数据 /// </summary> private void UpdateData() { int id = Request.Form["id"] != "" ? Convert.ToInt32(Request.Form["id"]) : 0; CarSpirits.Model.OwnCar model = GetData(id); string writeMsg = "操作失败!"; if (model != null) { if (id < 1) { if (bll.Add(model) > 0) { writeMsg = "增加成功!"; } else { writeMsg = "增加失败!"; } } else { if (bll.Update(model)) { writeMsg = "更新成功!"; } else { writeMsg = "更新失败!"; } } } Response.Clear(); Response.Write(writeMsg); Response.End(); }
private void update(HttpContext context) { model = bll.GetModel(int.Parse(context.Request["ID"].ToString())); if (context.Request["PlateNumber"].ToString() != null) // 修改后的车牌号 { model.PlateNumber = context.Request["PlateNumber"].ToString(); } if (context.Request["GasOline"].ToString() != null) { StringBuilder gasoline = new StringBuilder(); gasoline.Append(context.Request["GasOline"].ToString()); gasoline.Append("#"); model.GasOline = gasoline.ToString(); } if (context.Request["Brand"].ToString() != null) { model.Brand = context.Request["Brand"].ToString(); } if (context.Request["Style"].ToString() != null) { model.Style = context.Request["Style"].ToString(); } if (context.Request["Color"].ToString() != null) { model.Color = context.Request["Color"].ToString(); } if (bll.Update(model)) { context.Response.Write("{\"Result\":\"1\"}"); } else { context.Response.Write("{\"Result\":\"0\"}"); } }