public ResultModel RetrieveCellPhoneNumber([FromBody] BusinessModel param)
{
try
{
if (!PermissionCheck.Check(param))
{
return(new ResultModel {
statusCode = "000007", result = "没有权限"
});
}
var oo = new OracleOperation();
Log.Info("RetrieveCellPhoneNumber 111");
var a = oo.RetrieveCellPhoneNumber(param);
Log.Info("RetrieveCellPhoneNumber 222");
return(new ResultModel {
statusCode = a == string.Empty ? "000000" : "000011", bussinessModel = new BusinessModel {
phoneNum = a
}
});
}
catch (Exception ex)
{
Log.Error("RetrieveCellPhoneNumber", ex);
return(new ResultModel {
statusCode = "000003", result = ex.Message
});
}
}
public ResultModel RetrieveCorporateInfo([FromBody] BusinessModel param)
{
try
{
if (!PermissionCheck.Check(param))
{
return(new ResultModel {
statusCode = "000007", result = "没有权限"
});
}
var oo = new OracleOperation();
Log.Info("RetrieveCorporateInfo 111");
var a = oo.RetrieveCorporateInfo(param);
Log.Info("RetrieveCorporateInfo 222");
return(new ResultModel {
statusCode = a.name == string.Empty ? "000000" : "000013", bussinessModel = a
});
}
catch (Exception ex)
{
Log.Error("RetrieveCorporateInfo", ex);
return(new ResultModel {
statusCode = "000003", result = ex.Message
});
}
}
public ResultModel SendCorporateInfo([FromBody] BusinessModel param)
{
try
{
if (!PermissionCheck.Check(param))
{
return(new ResultModel {
statusCode = "000007", result = "没有权限"
});
}
var oo = new OracleOperation();
Log.Info("SendCorporateInfo 111");
var a = oo.SendCorporateInfo(param);
Log.Info("SendCorporateInfo 222");
return(new ResultModel {
statusCode = a == 1 ? "000000" : "000012", bussinessModel = new BusinessModel()
});
}
catch (Exception ex)
{
Log.Error("SendCorporateInfo", ex);
return(new ResultModel {
statusCode = "000003", result = ex.Message
});
}
}
public ResultModel GET_QUEUE_NUM([FromBody] BusinessModel param)
{
try
{
if (!PermissionCheck.Check(param))
{
return(new ResultModel {
statusCode = "000007", result = "没有权限"
});
}
InputLog(param);
var oo = new OracleOperation();
return(new ResultModel {
statusCode = "000000", bussinessModel = new BusinessModel {
queueNum = oo.GetOrdinal(param).ToString()
}
});
}
catch (Exception ex)
{
Log.Error("GET_QUEUE_NUM", ex);
return(new ResultModel {
statusCode = "000003", result = ex.Message
});
}
}
public ResultModel GET_VERSION([FromBody] BusinessModel param)
{
try
{
if (!PermissionCheck.Check(param))
{
return(new ResultModel {
statusCode = "000007", result = "没有权限"
});
}
Log.Info("GET_VERSION input param:" + param);
// var input = JsonConvert.DeserializeObject<BusinessModel>(param);
// var errDict = JsonConvert.DeserializeObject<Dictionary<string, string>>(param);
// Log.Info("GET_VERSION input errDict:" + errDict);
// /ar haha = string.Empty;
//foreach(var a in Request.Properties)
//{
// haha += a.Value+";";
//}
return(new ResultModel {
statusCode = "000000", result = "hehe", bussinessModel = param
});
}
catch (Exception ex)
{
Log.Error("GET_VERSION", ex);
return(new ResultModel {
statusCode = "000003", result = ex.Message
});
}
}
public ResultModel DueAndChangeCertification([FromBody] BusinessModel param)
{
try
{
if (!PermissionCheck.Check(param))
{
return(new ResultModel {
statusCode = "000007", result = "没有权限"
});
}
InputLog(param);
var oo = new OracleOperation();
var ret = oo.dueAndChangeCertification(param);
return(new ResultModel {
statusCode = ret == 1?"000000":"000004", bussinessModel = new BusinessModel {
queueNum = oo.GetOrdinal(param).ToString()
}
});
}
catch (Exception ex)
{
Log.Error("dueAndChangeCertification", ex);
return(new ResultModel {
statusCode = "000003", result = ex.Message
});
}
}
public ResultModel GetBusinessInfoByOdc([FromBody] BusinessModel param)
{
try
{
if (!PermissionCheck.Check(param))
{
return(new ResultModel {
statusCode = "000007", result = "没有权限"
});
}
InputLog(param);
using (var cd = new Business())
{
switch (param.countyCode)
{
case "haiyang":
return(HaiyangBusinessInfo(cd, param));
case "fushan":
return(FushanBusinessInfo(cd, param));
default:
return(AllBusinessInfo(cd, param));
}
}
}
catch (DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
Log.InfoFormat("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
Log.InfoFormat("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
throw;
}
catch (EntityDataSourceValidationException ex)
{
Log.Error("EntityDataSourceValidationException", ex);
return(new ResultModel {
statusCode = "000003", result = ex.Message
});
}
catch (Exception ex)
{
Log.Error("GetBusinessInfoByOdc", ex);
return(new ResultModel {
statusCode = "000003", result = ex.Message
});
}
}
/// <summary>
/// Checks whether the given player has the permission to run this command.
/// </summary>
/// <param name="player">The player that attempts to run this command.</param>
/// <returns>
/// True when allowed, False otherwise.
/// </returns>
public override bool HasPlayerPermissionForCommand(GtaPlayer player)
{
return(PermissionCheck == null || PermissionCheck.Check(player));
}
public async Task <ResultModel> PostBusinessFormInfo([FromBody] BusinessModel param)
{
try
{
if (!PermissionCheck.Check(param))
{
return(new ResultModel {
statusCode = "000007", result = "没有权限"
});
}
// Log.Info("PostBusinessFormInfo input is:" + JsonConvert.SerializeObject(param));
var id = new OracleOperation().GetBusinessId();
var currentdate = DateTime.Now.Date;
var scurrentdate = string.Format("{0}-{1}-{2}", currentdate.Year, currentdate.Month, currentdate.Day);
var filepath = string.Format("{2}{0}\\{1}", param.countyCode, scurrentdate, @FileRootPath);
// Log.Info("path 11 =" + filepath);
if (!Directory.Exists(@filepath))
{
Log.Info("path=" + filepath);
Directory.CreateDirectory(@filepath);
}
var filename = string.Format("{0}\\{1}", filepath, id);
// Log.Info("file name=" + filename);
File.WriteAllBytes(filename, param.zipFile);
switch (param.countyCode)
{
case "haiyang":
using (var cd = new Business())
{
cd.Haiyangbusiness.Add(new haiyangbusiness {
ID = id, COUNTYCODE = param.countyCode, UNLOAD_TASK_NUM = param.unloadTaskNum, START_TIME = scurrentdate, STATUS = param.status, TYPE = param.type, NAME = param.name, ID_NUM = param.IDum, QUEUE_NUM = param.queueNum, ADDRESS = param.address, PHONE_NUM = param.phoneNum, ATTENTION = param.attention
});
cd.SaveChanges();
}
break;
case "fushan":
using (var cd = new Business())
{
cd.Fushanbusiness.Add(new fushanbusiness {
ID = id, COUNTYCODE = param.countyCode, UNLOAD_TASK_NUM = param.unloadTaskNum, START_TIME = scurrentdate, STATUS = param.status, TYPE = param.type, NAME = param.name, ID_NUM = param.IDum, QUEUE_NUM = param.queueNum, ADDRESS = param.address, PHONE_NUM = param.phoneNum, ATTENTION = param.attention
});
cd.SaveChanges();
}
break;
default:
using (var cd = new Business())
{
cd.Bussiness.Add(new BUSSINESS {
ID = id, COUNTYCODE = param.countyCode, UNLOAD_TASK_NUM = param.unloadTaskNum, START_TIME = scurrentdate, STATUS = param.status, TYPE = param.type, NAME = param.name, ID_NUM = param.IDum, QUEUE_NUM = param.queueNum, ADDRESS = param.address, PHONE_NUM = param.phoneNum, ATTENTION = param.attention
});
cd.SaveChanges();
}
break;
}
await MessagePush.PushVoiceMessage(new CdmMessage
{
ClientType = ClientType.Voice,
Content = param.queueNum,
CountyCode = param.countyCode,
VoiceType = VoiceType.Fee
});
return(new ResultModel {
statusCode = "000000", bussinessModel = new BusinessModel()
});
}
catch (DbEntityValidationException e)
{
var err = string.Empty;
foreach (var eve in e.EntityValidationErrors)
{
var err1 =
string.Format("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
err += err1;
Log.InfoFormat(err1);
foreach (var ve in eve.ValidationErrors)
{
var err2 = string.Format("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
Log.InfoFormat(err2);
err += err2;
}
}
return(new ResultModel {
statusCode = "000003", result = "DbEntityValidationException:" + err
});
}
catch (EntityDataSourceValidationException ex)
{
Log.Error("EntityDataSourceValidationException", ex);
return(new ResultModel {
statusCode = "000003", result = ex.Message
});
}
catch (Exception ex)
{
Log.Error("PostBusinessFormInfo", ex);
return(new ResultModel {
statusCode = "000003", result = ex.Message
});
}
}
public SimpleResult UserTransaction([FromBody] UserTransaction param)
{
try
{
Log.Info("UserTransaction input:" + JsonConvert.SerializeObject(param));
if (!PermissionCheck.Check(param))
{
return(new SimpleResult {
StatusCode = "000007", Content = "没有权限"
});
}
var userslist = new List <PoliceUser>();
switch (param.UserTransactionType)
{
case UserTransactionType.Add:
Log.Info("in user add-----------------");
using (var userdb = new UserDbc())
{
var u = new USERS
{
AUTHORITYLEVEL = ((int)param.UserInfo.AuthorityLevel).ToString(),
COUNTYCODE = param.UserInfo.CountyCode,
LIMIT = JsonConvert.SerializeObject(param.UserInfo.Permission),
PASSWORD = CdmEncrypt(param.UserInfo.Password),
POLICENUM = param.UserInfo.PoliceCode,
ID = new Random().Next(),
DEPARTMENT = " ff",
POST = param.UserInfo.UserRole.ToString(),
USERNAME = param.UserInfo.UserName,
REALNAME = param.UserInfo.RealName,
};
userdb.USERS.Add(u);
userdb.SaveChanges();
}
break;
case UserTransactionType.Disable:
using (var userdb = new UserDbc())
{
var theuser =
userdb.USERS.FirstOrDefault(a => a.USERNAME == param.UserInfo.UserName);
if (theuser == null)
{
return(new SimpleResult {
StatusCode = "000005", Content = "无此用户:" + param.UserInfo.UserName
});
}
theuser.DISABLED = false;
userdb.SaveChanges();
}
break;
case UserTransactionType.Update:
using (var userdb = new UserDbc())
{
var theuser =
userdb.USERS.FirstOrDefault(a => a.USERNAME == param.UserInfo.UserName);
if (theuser == null)
{
return(new SimpleResult {
StatusCode = "000005", Content = "无此用户:" + param.UserInfo.UserName
});
}
theuser.REALNAME = param.UserInfo.RealName;
theuser.LIMIT = JsonConvert.SerializeObject(param.UserInfo.Permission);
userdb.SaveChanges();
}
break;
case UserTransactionType.ResetPass:
using (var userdb = new UserDbc())
{
var theuser =
userdb.USERS.FirstOrDefault(a => a.USERNAME == param.UserInfo.UserName);
if (theuser == null)
{
return(new SimpleResult {
StatusCode = "000005", Content = "无此用户:" + param.UserInfo.UserName
});
}
theuser.PASSWORD = CdmEncrypt(param.UserInfo.Password);
userdb.SaveChanges();
}
break;
case UserTransactionType.GetUserList:
using (var userdb = new UserDbc())
{
var theuser =
userdb.USERS.Where(a => a.COUNTYCODE == param.UserInfo.CountyCode);
userslist.AddRange(theuser.Select(users => new PoliceUser
{
AuthorityLevel = (AuthorityLevel)int.Parse(users.AUTHORITYLEVEL),
CountyCode = users.COUNTYCODE,
Notation = string.Empty,
Password = users.PASSWORD,
Permission = JsonConvert.DeserializeObject <Dictionary <string, bool> >(users.LIMIT),
PoliceCode = users.POLICENUM,
RealName = users.REALNAME,
UserName = users.USERNAME,
UserRole = (UserRole)int.Parse(users.POST)
}));
}
return(new SimpleResult {
StatusCode = "000000", Content = "", Users = userslist
});
break;
default:
using (var userdb = new UserDbc())
{
var theuser =
userdb.USERS.FirstOrDefault(a => a.USERNAME == param.UserInfo.UserName);
if (theuser == null)
{
return(new SimpleResult {
StatusCode = "000005", Content = "无此用户:" + param.UserInfo.UserName
});
}
if (theuser.PASSWORD != CdmEncrypt(param.UserInfo.Password))
{
return(new SimpleResult {
StatusCode = "000004", Content = "密码错误"
});
}
}
break;
}
Log.Info("before ok----------------");
return(new SimpleResult {
StatusCode = "000000", Content = "ok"
});
}
catch (DbEntityValidationException e)
{
var err = string.Empty;
foreach (var eve in e.EntityValidationErrors)
{
var err1 =
string.Format("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
err += err1;
Log.InfoFormat(err1);
foreach (var ve in eve.ValidationErrors)
{
var err2 = string.Format("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
Log.InfoFormat(err2);
err += err2;
}
}
return(new SimpleResult {
StatusCode = "000003", Content = "DbEntityValidationException:" + err
});
}
catch (EntityDataSourceValidationException ex)
{
Log.Error("EntityDataSourceValidationException", ex);
return(new SimpleResult {
StatusCode = "000003", Content = "EntityDataSourceValidationException:" + ex.Message
});
}
catch (OracleException ex)
{
Log.Error("OracleException", ex);
return(new SimpleResult {
StatusCode = "000003", Content = "OracleException:" + ex.Message
});
}
catch (DbUpdateException ex)
{
Log.Error("DbUpdateException", ex);
return(new SimpleResult {
StatusCode = "000003", Content = "DbUpdateException:" + (ex.ToString().Contains("违反唯一约束条件 (CITY.USERSNAME)")?"用户名已经存在":ex.ToString())
});
}
catch (Exception ex)
{
Log.Error("UserTransaction", ex);
return(new SimpleResult {
StatusCode = "000003", Content = ex.Message
});
}
}
