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