public DAO.CarM GetModel(string id) { string sql = "select * from CarM where id={0} "; DAO.CarM m = db.Database.SqlQuery <DAO.CarM>(string.Format(sql, id)).FirstOrDefault(); return(m); }
public ActionResult TypeListByCar(string t, string b, string m, string y) { string tid = HttpUtility.HtmlEncode(t); string bb = HttpUtility.HtmlEncode(b); string mm = HttpUtility.HtmlEncode(m); string yy = HttpUtility.HtmlEncode(y); Cparts_Service.CarBll carBll = new Cparts_Service.CarBll(); DAO.CarM carinfo = carBll.GetModel(bb, mm, yy); TypeListByCarViewModel vm = new TypeListByCarViewModel(); ProductBll proBll = new ProductBll(); if (carinfo != null) { vm.childenrCate = proBll.GetChildenCateListByType(t, carinfo.id.ToString()); } if (t == "-1") { CommonModule.CommonBll bll = new CommonModule.CommonBll(); vm.topCate = bll.GetList(); } vm.parentCate = proBll.GetParentCateListByType(t); vm.Carinfo = carinfo; return(View(vm)); }
public DAO.CarM GetModel(string brand, string model, string year) { string sql = "select * from CarM where Brand='{0}' and Model='{1}' and ProYear='{2}' "; DAO.CarM m = db.Database.SqlQuery <DAO.CarM>(string.Format(sql, brand, model, year)).FirstOrDefault(); return(m); }
/// <summary> /// 增加一条汽车记录 /// </summary> /// <param name="car">汽车实体</param> /// <returns></returns> public bool AddCar(DAO.CarM car) { db.CarM.Add(car); int i = db.SaveChanges(); if (i > 0) { return(true); } else { return(false); } }
public ActionResult List(string id, string b, string m, string y) { // string tid = HttpUtility.HtmlEncode(t); string bb = HttpUtility.HtmlEncode(b); string mm = HttpUtility.HtmlEncode(m); string yy = HttpUtility.HtmlEncode(y); string typeId = HttpUtility.HtmlEncode(id); string car = ""; if (!string.IsNullOrEmpty(b) && !string.IsNullOrEmpty(m) && !string.IsNullOrEmpty(y)) { Cparts_Service.CarBll carBll = new Cparts_Service.CarBll(); DAO.CarM carinfo = carBll.GetModel(bb, mm, yy); car = carinfo.id.ToString(); } ProductBll proList = new ProductBll(); ProductList list = proList.GetListByType(typeId, car, null); return(View(list)); }
/// <summary> /// 修改汽车 /// </summary> /// <param name="car"></param> /// <returns></returns> public bool updateCar(DAO.CarM car) { DAO.CarM c = db.CarM.Where(m => m.id == car.id).FirstOrDefault(); c.Model = car.Model; c.Oil = car.Oil; c.ProYear = car.ProYear; c.State = car.State; c.Brand = car.Brand; c.Engine = car.Engine; db.Entry(c).State = System.Data.EntityState.Modified; int result = db.SaveChanges(); if (result > 0) { return(true); } else { return(false); } }
public ActionResult cList(string t, string b, string m, string y, string h) { if (b == "0" && m == "0" && y == "0" && h != "0") { ProductBll proList = new ProductBll(); ProductList list = proList.GetListByType(t, null, h); return(View("~/Views/Product/pList.cshtml", list)); } string tid = HttpUtility.HtmlEncode(t); string bb = HttpUtility.HtmlEncode(b); string mm = HttpUtility.HtmlEncode(m); string yy = HttpUtility.HtmlEncode(y); Cparts_Service.CarBll carBll = new Cparts_Service.CarBll(); DAO.CarM carinfo = carBll.GetModel(bb, mm, yy); TypeListByCarViewModel vm = new TypeListByCarViewModel(); ProductBll proBll = new ProductBll(); if (carinfo != null) { vm.childenrCate = proBll.GetChildenCateListByType(t, carinfo.id.ToString()); } if (vm.childenrCate.Count > 0) { CommonModule.CommonBll bll = new CommonModule.CommonBll(); vm.topCate = bll.GetList(); vm.parentCate = proBll.GetParentCateListByType(t); vm.Carinfo = carinfo; return(View(vm)); } else { ProductBll proList = new ProductBll(); ProductList list = proList.GetListByType(t, carinfo.id.ToString(), null); return(View("~/Views/Product/pList.cshtml", list)); } }