public List <CnAreaCode> getAllProvince()
{
int error = 0;
do
{
try
{
using (var db = _dbFactory.OpenDbConnection())
{
var query = db.From <CnAreaCode>().Where(c => c.AreaCode.Contains("0000"));
return(db.Select(query));
}
}
catch (Exception ex1)
{
error++;
Thread.Sleep(10000);
LogServer.WriteLog(ex1.Message, "DBError");
}
} while (error < 4);
return(null);
}
public List <CarTypeInfo> GetAllCarType()
{
int error = 0;
do
{
try
{
using (var db = _dbFactory.OpenDbConnection())
{
return(db.Select <CarTypeInfo>());
}
break;
}
catch (Exception ex1)
{
error++;
Thread.Sleep(10000);
LogServer.WriteLog(ex1.Message, "DBError");
}
} while (error < 4);
return(null);
}
public List <CarDetialInfo> GetCarLIst(string Num)
{
int error = 0;
do
{
try
{
using (var db = _dbFactory.OpenDbConnection())
{
var query = db.From <CarDetialInfo>().Where(c => c.SellerNumber == Num).OrderByDescending(c => c.Id);
return(db.Select(query));
}
}
catch (Exception ex1)
{
error++;
Thread.Sleep(10000);
LogServer.WriteLog(ex1.Message, "DBError");
}
} while (error < 4);
return(null);
}
public int UpdateData(ShopInfo data)
{
int error = 0;
do
{
try
{
using (var db = _dbFactory.OpenDbConnection())
{
return(db.Update(data));
}
break;
}
catch (Exception ex1)
{
error++;
Thread.Sleep(10000);
LogServer.WriteLog(ex1.Message, "DBError");
}
} while (error < 4);
return(0);
}
public ShopInfo Login(string number, string pwd)
{
int error = 0;
do
{
try
{
using (var db = _dbFactory.OpenDbConnection())
{
return(db.Single <ShopInfo>(c => c.ShopNum == number && c.ShopPwd == pwd));
}
break;
}
catch (Exception ex1)
{
error++;
Thread.Sleep(10000);
LogServer.WriteLog(ex1.Message, "DBError");
}
} while (error < 4);
return(null);
}
public int ExecSql(string sql)
{
int error = 0;
do
{
try
{
using (var db = _dbFactory.OpenDbConnection())
{
return(db.ExecuteNonQuery(sql));
}
break;
}
catch (Exception ex1)
{
error++;
Thread.Sleep(10000);
LogServer.WriteLog(ex1.Message, "DBError");
}
} while (error < 4);
return(0);
}
private void loadShopImg()
{
var list = new ShopInfoDb().GetAllShopinfo();
WebClient myWebClient = new WebClient();
string path = Server.MapPath("/");
foreach (var item in list)
{
string file1 = "http://www.912sc.com/" + item.IdCart.TrimStart('/');
string file2 = "http://www.912sc.com/" + item.BusinessLicense.TrimStart('/');
string newfile = path + item.IdCart.TrimStart('/').Replace("/", "\\");
string newfile2 = path + item.BusinessLicense.TrimStart('/').Replace("/", "\\");
if (File.Exists(newfile))
{
continue;
}
try
{
myWebClient.DownloadFile(file1, newfile);
}
catch (Exception ex)
{
LogServer.WriteLog(ex.Message + "item" + item.Id + "\t" + file1);
}
try
{
myWebClient.DownloadFile(file2, newfile2);
}
catch (Exception ex)
{
LogServer.WriteLog(ex.Message + "item" + item.Id + "\t" + file2);
}
}
}
public void AddBandInfo(BandInfo item)
{
int error = 0;
do
{
try
{
using (var db = _dbFactory.OpenDbConnection())
{
item.CreateTime = DateTime.Now;
db.Insert(item);
}
break;
}
catch (Exception ex1)
{
error++;
Thread.Sleep(10000);
LogServer.WriteLog(ex1.Message, "DBError");
}
} while (error < 4);
}
public CarTypeInfo GetCarinfo(CarTypeInfo item)
{
int error = 0;
do
{
try
{
using (var db = _dbFactory.OpenDbConnection())
{
return(db.Single <CarTypeInfo>(c => c.DisplayName == item.DisplayName));
}
break;
}
catch (Exception ex1)
{
error++;
Thread.Sleep(10000);
LogServer.WriteLog(ex1.Message, "DBError");
}
} while (error < 4);
return(null);
}
public bool DeleteData(int id)
{
int error = 0;
do
{
try
{
using (var db = _dbFactory.OpenDbConnection())
{
error = db.DeleteById <ShopInfo>(id);
return(true);
}
break;
}
catch (Exception ex1)
{
error++;
Thread.Sleep(10000);
LogServer.WriteLog(ex1.Message, "DBError");
}
} while (error < 4);
return(false);
}
/// <summary>
/// 启动程序
/// </summary>
/// <param name="services"></param>
public void ConfigureServices(IServiceCollection services)
{
#region Cors跨域需要添加以下代码
//services.AddCors(c =>
//{
// //控制器中[EnableCors("AllRequests")]名字需对应
// c.AddPolicy(CorsName,
// policy => policy
// .AllowAnyOrigin()
// .AllowAnyMethod()//允许任何方式
// .AllowAnyHeader());//允许任何头//允许cookie
//});
//services.AddCors(op =>
//{ op.AddPolicy("cors",
// set => { set.SetIsOriginAllowed(origin => true)
// .AllowAnyHeader().AllowAnyMethod().AllowCredentials(); }); });
#endregion
services.AddSignalR();
#region 配置启动程序
//获取appsettings.json文件Default节点下面的连接字符串
var sqlconn = Configuration.GetConnectionString("SqlserverDefault");
LogServer.WriteLog("20190107", "数据库链接字符串", sqlconn);
//第一个参数传入连接字符串 ， 第二个参数指明执行迁移的程序集
//options.UseSqlServer(sqlconn,b=>b.MigrationsAssembly("CorePractice") 如果事WebApi 项目的话需要加services.AddEntityFrameworkSqlServer().AddDbContext
services.AddEntityFrameworkSqlServer().AddDbContext <UwlDbContext>(options =>
options.UseSqlServer(sqlconn, b => b.MigrationsAssembly("UwlAPI.Tools")));
#endregion
services.AddControllers(mvc =>
{
//全局路由权限公约，给路由添加Authorize特性
mvc.Conventions.Insert(0, new GlobalRouteAuthorizeConvention());
//mvc.Conventions.Insert(0, new AddRoutePrefixFilter(new RouteAttribute(RoutePrefix.Name)));
});
#region Swagger
services.SwaggerConfigureExtension();
#endregion
#region No.1 官方的JWT验证 简单的策略授权（简单版）
//services.AddAuthorization(options =>
//{
// options.AddPolicy("Client", policy => policy.RequireRole("Client").Build());
// options.AddPolicy("Admin", policy => policy.RequireRole("Admin").Build());
// options.AddPolicy("SystemOrAdmin", policy => policy.RequireRole("Admin", "System"));
// options.AddPolicy("SystemOrAdminOrOther", policy => policy.RequireRole("Admin", "System", "Other"));
//});
//services.AddAuthentication(options =>
//{
// options.DefaultAuthenticateScheme = JwtBearerDefaults.AuthenticationScheme;
// options.DefaultChallengeScheme = JwtBearerDefaults.AuthenticationScheme;
//}).AddJwtBearer(jwt=>
//{
// jwt.TokenValidationParameters = TokenValidationParameters;
//});
#endregion
#region No.2 中间件授权认证方式 使用此认证需要在Configure里面放开app.UseMiddleware<JwtTokenAuth>();取消注释所有控制器的[Authorize(Policy = "Admin")] 并且注释掉[Authorize]
//中间件签名过期无效待解决——————需要自己写鉴权方式，前名是否过期……？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？
//基于角色的策略授权（简单版） + 自定义认证中间件
//services.AddAuthorization(options =>
//{
// options.AddPolicy("Client", policy => policy.RequireRole("Client").Build());
// options.AddPolicy("Admin", policy => policy.RequireRole("Admin").Build());
// options.AddPolicy("AdminOrClient", policy => policy.RequireRole("AdminOrClient").Build());
//});
// 2【认证】、然后在下边的configure里，配置中间件即可:
// app.UseMiddleware<JwtTokenAuth>();
//services.AddAuthorization(options =>
//{
// options.AddPolicy("Client", policy => policy.RequireRole("Client").Build());
// options.AddPolicy("Admin", policy => policy.RequireRole("Admin").Build());
// options.AddPolicy("SystemOrAdmin", policy => policy.RequireRole("Admin", "System"));
// options.AddPolicy("SystemOrAdminOrOther", policy => policy.RequireRole("Admin", "System", "Other"));
//});
//services.AddAuthentication(options =>
//{
// options.DefaultAuthenticateScheme = JwtBearerDefaults.AuthenticationScheme;
// options.DefaultChallengeScheme = JwtBearerDefaults.AuthenticationScheme;
//}).AddJwtBearer(jwt =>
//{
// jwt.TokenValidationParameters = TokenValidationParameters;
//});
#endregion
#region No.3 复杂策略授权 + 官方JWT认证
services.AddHttpContextExtension();
services.AuthExtension();
#endregion
#region 添加automapper实体映射,如果存在相同字段则自动映射
services.AddAutoMapper(GetType());
//注册需要自动映射的实体类
_mapperConfiguration = new MapperConfiguration(cfg =>
{
//初始化自动映射类
cfg.AddProfile <MyProfile>();
});
//将自动映射属性封装为静态属性
MyMappers.ObjectMapper = _mapperConfiguration.CreateMapper();
services.AddScoped <MyProfile>();//注入自动映射类
#endregion
#region 接口控制反转依赖注入 -netcore自带方法
services.ServerExtension();
services.RepositotyExtension();
#endregion
#region 缓存和任务调度中心使用 单例模式注入生命周期
services.CommonExtension();
services.JobExtension();
#endregion
}
public List <CarDetialInfo> GetCarList(string carType, string brandNum, string brandType, string carColor, string bianShuQi, decimal minBaojia, decimal maxBaojia, int pageid, int pagecount, string sortKey, string sortType)
{
int error = 0;
do
{
try
{
using (var db = _dbFactory.OpenDbConnection())
{
var query = db.From <CarDetialInfo>();
if (!string.IsNullOrEmpty(carType))
{
query = query.Where(c => c.CarType == carType);
}
if (!string.IsNullOrEmpty(brandNum))
{
query = query.Where(c => c.BrandInfoKey == brandNum);
}
if (!string.IsNullOrEmpty(brandType))
{
query = query.Where(c => c.BrandTypeKey == brandType);
}
if (!string.IsNullOrEmpty(carColor))
{
query = query.Where(c => c.CarColor == carColor);
}
if (!string.IsNullOrEmpty(bianShuQi))
{
query = query.Where(c => c.BianShuQi == bianShuQi);
}
if (minBaojia > 0)
{
query = query.Where(c => c.baojia >= minBaojia);
}
if (maxBaojia > minBaojia)
{
query = query.Where(c => c.baojia <= maxBaojia);
}
switch (sortKey)
{
case "ShangPaiYear":
query = sortType == "desc" ? query.OrderByDescending(c => c.ShangPaiYear) : query.OrderBy(c => c.ShangPaiYear);
break;
case "BrandInfoKey":
query = sortType == "desc" ? query.OrderByDescending(c => c.BrandInfoKey) : query.OrderBy(c => c.BrandInfoKey);
break;
case "baojia":
query = sortType == "desc" ? query.OrderByDescending(c => c.baojia) : query.OrderBy(c => c.baojia);
break;
default:
query = query.OrderByDescending(c => c.Id);
break;
}
int skip = (pageid - 1) * pagecount;
query = query.Skip(skip).Take(pagecount);
return(db.Select(query));
}
}
catch (Exception ex1)
{
error++;
Thread.Sleep(3000);
LogServer.WriteLog(ex1.Message, "DBError");
}
} while (error < 4);
return(null);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["userid"] == null || Session["userid"].ToString() != "23")
{
string url = HttpContext.Current.Request.Url.PathAndQuery;
Response.Redirect("Login.aspx?url=" + url);
}
var oldnum = Request.Form["oldnumber"];
var newnum = Request.Form["newnumber"];
var method = Request.Form["method"];
if (method == "2" && !string.IsNullOrEmpty(oldnum))
{
// 查询
StringBuilder items = new StringBuilder();
var list = new prologDb().GetproLogById(oldnum.Trim());
string head = " <table cellspacing ='0' cellpadding = '0' width = '100%' class='listtable'><tbody><tr><th>编号</th><th>名称</th></tr>";
items.Append(head);
foreach (var car in list)
{
items.AppendFormat("<tr><td>{0}</td><td><a target='_blank' href='http://www.nb77.cn/dealer/index.php?mod=user&ac=refresh&id={2}&page=1'>{1}</a></td></tr>", car.shopNumber, car.proName, car.proid);
}
items.Append("</table>");
return;
}
if (!string.IsNullOrEmpty(oldnum) && !string.IsNullOrEmpty(newnum))
{
var list = new prologDb().GetproLogById(oldnum.Trim());
if (list.Count == 0)
{
msg = "没有找到任何车辆信息";
return;
}
brandList = new BandInfoDb().GetBandInfoByParentNum("0");
foreach (var bandInfo in brandList)
{
brandReg += bandInfo.BrandName + "|";
}
brandReg = brandReg.TrimEnd('|');
foreach (var item in list)
{
try
{
addCar(item);
}
catch (Exception ex)
{
LogServer.WriteLog("proid:" + item.proid + "error" + ex.Message, "jiexi");
}
}
msg = "导入完毕共导入" + Items.Count + "条信息";
}
//brandList = new BandInfoDb().GetBandInfoByParentNum("0");
//foreach (var bandInfo in brandList)
//{
// brandReg += bandInfo.BrandName + "|";
//}
//brandReg = brandReg.TrimEnd('|');
//var list = new prologDb().GetproLogById(0, 100);
//foreach (var item in list)
//{
// try
// {
// addCar(item);
// }
// catch (Exception ex)
// {
// LogServer.WriteLog("proid:" + item.proid + "error" + ex.Message, "jiexi");
// }
//}
}
