/// <summary>
/// 添加车辆
/// </summary>
/// <param name="model">车辆信息</param>
/// <returns></returns>
public int AddCar(CarInfoModel model)
{
const string sql = @"INSERT INTO `car_info`
(`innerid`,`custid`,`carid`,`title`,`pic_url`,`provid`,`cityid`,`brand_id`,`series_id`,`model_id`,`colorid`,`mileage`,`register_date`,`buytime`,`buyprice`,`price`,`dealprice`,`isproblem`,`remark`,`ckyear_date`,`tlci_date`,`audit_date`,`istain`,`sellreason`,`masterdesc`,`dealdesc`,`deletedesc`,`estimateprice`,`status`,`createdtime`,`modifiedtime`,`seller_type`,`post_time`,`audit_time`,`sold_time`,`keep_time`,`eval_price`,`next_year_eval_price`)
VALUES
(@innerid,@custid,@carid,@title,@pic_url,@provid,@cityid,@brand_id,@series_id,@model_id,@colorid,@mileage,@register_date,@buytime,@buyprice,@price,@dealprice,@isproblem,@remark,@ckyear_date,@tlci_date,@audit_date,@istain,@sellreason,@masterdesc,@dealdesc,@deletedesc,@estimateprice,@status,@createdtime,@modifiedtime,@seller_type,@post_time,@audit_time,@sold_time,@keep_time,@eval_price,@next_year_eval_price);";
int result;
try
{
result = Helper.Execute(sql, model);
}
catch (Exception ex)
{
result = 0;
}
return result;
}
public void AddCar()
{
var model = new CarInfoModel
{
Innerid = Guid.NewGuid().ToString(),
supplierid = "",
title = "",
pic_url = "",
provid = 0,
cityid = 0,
brand_id = 0,
series_id = 0,
model_id = 0,
colorid = 0,
buytime = DateTime.Now,
buyprice = 0,
dealprice = 0,
isproblem = 0,
sellreason = "转让原因",
masterdesc = "原车主信息",
dealdesc = "成交备注",
deletedesc = "删除备注",
ckyear_date = DateTime.Now,
tlci_date = DateTime.Now,
istain = 0,
price = 0,
mileage = 0,
register_date = DateTime.Now,
seller_type = 2,
status = 1,
remark = "车况备注/优势",
createdtime = DateTime.Now,
modifiedtime = DateTime.Now,
post_time = DateTime.Now,
audit_time = DateTime.Now,
sold_time = DateTime.Now,
estimateprice = "车源估值情况",
eval_price = 0,
next_year_eval_price = 0,
audit_date = DateTime.Now,
custid = "会员ID",
provname = "省份",
cityname = "城市",
brand_name = "品牌",
series_name = "车系",
model_name = "车型",
geartype = "变速箱类型",
color = "颜色",
liter = "排量",
dischargeName = "排放标准"
};
var value = cms.AddCar(model);
Assert.IsTrue(value.errcode == 0);
}
/// <summary>
/// 添加车辆
/// </summary>
/// <param name="model">车辆信息</param>
/// <returns></returns>
public int UpdateCar(CarInfoModel model)
{
var sql = new StringBuilder("update `car_info` set ");
sql.Append(Helper.CreateField(model).Trim().TrimEnd(','));
sql.Append(" where innerid = @innerid");
int result;
try
{
result = Helper.Execute(sql.ToString(), model);
}
catch (Exception ex)
{
result = 0;
}
return result;
}
/// <summary>
/// 删除车辆
/// </summary>
/// <param name="model">删除成交model</param>
/// <returns>1.操作成功</returns>
public int DeleteCar(CarInfoModel model)
{
try
{
const string sql = "update car_info set status=0,deletedesc=@deletedesc where `innerid`=@innerid;";
Helper.Execute(sql, new { innerid = model.Innerid, model.deletedesc });
}
catch (Exception ex)
{
return 0;
}
return 1;
}
/// <summary>
/// 车辆成交
/// </summary>
/// <param name="model">车辆成交model</param>
/// <returns>1.操作成功</returns>
public int DealCar(CarInfoModel model)
{
try
{
const string sql = "update car_info set status=2,dealprice=@dealprice,dealdesc=@dealdesc,sold_time=@sold_time where `innerid`=@innerid;";
Helper.Execute(sql, new { innerid = model.Innerid,model.dealprice, model.dealdesc });
}
catch (Exception ex)
{
return 0;
}
return 1;
}
/// <summary>
/// 修改车辆
/// </summary>
/// <param name="model">车辆信息</param>
/// <returns></returns>
public int UpdateCar(CarInfoModel model)
{
var sql = new StringBuilder("update `car_info` set ");
sql.Append(Helper.CreateField(model).Trim().TrimEnd(','));
//非必填字段的修改
if (!model.buytime.HasValue)
{
sql.Append(",buytime=null");
}
if (!model.buyprice.HasValue)
{
sql.Append(",buyprice=null");
}
if (!model.ckyear_date.HasValue)
{
sql.Append(",ckyear_date=null");
}
if (!model.tlci_date.HasValue)
{
sql.Append(",tlci_date=null");
}
if (!model.audit_date.HasValue)
{
sql.Append(",audit_date=null");
}
sql.Append(" where innerid = @innerid");
int result;
try
{
result = Helper.Execute(sql.ToString(), model);
}
catch (Exception ex)
{
LoggerFactories.CreateLogger().Write("车辆修改：", TraceEventType.Error, ex);
result = 0;
}
return result;
}
/// <summary>
/// 回复车辆
/// </summary>
/// <param name="model">回复成交model</param>
/// <returns>1.操作成功</returns>
public int RecoveryCar(CarInfoModel model)
{
try
{
const string sql = "update car_info set `status`=ifnull(eval_price,1),eval_price=null,deletedesc=concat(ifnull(deletedesc,''),@deletedesc) where `innerid`=@innerid;";
model.deletedesc = string.Concat("\n@", model.deletedesc);
Helper.Execute(sql, new { innerid = model.Innerid, model.deletedesc });
}
catch (Exception ex)
{
return 0;
}
return 1;
}
/// <summary>
/// 添加车辆
/// </summary>
/// <param name="model">车辆信息</param>
/// <returns></returns>
public int AddCar(CarInfoModel model)
{
const string sql = @"INSERT INTO `car_info`
(`innerid`,`custid`,`supplierid`,`carno`,`title`,`pic_url`,`provid`,`cityid`,`brand_id`,`series_id`,`model_id`,`colorid`,`mileage`,`register_date`,`buytime`,`buyprice`,`price`,`dealprice`,`isproblem`,`remark`,`ckyear_date`,`tlci_date`,`audit_date`,`istain`,`sellreason`,`masterdesc`,`dealdesc`,`deletedesc`,`estimateprice`,`status`,`createdtime`,`modifiedtime`,`seller_type`,`post_time`,`audit_time`,`sold_time`,`closecasetime`,`eval_price`,`next_year_eval_price`,`refreshtime`, `istop`, `istransferfee`)
VALUES
(@innerid,@custid,@supplierid,@carno,@title,@pic_url,@provid,@cityid,@brand_id,@series_id,@model_id,@colorid,@mileage,@register_date,@buytime,@buyprice,@price,@dealprice,@isproblem,@remark,@ckyear_date,@tlci_date,@audit_date,@istain,@sellreason,@masterdesc,@dealdesc,@deletedesc,@estimateprice,@status,@createdtime,@modifiedtime,@seller_type,@post_time,@audit_time,@sold_time,@closecasetime,@eval_price,@next_year_eval_price,@refreshtime, @istop, @istransferfee);";
using (var conn = Helper.GetConnection())
{
int result;
try
{
if (model.seller_type != 3)
{
var num = conn.Query<int?>("select `type` from cust_info where innerid=@custid;", new { model.custid }).FirstOrDefault();
if (num == null || num == 0)
{
return -1;
}
model.seller_type = num;
}
result = conn.Execute(sql, model);
}
catch (Exception ex)
{
LoggerFactories.CreateLogger().Write("添加车辆异常：", TraceEventType.Information, ex);
result = 0;
}
return result;
}
}