/// <summary> /// 获取实体对象 /// </summary> /// <param name="PKID">PKID</param> /// <returns>返回值</returns> public Common.Entity.CarInfo GetCarInfoByPKID(int PKID) { string sql = string.Format(@"select * from CarInfo where PKID=@PKID"); SqlParameter[] param = { new SqlParameter("@PKID", PKID) }; try { Common.Entity.CarInfo model = new Common.Entity.CarInfo(); DataTable dt = SqlHelper.GetDateTable(SqlHelper.connStr, CommandType.Text, sql, param); if (dt.Rows.Count > 0) { model.PKID = Convert.ToInt32(dt.Rows[0]["PKID"]); model.Name = dt.Rows[0]["Name"].ToString(); model.CarModel = dt.Rows[0]["CarModel"].ToString(); model.GearboxVersion = dt.Rows[0]["GearboxVersion"].ToString(); model.Spec = dt.Rows[0]["Spec"].ToString(); model.Model = dt.Rows[0]["Model"].ToString(); model.Other = dt.Rows[0]["Other"].ToString(); model.SFX = dt.Rows[0]["SFX"].ToString(); model.SuggestPrice = double.Parse(dt.Rows[0]["SuggestPrice"].ToString()); model.CarLogoID = Convert.ToInt32(dt.Rows[0]["CarLogoID"].ToString()); model.BrandID = Convert.ToInt32(dt.Rows[0]["BrandID"].ToString()); model.TypeID = Convert.ToInt32(dt.Rows[0]["TypeID"]); model.Remark = dt.Rows[0]["Remark"].ToString(); } return(model); } catch (Exception ex) { throw ex; } }
/// <summary> /// 获取车辆信息分页列表 /// </summary> /// <param name="context">上下文对象</param> public void GetCarsManagePager(HttpContext context) { int pageIndex = Convert.ToInt32(context.Request["page"]); // 当前页码 int pageSize = Convert.ToInt32(context.Request["rows"]); // 页码大小 int totalCount = 0; var orderName = context.Request["sort"]; // 排序字段 var orderBy = context.Request["sortOrder"]; // 排序规则 var sort = sortInfo.GetSortOrder(orderName, orderBy); List <Common.Entity.CarInfo> list = new List <Common.Entity.CarInfo>(); string sfx = context.Request.Form["SFX"]; string name = context.Request.Form["Name"]; Common.Entity.CarInfo filter = new Common.Entity.CarInfo { SFX = sfx, Name = name, }; if (sort.SortName != null && !string.IsNullOrEmpty(sort.IsDesc)) { list = new BLL.CarInfo().GetCarsManagePager(pageIndex, pageSize, sort.SortName, sort.IsDesc, filter, out totalCount); } else { list = new BLL.CarInfo().GetCarsManagePager(pageIndex, pageSize, filter, out totalCount); } var models = new BLL.BoostrapTableInfo <Common.Entity.CarInfo> { total = totalCount, rows = list }; string resultJson = JsonConvert.SerializeObject(models); context.Response.Write(resultJson); }
/// <summary> /// 新增一条记录 /// </summary> /// <param name="model">实体对象</param> /// <returns>返回值</returns> public int Add(Common.Entity.CarInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append(@"Insert into CarInfo(Name,CarModel,GearboxVersion, Spec,Model,SFX,Code,TypeID,BuiltInColor,Drive, SuggestPrice,FactoryPrice,InternetPrice,Remark,BrandID,Other,CarLogoID) Values (@Name,@CarModel,@GearboxVersion,@Spec,@Model,@SFX,@Code, @TypeID,@BuiltInColor,@Drive,@SuggestPrice,@FactoryPrice,@InternetPrice, @Remark,@BrandID,@Other,@CarLogoID)"); strSql.Append(";SELECT @@IDENTITY");// 返回插入用户的主键 SqlParameter[] param = { new SqlParameter("@Name", model.Name), new SqlParameter("@CarModel", model.CarModel), new SqlParameter("@GearboxVersion", model.GearboxVersion), new SqlParameter("@Spec", model.Spec), new SqlParameter("@Model", model.Model), new SqlParameter("@SFX", model.SFX), new SqlParameter("@Code", model.Code), new SqlParameter("@TypeID", model.TypeID), new SqlParameter("@BuiltInColor", model.BuiltInColor), new SqlParameter("@Drive", model.Drive), new SqlParameter("@SuggestPrice", model.SuggestPrice), new SqlParameter("@FactoryPrice", model.FactoryPrice), new SqlParameter("@InternetPrice", model.InternetPrice), new SqlParameter("@Remark", model.Remark), new SqlParameter("@BrandID", model.BrandID), new SqlParameter("@Other", model.Other), new SqlParameter("@CarLogoID", model.CarLogoID), }; try { return(SqlHelper.ExecuteNonQuery(SqlHelper.connStr, CommandType.Text, strSql.ToString(), param)); } catch (Exception ex) { throw ex; } }
/// <summary> /// 修改一条记录 /// </summary> /// <param name="model">实体对象</param> /// <returns>返回值</returns> public int Update(Common.Entity.CarInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append(@"Update CarInfo set Name=@Name,CarModel=@CarModel,GearboxVersion=@GearboxVersion,Spec=@Spec,Model=@Model, SFX=@SFX,Code=@Code,TypeID=@TypeID,BuiltInColor=@BuiltInColor, Drive=@Drive,SuggestPrice=@SuggestPrice,FactoryPrice=@FactoryPrice,InternetPrice=@InternetPrice, Remark=@Remark,BrandID=@BrandID,Other=@Other,CarLogoID=@CarLogoID where PKID=@PKID"); SqlParameter[] param = { new SqlParameter("@Name", model.Name), new SqlParameter("@CarModel", model.CarModel), new SqlParameter("@GearboxVersion", model.GearboxVersion), new SqlParameter("@Spec", model.Spec), new SqlParameter("@Model", model.Model), new SqlParameter("@SFX", model.SFX), new SqlParameter("@Code", model.Code), new SqlParameter("@TypeID", model.TypeID), new SqlParameter("@BuiltInColor", model.BuiltInColor), new SqlParameter("@Drive", model.Drive), new SqlParameter("@SuggestPrice", model.SuggestPrice), new SqlParameter("@FactoryPrice", model.FactoryPrice), new SqlParameter("@InternetPrice", model.InternetPrice), new SqlParameter("@Remark", model.Remark), new SqlParameter("@BrandID", model.BrandID), new SqlParameter("@Other", model.Other), new SqlParameter("@CarLogoID", model.CarLogoID), new SqlParameter("@PKID", model.PKID) }; try { return(Convert.ToInt32(SqlHelper.ExecuteNonQuery(SqlHelper.connStr, CommandType.Text, strSql.ToString(), param))); } catch (Exception ex) { throw ex; } }
/// <summary> /// 从服务器端获取车型管理分页列表(当按排序查询时) /// </summary> /// <param name="pageIndex">当前页码</param> /// <param name="pageSize">页码大小</param> /// <param name="totalCount">总记录数</param> /// <returns></returns> public List <Common.Entity.CarInfo> GetCarsManagePager(int pageIndex, int pageSize, string sortName, string IsDesc, Common.Entity.CarInfo filter, out int totalCount) { using (IDbConnection conn = new SqlConnection(SqlHelper.connStr)) { StringBuilder sqlCount = new StringBuilder(); sqlCount.Append(@"select count(@pageSize) from CarInfo where PKID>0"); if (!string.IsNullOrEmpty(filter.Name)) { sqlCount.Append(" and Name=@Name"); } if (!string.IsNullOrEmpty(filter.SFX)) { sqlCount.Append(" and C.SFX like '%" + filter.SFX + "%'"); } DynamicParameters param1 = new DynamicParameters(); param1.Add("pageSize", pageSize); param1.Add("Name", filter.Name); totalCount = conn.Query <int>(sqlCount.ToString(), param1).FirstOrDefault(); // 输出总记录数 StringBuilder strSql = new StringBuilder(); strSql.Append($@"select top (@pageSize) * from ( select row_number() over (order by C.PKID) as rowNumber, C.*,D.ListName as BrandName,D1.ListName as CarLogoName from CarInfo C left join Dictionary D on C.BrandID=D.PKID left join Dictionary D1 on C.CarLogoID=D1.PKID where C.PKID>0"); if (!string.IsNullOrEmpty(filter.Name)) { strSql.Append(" and C.Name like '%" + filter.Name + "%'"); } if (!string.IsNullOrEmpty(filter.SFX)) { strSql.Append(" and C.SFX like '%" + filter.SFX + "%'"); } strSql.Append($@" ) as t where t.rowNumber>(@pageIndex-1)*@pageSize order by t.{sortName} {IsDesc}"); DynamicParameters param2 = new DynamicParameters(); param2.Add("pageSize", pageSize); param2.Add("pageIndex", pageIndex); param2.Add("Name", filter.Name); List <Common.Entity.CarInfo> list = conn.Query <Common.Entity.CarInfo>(strSql.ToString(), param2).ToList(); return(list); }; }
/// <summary> /// 修改一条记录 /// </summary> /// <param name="model">实体对象</param> /// <returns>返回值</returns> public int Update(Common.Entity.CarInfo model) { return(new DAL.CarInfo().Update(model)); }
/// <summary> /// 新增一条记录 /// </summary> /// <param name="model">实体对象</param> /// <returns>返回值</returns> public int Add(Common.Entity.CarInfo model) { return(new DAL.CarInfo().Add(model)); }
public void SaveData(HttpContext context) { int HidID = Convert.ToInt32(context.Request["HidID"]); string fr_Name = context.Request["fr_Name"]; string CarModel = context.Request["CarModel"]; string GearboxVersion = context.Request["GearboxVersion"]; string Spec = context.Request["Spec"]; string Model = context.Request["Model"]; string fr_SFX = context.Request["fr_SFX"]; string Code = context.Request["Code"]; int TypeID = Convert.ToInt32(context.Request["TypeID"]); int BrandID = Convert.ToInt32(context.Request["BrandID"]); string BuiltInColor = context.Request["BuiltInColor"]; string Drive = context.Request["Drive"]; double SuggestPrice = 0; double.TryParse(context.Request["SuggestPrice"], out SuggestPrice); int CarLogoID = Convert.ToInt32(context.Request["CarLogoID"]); string Remark = context.Request["Remark"]; Common.Entity.CarInfo model = new Common.Entity.CarInfo(); BLL.CarInfo bll = new BLL.CarInfo(); if (HidID > 0) { model.PKID = HidID; model.Name = fr_Name; model.CarModel = CarModel; model.GearboxVersion = GearboxVersion; model.Spec = Spec; model.Model = Model; model.SFX = fr_SFX; model.Code = Code; model.TypeID = TypeID; model.BrandID = BrandID; model.BuiltInColor = BuiltInColor; model.Drive = Drive; model.SuggestPrice = SuggestPrice; model.CarLogoID = CarLogoID; model.Remark = Remark; int result = bll.Update(model); if (result > 0) { context.Response.Write("{\"msg\":\"保存成功。\",\"success\":true}"); } else { context.Response.Write("{\"msg\":\"保存失败。\",\"success\":false}"); } } else { model.Name = fr_Name; model.CarModel = CarModel; model.GearboxVersion = GearboxVersion; model.Spec = Spec; model.Model = Model; model.SFX = fr_SFX; model.Code = Code; model.TypeID = TypeID; model.BrandID = BrandID; model.BuiltInColor = BuiltInColor; model.Drive = Drive; model.SuggestPrice = SuggestPrice; model.CarLogoID = CarLogoID; model.Remark = Remark; if (bll.Exists(model.Name, model.SFX)) { context.Response.Write("{\"state\":1, \"msg\":\"" + fr_Name + "," + fr_SFX + "\"}"); } else { int result = bll.Add(model); if (result > 0) { context.Response.Write("{\"msg\":\"保存成功。\",\"success\":true}"); } else { context.Response.Write("{\"msg\":\"保存失败。\",\"success\":false}"); } } } }