public ActionResult LogIn(Default model)
{
if (string.IsNullOrEmpty(model.UserAccount).Equals(true) || string.IsNullOrEmpty(model.UserPassWord).Equals(true))
return View(model);
ReturnResult ReturnResult = new ReturnResult();
ReturnResult = CheckUserAccount(model.UserAccount.Trim().ToUpper(), model.UserPassWord.Trim().ToUpper());
if (ReturnResult.ReturnMsgNo == "1")
{
Session["UserAccount"] = model.UserAccount.Trim();
return RedirectToAction("Index");
}
ViewBag.Error = ReturnResult.ReturnMsgNo + "|" + ReturnResult.ReturnMsg;
return RedirectToAction("Error",new {ErrMsg = ReturnResult.ReturnMsgNo + "|" + ReturnResult.ReturnMsg});
}
/// <summary>
/// 获取一条数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public ReturnResult <ApiToken> GetOne(ApiToken model)
{
var rst = new ReturnResult <ApiToken>();
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append(@"select Id,AppId,AccessToken,RefreshToken,AccessTokenExpiresIn,AccessTokenCreateTime,RefreshTokenExpiresTime from api_token ");
strSql.Append("where 1=1 ");
if (model != null)
{
if (model.Id != 0)
{
strSql.Append("and Id = @Id ");
}
if (model.AppId > 0)
{
strSql.Append("and AppId = @AppId ");
}
}
var query = conn.Query <ApiToken>(strSql.ToString(), model).FirstOrDefault();
if (query == null)
{
rst.Message = "数据不存在";
}
else
{
rst.Result = true;
rst.Data = query;
rst.Message = "查询成功";
}
}
catch (Exception ex)
{
rst.Message = "查询失败：" + ex.Message;
Log4netUtil.Error("ApiTokenDal/GetOne", ex);
}
return(rst);
}
/// <summary>
/// 新增标签到微信并在此标签下新增用户
/// </summary>
/// <param name="appId"></param>
/// <param name="tagName"></param>
/// <returns></returns>
public ActionResult AddTagAndUse(string AppId, string tagName, string OpenId)
{
WX_App app = new WX_AppManager().GetByPK(AppId);
TagService ser = new TagService(app.AppId, app.AppSecret);
string json = ser.Create(tagName);
JObject jo = (JObject)JsonConvert.DeserializeObject(json);
WX_UserTag tag = new WX_UserTag()
{
AppId = AppId,
TagId = (int)jo["tag"]["id"],
TagName = jo["tag"]["name"].ToString(),
};
ReturnResult result = new ReturnResult()
{
Result = true
};
if (!new WX_UserTagManager().Add(tag))
{
result.Result = false;
result.ErrorMsg = "新增失败!";
}
else
{
List <string> openIdList = JsonConvert.DeserializeObject <List <string> >(OpenId);
JObject job = JObject.Parse(new UserService(app.AppId, app.AppSecret).AddTag(openIdList, tag.TagId));
var Adresult = new
{
errcode = job["errcode"].ToString(),
errmsg = job["errmsg"].ToString()
};
if (Adresult.errcode.Equals("0"))
{
WX_UserManager manager = new WX_UserManager();
foreach (var id in openIdList)
{
manager.AddTag(manager.GetByPK(id), tag.TagId);
}
}
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public InterfacePrototype GetSharedClass <InterfacePrototype>(string name, params object[] RemoteArgs)
{
lock (InitializedClasses)
{
SyncObject syncObject = null;
lock (Requests)
{
int RequestId = 0;
RequestId = GetNextRandomInteger();
while (Requests.ContainsKey(RequestId))
{
RequestId = GetNextRandomInteger();
}
syncObject = new SyncObject(this);
Requests.Add(RequestId, syncObject);
Send(new MsgGetSharedClass(name, RemoteArgs, RequestId));
}
ReturnResult result = syncObject.Wait <ReturnResult>(null, 30000); //wait for response
if (result == null)
{
throw new Exception("A timeout occured");
}
if (result.ExceptionOccured)
{
throw new Exception(result.exceptionMessage);
}
if (result.ReturnValue == null)
{
throw new Exception("The shared class \"" + name + "\" could not be found in the remote client");
}
SharedClass c = (SharedClass)result.ReturnValue;
c.Client = this;
InterfacePrototype tmp = DynClassCreator.CreateDynamicClass <InterfacePrototype>(c);
InitializedClasses.Add(c.SharedId, c);
return(tmp);
}
}
public HttpResponseMessage GetCityUserFromID([FromUri] int CityUserID)
{
//System.Diagnostics.EventLog.WriteEntry("Application", "LoginCust started");
AccountManagementService accService = new AccountManagementService();
HttpStatusCode ReturnCode = HttpStatusCode.OK;
TranInfo <CityUserAccount_M> transaction = new TranInfo <CityUserAccount_M>();
ReturnResult <CityUserAccount_M> result = new ReturnResult <CityUserAccount_M>();
try
{
result = accService.GetCityUserFromID(CityUserID);
if (result.status.Status == StatusEnum.Success)
{
transaction.data = result.result;
transaction.status = true;
}
else
{
// transaction.warnings.Add(result.status.StatusMessage);
transaction.status = false;
transaction.AddException(result.status.StatusMessage);
//_commonService.LogError(result.status.StatusCode, result.status.StatusMessage, result.status.StatusDetails, 0, "LoginCust");
}
}
catch (Exception ex)
{
transaction.status = false;
transaction.AddException(ex.Message);
ReturnCode = HttpStatusCode.InternalServerError;
result.status = _eHandler.HandleException(ex);
_commonService.LogError(result.status);
// transaction.AddException(ex.Message);
//ReturnCode = HttpStatusCode.InternalServerError;
//if (ex.InnerException != null) { InnerExceptionMessage = ex.InnerException.Message; }
//LogHelper.Instance.Error(CorrelationID, Username, Request.GetRequestContext().VirtualPathRoot, ex.Message, InnerExceptionMessage, 0, ex);
}
return(Request.CreateResponse <TranInfo <CityUserAccount_M> >(ReturnCode, transaction));
}
public ReturnResult <Log> InsertLog(Log Log)
{
DbProvider provider = new DbProvider();
var result = new ReturnResult <Log>();
string outCode = String.Empty;
string outMessage = String.Empty;
string totalRecords = String.Empty;
try
{
provider.SetQuery("LOG_CREATE", CommandType.StoredProcedure)
.SetParameter("VanBanId", SqlDbType.Int, Log.VanBanId, ParameterDirection.Input)
.SetParameter("Action", SqlDbType.NVarChar, Log.Action, 64, ParameterDirection.Input)
.SetParameter("CreatedDate", SqlDbType.DateTime, Log.CreatedDate, ParameterDirection.Input)
.SetParameter("CreatedBy", SqlDbType.Int, Log.CreatedBy, ParameterDirection.Input)
.SetParameter("IsDeleted", SqlDbType.Bit, Log.IsDeleted, ParameterDirection.Input)
.SetParameter("ErrorCode", SqlDbType.NVarChar, DBNull.Value, 100, ParameterDirection.Output)
.SetParameter("ErrorMessage", SqlDbType.NVarChar, DBNull.Value, 4000, ParameterDirection.Output)
.GetSingle <Log>(out Log).Complete();
provider.GetOutValue("ErrorCode", out outCode)
.GetOutValue("ErrorMessage", out outMessage);
if (outCode != "0" || outCode == "")
{
result.ErrorCode = outCode;
result.ErrorMessage = outMessage;
}
else
{
result.Item = Log;
result.ErrorCode = outCode;
result.ErrorMessage = outMessage;
}
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
public ReturnResult <Font> UpdateFont(Font font)
{
ReturnResult <Font> result;
DbProvider db;
try
{
result = new ReturnResult <Font>();
db = new DbProvider();
db.SetQuery("FONT_EDIT", CommandType.StoredProcedure)
.SetParameter("PhongID", SqlDbType.Int, font.FontID, ParameterDirection.Input)
.SetParameter("PhongSo", SqlDbType.NChar, font.FontNumber, 50, ParameterDirection.Input)
.SetParameter("CoQuanID", SqlDbType.Int, font.OrganID, ParameterDirection.Input)
.SetParameter("NgonNguID", SqlDbType.Int, font.LanguageId, ParameterDirection.Input)
.SetParameter("TenPhong", SqlDbType.NVarChar, font.FontName, 50, ParameterDirection.Input)
.SetParameter("CongCu", SqlDbType.NVarChar, font.LookupTools, 50, ParameterDirection.Input)
.SetParameter("LichSu", SqlDbType.NVarChar, font.History, 500, ParameterDirection.Input)
.SetParameter("NgonNgu", SqlDbType.NVarChar, font.Lang, 50, ParameterDirection.Input)
.SetParameter("NgayCapNhat", SqlDbType.NVarChar, font.UpdateTime.ToString(), 50, ParameterDirection.Input)
.SetParameter("GhiChu", SqlDbType.NVarChar, font.Note, 300, ParameterDirection.Input)
.SetParameter("ErrorCode", SqlDbType.NVarChar, DBNull.Value, 100, ParameterDirection.Output)
.SetParameter("ErrorMessage", SqlDbType.NVarChar, DBNull.Value, 4000, ParameterDirection.Output)
.ExcuteNonQuery()
.Complete();
db.GetOutValue("ErrorCode", out string errorCode)
.GetOutValue("ErrorMessage", out string errorMessage);
if (errorCode.ToString() == "0")
{
result.ErrorCode = "0";
result.ErrorMessage = "";
}
else
{
result.Failed(errorCode, errorMessage);
}
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
//检查是否是vip用户
public object Get(string cookie)
{
if (string.IsNullOrWhiteSpace(cookie))
{
return(ReturnResult.Return("1", "cookie错误", null, null));
}
else
{
ObjSessionModel obj = handle.AnalyzeCookie.Analyze(cookie);
if (obj == null)
{
return(ReturnResult.Return("1", "cookie错误", null, null));
}
else
{
return(handle.CheckAuthorization.Check(obj.userId));
}
}
}
public ReturnResult CancelMeeting(string meetingId)
{
ReturnResult returnResult = new ReturnResult();
try
{
Meeting meeting = _context.Meetings.Find(new Guid(meetingId));
meeting.IsCanceled = true;
_context.SaveChanges();
}
catch (Exception e)
{
returnResult.Result = false;
returnResult.Message = e.Message;
_logger.Error("Faild to cancel a Meeting", e);
return(returnResult);
}
returnResult.Result = true;
return(returnResult);
}
public ReturnResult <Account> EditPassword(Account account)
{
var result = new ReturnResult <Account>();
AccountService accountService = new AccountService();
if (accountService.IsAuthenticate(account))
{
var hasedPassword = accountService.CreateHashedPassword(account.Password);
// Assign a new hashed password to account
account.Password = hasedPassword;
result = AccountDAL.EditPassword(account);
}
else
{
result.ErrorCode = "1";
result.ErrorMessage = "Nhập sai mật khẩu hiện tại";
}
return(AccountDAL.EditPassword(account));
}
public ActionResult OnPublicKey(string data)
{
ReturnResult result = new ReturnResult();
try
{
string path = Server.MapPath("~/Upload");
byte[] token = Assembly.LoadFile(data)
.GetName()
.GetPublicKeyToken();
string content = BitConverter.ToString(token).Replace("-", "").ToLower();
result.data = content;
}
catch (Exception ex)
{
result.code = -1;
result.msg = ex.Message;
}
return(Json(result));
}
public async Task <ReturnResult <bool> > SaveUserInfo(UsersModel userInfo)
{
return(await Aspect.Task(async() =>
{
ReturnResult <bool> result = new ReturnResult <bool>();
result.data = await this.Update(userInfo);
if (result.data)
{
result.code = 1;
}
else
{
result.code = -103;
result.message = "用户信息更新失败！";
}
return result;
})
.WithLog("更新用户信息.")
.Execute());
}
public IActionResult Add(Client model)
{
var rst = new ReturnResult <bool>();
var bll = new ClientBll();
if (model.id == 0)
{
model.secret = Guid.NewGuid().ToString("N");
model.is_online = false;
model.create_time = DateTime.Now;
rst = bll.Add(model);
}
else
{
rst = bll.Update(model);
}
return(Json(rst));
}
public async Task <ReturnResult> AddArticleStock(List <ArticleStock> articleStocks)
{
ReturnResult result = new ReturnResult();
try
{
await _context.ArticleStocks.AddRangeAsync(articleStocks);
await _context.SaveChangesAsync();
result.StatusMessage = "New articles add successfully to the inventory";
return(result);
}
catch (Exception)
{
//statusMessage = e.Message;
//addedCustomer = null;
throw;
}
}
public ActionResult ErrorGuide(int ErrCode = -1)
{
ReturnResult result = new ReturnResult();
switch (ErrCode)
{
case 4901:
case 4902:
case 4903:
result.Error("인증토큰이 유효하지 않습니다.");
break;
default:
result.Error("알수없는 오류가 발생했습니다.");
break;
}
ViewBag.result = result;
return View(this);
}
public IActionResult GetAllCoQuan()
{
ReturnResult <CoQuan> result;
try
{
result = new ReturnResult <CoQuan>();
result = coQuanBUS.GetAllCoQuan();
return(Ok(new OrganList()
{
OrganTypes = result.ItemList.Select(item => item.OrganType).Distinct().ToList(),
OrganName = result.ItemList.Select(item => item.TenCoQuan).Distinct().ToList(),
OrganAddress = result.ItemList.Select(item => item.AddressDetail).Distinct().ToList()
}));
}
catch (Exception ex)
{
return(Unauthorized());
}
}
public async Task <ReturnResult <AdvertisementsModel> > GetAdvertisement(string key)
{
return(await Aspect.Task(async() =>
{
ReturnResult <AdvertisementsModel> result = new ReturnResult <AdvertisementsModel>();
Expression <Func <Advertisements, bool> > exp = x => x.key == key;
var adTemp = await this.FindOneAsync <AdvertisementsModel, Advertisements>(repository, exp);
if (adTemp == null || string.IsNullOrEmpty(adTemp.ID))
{
result.code = -104;
result.message = "未查询到广告数据。";
return result;
}
result.code = 1;
result.data = adTemp;
return result;
})
.WithLog("获取广告信息.")
.Execute());
}
public async Task <ReturnResult> AddKey([FromBody] CreateKey request)
{
if (int.Parse(request.SectionID) <= 0)
{
throw new AppException("栏目不能为空");
}
if (string.IsNullOrWhiteSpace(request.Name))
{
throw new AppException("名称不能为空");
}
int iUID = LoginManager.GetUserID();
var mapper = new MapperConfiguration(x => x.CreateMap <CreateKey, KeyContent>()).CreateMapper();
KeyContent keyContent = mapper.Map <KeyContent>(request);
keyContent.CreateUserID = iUID;
keyContent = await KeyManager.EncryptKey(keyContent);
return(ReturnResult.ResultCalculation(() => KeyContentManager.Insert(keyContent)));
}
public static ReturnResult <List <ModelField> > InsertBulk(IDatabase db, List <ModelField> modelFields)
{
var results = new ReturnResult <List <ModelField> >();
try
{
db.InsertBulk(modelFields);
results.Success = true;
results.Item = modelFields;
}
catch (Exception e)
{
results.Success = false;
results.ErrorMessage = "There was an error saving the model.";
results.Exception = e;
}
return(results);
}
public ReturnResult <bool> ResendPin(CustomerInfo message)
{
ReturnResult <string> result = new ReturnResult <string>();
ReturnResult <bool> resultFinal = new ReturnResult <bool>();
result = accDBHandler.ResendPin(message);
if (result != null)
{
EmailM emailMessage = new EmailM();
emailMessage.Subject = "RAP Security PIN";
emailMessage.MessageBody = NotificationMessage.ResourceManager.GetString("ResendPinMsg").Replace("PIN", result.result);
if (message.email != null)
{
emailMessage.RecipientAddress.Add(message.email);
}
EmailService emailservice = new EmailService();
resultFinal = emailservice.SendEmail(emailMessage);
}
return(resultFinal);
}
ReturnResult InsertLanguage(XmlNode lanNode)
{
List <string> lstParams = new List <string>();
lstParams.Add(App.GCurrentDBServer.DbType.ToString());
lstParams.Add(App.GCurrentDBServer.Host);
lstParams.Add(App.GCurrentDBServer.Port);
lstParams.Add(App.GCurrentDBServer.ServiceName);
lstParams.Add(App.GCurrentDBServer.LoginName);
lstParams.Add(App.GCurrentDBServer.Password);
//lstParams.Add(strImportLanguageType);
//从i=1开始 因为第一个childnode值是rownum 不需要导入数据库
for (int i = 1; i < lanNode.ChildNodes.Count; i++)
{
if (lanNode.ChildNodes[i].Name.ToUpper() == "DISPLAYMESSAGE" || lanNode.ChildNodes[i].Name.ToUpper() == "TIPMESSAGE")
{
if (lanNode.ChildNodes[i].InnerText.Length > 2048)
{
continue;
}
if (lanNode.ChildNodes[i].InnerText.Length > 1024)
{
lstParams.Add(lanNode.ChildNodes[i].InnerText.Substring(0, 1024));
lstParams.Add(lanNode.ChildNodes[i].InnerText.Substring(1025));
}
else
{
lstParams.Add(lanNode.ChildNodes[i].InnerText);
lstParams.Add("");
}
}
else
{
lstParams.Add(lanNode.ChildNodes[i].InnerText);
}
}
lstParams.Add(""); //InObject字段值 目前为空
ReturnResult Result = AboutLanguagesInServer.WCFOperationMthodA("HTTP", App.GCurrentUmpServer.Host, App.GCurrentUmpServer.Port, 5, lstParams);
return(Result);
}
void InstanceBackgroundWorkerImportOnlyRefresh_DoWork(object sender, DoWorkEventArgs e)
{
//删除一种类型的语言
List <string> lstParams = new List <string>();
lstParams.Add(App.GCurrentDBServer.DbType.ToString());
lstParams.Add(App.GCurrentDBServer.Host);
lstParams.Add(App.GCurrentDBServer.Port);
lstParams.Add(App.GCurrentDBServer.ServiceName);
lstParams.Add(App.GCurrentDBServer.LoginName);
lstParams.Add(App.GCurrentDBServer.Password);
lstParams.Add(strImportLanguageType);
RRemoveLanResult = AboutLanguagesInServer.WCFOperationMthodA("HTTP", App.GCurrentUmpServer.Host, App.GCurrentUmpServer.Port, 4, lstParams);
if (RRemoveLanResult.BoolReturn)
{
//开始写入数据库
ReturnResult InsertResult = null;
foreach (XmlNode node in IXMLNodeTableDataRowsList.ChildNodes)
{
if (node.ChildNodes.Count > 0)
{
InsertResult = InsertLanguage(node);
if (!InsertResult.BoolReturn)
{
bIsImportSuccess = false;
string strError = DateTime.Now + " | " + string.Format(this.TryFindResource("Error006").ToString(), node["C002"]);
List <string> lstErrors = new List <string>();
lstErrors.Add(strError);
strError = DateTime.Now + " | " + string.Format(this.TryFindResource("Error006").ToString(), InsertResult.StringReturn);
Logger.WriteLog(lstErrors);
}
}
}
}
else
{
InstanceBackgroundWorkerImportOnlyRefresh.Dispose(); InstanceBackgroundWorkerImportOnlyRefresh = null;
MessageBox.Show(RRemoveLanResult.StringReturn,
this.TryFindResource("ErrorMsgTitle").ToString(), MessageBoxButton.OK, MessageBoxImage.Error);
}
}
/// <summary>
/// 获取一条数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public ReturnResult <Admin> GetOne(Admin model)
{
var rst = new ReturnResult <Admin>();
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append(@"select t1.*,t2.Token from admin t1 ");
strSql.Append(@"inner join admin_token t2 on t1.Id = t2.AdminId ");
strSql.Append("where 1=1 ");
if (model != null)
{
if (model.Id != 0)
{
strSql.Append("and t1.Id = @Id ");
}
if (!string.IsNullOrEmpty(model.Token))
{
strSql.Append("and t2.Token = @Token ");
}
}
var query = conn.Query <Admin>(strSql.ToString(), model).FirstOrDefault();
if (query == null)
{
rst.Message = "数据不存在";
}
else
{
rst.Result = true;
rst.Data = query;
rst.Message = "查询成功";
}
}
catch (Exception ex)
{
rst.Message = "查询失败：" + ex.Message;
Log4netUtil.Error("AdminDal/GetOne", ex);
}
return(rst);
}
/// <summary>
/// 执行ExecuteNonQuery
/// </summary>
/// <param name="transaction">transaction</param>
/// <param name="commandType">Command type</param>
/// <param name="commandText">Command text</param>
/// <param name="oraParamsCollection">键值对的参数列表</param>
/// <returns>ID</returns>
public ReturnResult ExecuteNonQuery(OracleTransaction transaction, CommandType commandType, string commandText, List <OracleParameter> oraParamsCollection)
{
ReturnResult result = new ReturnResult();
OracleParameter orcleOutputParameter = null;
OracleCommand cmd = new OracleCommand();
try
{
PrepareCommand(cmd, transaction.Connection, transaction, commandType, commandText);
if (oraParamsCollection != null)
{
foreach (OracleParameter current in oraParamsCollection)
{
cmd.Parameters.Add(current);
if (current.Direction.Equals(ParameterDirection.Output))
{
orcleOutputParameter = current;
}
}
}
cmd.ExecuteNonQuery();
if (orcleOutputParameter == null)
{
result.Message = "OK";
result.Anything = "OK";
}
else
{
result.Message = "OK";
result.Anything = orcleOutputParameter.Value.ToString();
}
result.Status = true;
}
catch (Exception ex)
{
result.Message = "Execute:ExecuteNonQuery," + ex.Message;
result.Status = false;
logHandler.Error(MethodBase.GetCurrentMethod().Name + "Call ExecuteNonQuery Fail:" + ex.Message);
}
return(result);
}
// viết lại api cho profile từ đây
public ReturnResult <Profiles> ProfilesGetSearchWithPaging(BaseCondition <Profiles> condition)
{
ReturnResult <Profiles> result = new ReturnResult <Profiles>();
DbProvider db;
List <Profiles> lstResult;
try
{
db = new DbProvider();
lstResult = new List <Profiles>();
db.SetQuery("PROFILES_GET_SEARCH_WITH_PAGING", CommandType.StoredProcedure);
db.SetParameter("PageIndex", SqlDbType.Int, condition.PageIndex);
db.SetParameter("PageSize", SqlDbType.Int, condition.PageSize);
db.SetParameter("InWhere", SqlDbType.NVarChar, condition.IN_WHERE, 500);
db.SetParameter("InSort", SqlDbType.NVarChar, condition.IN_SORT, 200);
db.SetParameter("TotalRecords", SqlDbType.Int, DBNull.Value, ParameterDirection.Output);
db.SetParameter("ErrorCode", SqlDbType.Int, DBNull.Value, ParameterDirection.Output);
db.SetParameter("ErrorMessage", SqlDbType.NVarChar, DBNull.Value, 2000, ParameterDirection.Output);
db.GetList <Profiles>(out lstResult);
db.Complete();
db.GetOutValue("ErrorCode", out int errorCode)
.GetOutValue("ErrorMessage", out string errorMessage)
.GetOutValue("TotalRecords", out int totalRecords);
if (errorCode.ToString() != "0")
{
result.Failed(errorCode.ToString(), errorMessage);
}
else
{
result.ItemList = lstResult;
result.TotalRows = totalRecords;
result.ErrorCode = "0";
result.ErrorMessage = "";
}
}
catch (Exception ex)
{
result.Failed("-1", ex.Message);
}
return(result);
}
public ReturnResult <Skills> AddNewSkills(Skills Skills)
{
var result = new ReturnResult <Skills>();
DbProvider db = new DbProvider();
string outCode = String.Empty;
string outMessage = String.Empty;
string totalRecords = String.Empty;
try
{
// Set tên stored procedure
db.SetQuery("Skills_AddNew", CommandType.StoredProcedure)
.SetParameter("SkillName", SqlDbType.NVarChar, Skills.SkillName)
.SetParameter("Description", SqlDbType.NVarChar, Skills.Description)
.SetParameter("CreatedUser", SqlDbType.NVarChar, Skills.CreatedUser)
.SetParameter("Status", SqlDbType.TinyInt, Skills.Status)
.SetParameter("ErrorCode", SqlDbType.NVarChar, DBNull.Value, 100, ParameterDirection.Output)
.SetParameter("ErrorMessage", SqlDbType.NVarChar, DBNull.Value, 4000, ParameterDirection.Output)
.ExcuteNonQuery()
.Complete();
db.GetOutValue("ErrorCode", out outCode)
.GetOutValue("ErrorMessage", out outMessage);
if (outCode != "0" || outCode == "")
{
result.Failed(outCode, outMessage);
}
else
{
result.Item = Skills;
result.ErrorCode = "0";
result.ErrorMessage = "";
}
}
catch (Exception ex)
{
result.Failed("-1", ex.Message);
}
return(result);
}
public ReturnResult <User> Login(User model, Trans t = null)
{
var rst = new ReturnResult <User>()
{
Message = "用户名或密码错误"
};
try
{
conn = CreateMySqlConnection(t);
model.password = EncryptHelper.MD5Encrypt(model.password);
var sql = new StringBuilder("select * from user where password=@password ");
if (!string.IsNullOrEmpty(model.user_id))
{
sql.Append("and user_id=@user_id");
}
else if (!string.IsNullOrEmpty(model.user_name))
{
sql.Append("and user_name=@user_name");
}
else
{
rst.Status = 10005;
rst.Message = "信息已失效请刷新界面重新登录！";
return(rst);
}
rst.Data = conn.QueryFirstOrDefault <User>(sql.ToString(), model, t?.DbTrans);
if (rst.Data != null)
{
rst.Result = true;
rst.Message = "登录成功";
}
}
catch (Exception ex)
{
rst.Message = $"服务异常：{ex.InnerException ?? ex}";
Log4netUtil.Error($"{ex.InnerException ?? ex}");
}
return(rst);
}
/// <summary>
/// Lot重新生成时记录到ISSUE表
/// </summary>
/// <param name="lotEntityList"></param>
/// <returns></returns>
public ReturnResult InsertBatch_R_ISSUE_DESC_T(List<LotMoEntity> lotEntityList)
{
ReturnResult result = new ReturnResult();
List<KeyValuePair<string, List<OracleParameter>>> strSqlList = new List<KeyValuePair<string, List<OracleParameter>>>();
string strInsert = string.Format(@"INSERT INTO SFISM4.R_ISSUE_DESC_T
(CUSTOMER,
ISSUE_TYPE,
PN,
OCCUR_DESC)
VALUES
(:CUSTOMER,
:ISSUE_TYPE,
:PN,
:OCCUR_DESC)");
foreach (var entity in lotEntityList)
{
DBParameter dbParameter = new DBParameter();
dbParameter.Clear();
dbParameter.Add(":CUSTOMER", OracleDbType.Varchar2, "PPM_LOT");
dbParameter.Add(":ISSUE_TYPE", OracleDbType.Varchar2, "LOTREBUILDER");
dbParameter.Add(":PN", OracleDbType.Varchar2, entity.MO_ORDER);
dbParameter.Add(":OCCUR_DESC", OracleDbType.Varchar2, entity.LOT_NO);
strSqlList.Add(new KeyValuePair<string, List<OracleParameter>>(strInsert, dbParameter.GetParameters()));
}
try
{
result = dbHander.ExecuteNonQueryBatchSql(strSqlList);
result.Status = true;
}
catch (Exception ex)
{
result.Status = false;
result.Message = ex.Message;
this.logHandler.Error(MethodBase.GetCurrentMethod().Name, "Call InsertBatch_R_ISSUE_DESC_T Fail: " + ex.Message);
}
return result;
}
/// <summary>
/// 添加客户请求处理接口
/// </summary>
/// <returns></returns>
public async Task <ReturnResult> AddCustomerAsync(CustomerParamater parameter)
{
ReturnResult result = new ReturnResult();
var customer = Mapper.Map <Customer>(parameter);
//根据openId验证客户是否存在
var oldCustomer = await GetCustomerEntityByOpenIdAsync(customer.Openid);
if (oldCustomer != null)
{
customer.Id = oldCustomer.Id;
context.Customers.Update(oldCustomer);
}
else
{
await context.Customers.AddAsync(customer);
}
await context.SaveChangesAsync();
result.Id = customer.Id;
return(result);
}
public async Task <IActionResult> Register(string Username, string Password, string Email)
{
ReturnResult <object> model = new ReturnResult <object>();
if (string.IsNullOrEmpty(Username) || string.IsNullOrEmpty(Password) || string.IsNullOrEmpty(Email))
{
model.Status = "ok";
model.ReturnMsg = "输入的信息不能为空";
}
User user = new User();
user.Email = Email;
user.Password = Password;
user.UserName = Username;
await userService.Save(user);
model.Status = "ok";
model.Message = "注册成功";
return(Json(model));
}
public async Task <ReturnResult> DeleteCar(Guid id)
{
ReturnResult ReturnResult = new ReturnResult();
ReturnResult.Action = "Delete car";
Car Car = await CarRepository.ReadAsync(id);
if (Car == null)
{
ReturnResult.Inconsistencies.Add(
"Carro não encontrado");
}
else
{
await CarRepository.DeleteAsync(id);
await CarRepository.SaveChangesAsync();
}
return(ReturnResult);
}
/// <summary>
/// 检查Excel文件的字段是否包含了必须的字段
/// </summary>
/// <param name="guid">附件的GUID</param>
/// <returns></returns>
public ActionResult CheckExcelColumns(string guid)
{
ReturnResult result = new ReturnResult();
try
{
DataTable dt = ConvertExcelFileToTable(guid);
if (dt != null)
{
//检查列表是否包含必须的字段
result.ErrorCode = DataTableHelper.ContainAllColumns(dt, columnString)?0:1;
}
}
catch (Exception ex)
{
LogHelper.WriteLog(LogLevel.LOG_LEVEL_CRIT, ex, typeof(LoginLogController));
result.ErrorMessage = ex.Message;
}
return(ToJsonContent(result));
}
public JsonResult RemoveChannel(int ChannelID)
{
ReturnResult result = new ReturnResult();
this.LoginCheck();
using (var context = new SharedPlayerContext())
{
Channel channel = context.Channels.Where(x => x.ChannelID == ChannelID).FirstOrDefault();
if (channel != null && channel.ChannelID > 0)
{
if (channel.CreateMemberID == this.LoginMember.MemberID)
{
List<Music> music = context.Musics.Where(x => x.ChannelID == ChannelID).ToList();
if (music != null && music.Count > 0)
{
foreach (Music item in music)
{
context.Musics.Remove(item);
}
}
context.Channels.Remove(channel);
context.SaveChanges();
result.Success();
}
else
{
result.Error("채널을 삭제할 권한이 없습니다.");
}
}
else
{
result.Error("채널이 존재하지 않습니다.");
}
}
return Json(result);
}
//查詢VIEW欄位
public JsonResult ChangeTableDataJson(string select, string view, string where, string orderby, string iseasyquery, string strquery)
{
ReturnResult ReturnResult = new ReturnResult();
ReturnDBResult ReturnDBResult = new ReturnDBResult();
ReturnDBResult = ViewQueryLog(select, view, where, orderby, iseasyquery, strquery);
ReturnResult.ReturnMsgNo = Convert.ToString(ReturnDBResult.ReturnMsgNo);
ReturnResult.ReturnMsg = ReturnDBResult.ReturnMsg;
//描述
ReturnDBResult ReturnDBResultNote = new ReturnDBResult();
ReturnDBResultNote = ViewQueryNote(view);
//string ColumnName = "";
StringBuilder JsonString = new StringBuilder();
if (ReturnDBResult.ReturnDS.Tables.Count > 0)
{
if (ReturnDBResult.ReturnDS.Tables[0].Columns.Count > 0)
{
JsonString.Append("[");
for (int i = 0; i < ReturnDBResult.ReturnDS.Tables[0].Columns.Count; i++)
{
if (i == 0)
JsonString.Append("{");//JsonString.Append("{");
else
JsonString.Append(",{");//JsonString.Append(",{");
string Temp = "";
if (ReturnDBResultNote.ReturnDS.Tables.Count > 0 )
{
if (ReturnDBResultNote.ReturnDS.Tables[0].Rows.Count > 0 )
{
for (int j = 0; j < ReturnDBResultNote.ReturnDS.Tables[0].Rows.Count; j++)
{
if (Convert.ToString(ReturnDBResultNote.ReturnDS.Tables[0].Rows[j]["objname"]) == Convert.ToString(ReturnDBResult.ReturnDS.Tables[0].Columns[i].ColumnName))
{
Temp = Convert.ToString(ReturnDBResultNote.ReturnDS.Tables[0].Rows[j]["value"]);
break;
}
}
}
}
JsonString.Append("\"ColumnName\":\"" + ReturnDBResult.ReturnDS.Tables[0].Columns[i].ColumnName + "\",\"ColumnNameNote\":\"" + Temp + "\""); //'ColumnName':
JsonString.Append("}");
}
JsonString.Append("]");
}
}
ReturnResult.ReturnTB = JsonString.ToString();
return Json(ReturnResult, JsonRequestBehavior.AllowGet);
}
public JsonResult RemoveMusic(long MusicID)
{
ReturnResult result = new ReturnResult();
this.LoginCheck();
using (var context = new SharedPlayerContext())
{
Music music = context.Musics.Where(x => x.MusicID == MusicID).FirstOrDefault();
if (music != null && music.MusicID > 0)
{
Channel channel = context.Channels.Where(x => x.ChannelID == music.ChannelID).FirstOrDefault();
if (channel != null)
{
if (channel.CreateMemberID == this.LoginMember.MemberID || music.MemberID == this.LoginMember.MemberID)
{
context.Musics.Remove(music);
context.SaveChanges();
result.Success();
}
else
{
result.Error("삭제할 권한이 없습니다.");
}
}
else
{
result.Error("소속 채널에 오류가 있습니다.");
}
}
else
{
result.Error("대상을 찾을 수 없습니다.");
}
}
return Json(result);
}
public JsonResult RecommendProc(int MusicID)
{
ReturnResult result = new ReturnResult();
this.LoginCheck();
using (var context = new SharedPlayerContext())
{
Music music = context.Musics.Where(x => x.MusicID == MusicID).FirstOrDefault();
if (music != null && music.MusicID > 0)
{
music.RecommendCount = music.RecommendCount + 1;
context.SaveChanges();
result.Success();
}
else
{
result.Error("대상을 찾을 수 없습니다.");
}
}
return Json(result);
}
public JsonResult RemoveFavorite(int ChannelID)
{
ReturnResult result = new ReturnResult();
this.LoginCheck();
using (var context = new SharedPlayerContext())
{
Channel channel = context.Channels.Where(x => x.ChannelID == ChannelID).FirstOrDefault();
if (channel != null && channel.ChannelID > 0)
{
Favorite favo = context.Favorites.Where(x => x.MemberID == this.LoginMember.MemberID).Where(x => x.ChannelID == ChannelID).FirstOrDefault();
if (favo != null && favo.FavoriteID > 0)
{
context.Favorites.Remove(favo);
context.SaveChanges();
result.Success();
}
else
{
result.Fail("대상을 찾을 수 없습니다.");
}
}
else
{
result.Fail("대상을 찾을 수 없습니다.");
}
}
return Json(result);
}
public ReturnResult CheckUserAccount(string UserAccount, string UserPassWord)
{
ReturnResult ReturnResult = new ReturnResult();
if (MyCardQueryLog.Properties.Settings.Default.IsTest.ToUpper() == "FALSE") {
if (MyCardQueryLog.Properties.Settings.Default.In34.ToUpper() == "FALSE")
{
MyCardQueryLogWS.Service1Client MyCardQueryLogWS = new MyCardQueryLogWS.Service1Client();
MyCardQueryLogWS.ReturnResult MyCardQueryLogWSRe = new MyCardQueryLogWS.ReturnResult();
InValue = "CheckUserAccount";
try
{
MyCardQueryLogWSRe = MyCardQueryLogWS.CheckUserAccount(UserAccount.Trim(), UserPassWord.Trim());
ReturnResult.ReturnMsgNo = Convert.ToString(MyCardQueryLogWSRe.ReturnMsgNo);
ReturnResult.ReturnMsg = MyCardQueryLogWSRe.ReturnMsg;
}
catch (Exception ex)
{
OutValue = "|回應|" + "Exception|" + ex.ToString();
ErrorLog(InValue + OutValue);
ReturnResult.ReturnMsgNo = "-99";
ReturnResult.ReturnMsg = "系統發生錯誤";
}
}
else
{
switch (UserAccount.Trim().ToUpper())
{
case "RDONCALLUSER":
if (UserPassWord.Trim() == "sw27889188!")
{
ReturnResult.ReturnMsgNo = "1";
ReturnResult.ReturnMsg = "成功";
}
else
{
ReturnResult.ReturnMsgNo = "-2";
ReturnResult.ReturnMsg = "輸入密碼錯誤";
}
break;
case "DBONCALLUSER":
if (UserPassWord.Trim() == "abc123~")
{
ReturnResult.ReturnMsgNo = "1";
ReturnResult.ReturnMsg = "成功";
}
else
{
ReturnResult.ReturnMsgNo = "-2";
ReturnResult.ReturnMsg = "輸入密碼錯誤";
}
break;
case "MISONCALLUSER":
if (UserPassWord.Trim() == "abc123~")
{
ReturnResult.ReturnMsgNo = "1";
ReturnResult.ReturnMsg = "成功";
}
else
{
ReturnResult.ReturnMsgNo = "-2";
ReturnResult.ReturnMsg = "輸入密碼錯誤";
}
break;
default:
ReturnResult.ReturnMsgNo = "-1";
ReturnResult.ReturnMsg = "無帳號";
break;
}
}
}
else
{
switch (UserAccount.Trim().ToUpper())
{
case "RDONCALLUSER":
if (UserPassWord.Trim().ToUpper() == "SW27889188!")
{
ReturnResult.ReturnMsgNo = "1";
ReturnResult.ReturnMsg = "成功";
}
else
{
ReturnResult.ReturnMsgNo = "-2";
ReturnResult.ReturnMsg = "輸入密碼錯誤";
}
break;
case "DBONCALLUSER":
if (UserPassWord.Trim().ToUpper() == "ABC123~")
{
ReturnResult.ReturnMsgNo = "1";
ReturnResult.ReturnMsg = "成功";
}
else
{
ReturnResult.ReturnMsgNo = "-2";
ReturnResult.ReturnMsg = "輸入密碼錯誤";
}
break;
case "MISONCALLUSER":
if (UserPassWord.Trim().ToUpper() == "ABC123~")
{
ReturnResult.ReturnMsgNo = "1";
ReturnResult.ReturnMsg = "成功";
}
else
{
ReturnResult.ReturnMsgNo = "-2";
ReturnResult.ReturnMsg = "輸入密碼錯誤";
}
break;
default:
ReturnResult.ReturnMsgNo = "-1";
ReturnResult.ReturnMsg = "無帳號";
break;
}
}
return ReturnResult;
}
public FileSearcher(string dataPattern, int bufferSize, EndTest endTest, GetCount getCount, ReturnResult returnResult, GetFirstFileInfo getFirstFileInfo)
{
this.dataPattern = dataPattern.ToLower();
this.bufferSize = bufferSize;
this.endTest = endTest;
this.getCount = getCount;
this.returnResult = returnResult;
this.getFirstFileInfo = getFirstFileInfo;
}
public CommonModule(IPdfTemplateHelper pdfTemplateHelper, IEmailer emailer,
IPdfBarcodesGenerator pdfBarcodesGenerator) : base("/api")
{
_pdfTemplateHelper = pdfTemplateHelper;
_emailer = emailer;
_pdfBarcodesGenerator = pdfBarcodesGenerator;
// BARCODE FUNCTIONS
// Returns a list of airports
Get["/getAirports"] = _ =>
{
var airportList = CustomerSite.ToList().Where(x => x.IsAirport).ToList().OrderBy(x => x.Name);
return Response.AsJson(airportList.ToList());
};
// Returns a list of airports that have been formatted for a select input
Get["/getAirportList"] = _ =>
{
var airports = CustomerSite.ToList().Where(x => x.IsAirport).ToList();
List<SelectList> airportList = new List<SelectList>();
foreach(var airport in airports)
{
airportList.Add(new SelectList(){
id = airport.RecordID,
text = airport.Name.Trim()
});
}
return Response.AsJson(airportList.OrderBy(x => x.text).ToList());
};
// Returns all available pdf templates
Get["/getPdfTemplates"] = _ => Response.AsJson(_pdfTemplateHelper.GetTemplates());
// Returna a list of Airlines
Get["/getAirlines"] = _ =>
{
var airlineList = AirlineDBO.ToList().OrderBy(x => x.Name);
return Response.AsJson(airlineList.ToList());
};
// Returns a list of Airlines that have been formatted for a select input
Get["/getAirlineList"] = _ =>
{
var airlines = AirlineDBO.ToList();
List<SelectList> airlineList = new List<SelectList>();
foreach(var airline in airlines)
{
airlineList.Add(new SelectList()
{
id = airline.RecordID,
text = airline.Name.Trim()
});
}
return Response.AsJson(airlineList.OrderBy(x => x.text).ToList());
};
// Returns a list of barcodes
Post["/getBarcodes/{type}"] = _ =>
{
BarcodeWhere where = this.Bind<BarcodeWhere>();
DateTime start = new DateTime();
DateTime end = new DateTime();
bool validStart = DateTime.TryParse(where.StartDate, out start);
bool validEnd = DateTime.TryParse(where.EndDate, out end);
// If no dates were provided, this gets all.
if(!validStart && !validEnd)
{
var barcodeList = BarcodeCreation.ToListDTO();
return Response.AsJson(barcodeList.OrderByDescending(x => x.CreatedDateTime).ToList());
}
// If one of the dates isn't valid, this returns.
else if(!validStart || !validEnd)
{
return HttpStatusCode.BadRequest;
}
// Otherwise this returns the filtered results
else
{
var barcodeList = BarcodeCreation.ToListDTO(start, end);
return Response.AsJson(barcodeList.OrderByDescending(x => x.CreatedDateTime).ToList());
}
};
// Returns all the details of a barcode - BarcodeCreation, FastTrackBarcode, FastTrackBarcode.Actions
Get["/getBarcode/{type}/{recordID}"] = _ =>
{
Guid recordID;
bool validGuid = Guid.TryParse(_.recordID, out recordID);
// If an invalid Guid was provided, return bad request
if (!validGuid)
{
return HttpStatusCode.BadRequest;
}
var barcode = BarcodeCreation.Load(recordID);
return Response.AsJson(barcode);
};
// Returns a list of barcode actions
Get["/getBarcodeActions/{type}/{recordID}"] = _ =>
{
Guid recordGUID;
bool validGuid = Guid.TryParse(_.recordID, out recordGUID);
if (!validGuid)
{
return HttpStatusCode.BadRequest;
}
var fastTrackActions = FastTrackBarcode.Actions(recordGUID);
return Response.AsJson(fastTrackActions);
};
// For creating a barcode
Post["/createBarcode/{type}/{format}"] = _ =>
{
string type = _.type;
string format = _.format;
// If departure airport, copy to guid field and then replace with iata
IBarcodeGenerator barcodeGenerator = null;
FastTrackOptions barcodeOptions = new FastTrackOptions
{
Quantity = 1
};
Guid temp = new Guid();
// Generate barcode
switch (type)
{
case "fasttrack":
barcodeGenerator =
new AddbarcodeCreationRecordToDb(new SaveFastTrackBarcodeRecordToDb(new BarcodeGenerator()));
barcodeOptions = this.Bind<FastTrackOptions>();
// If airline, copy to guid field and then replace with iata, unless it is ---
if (!string.IsNullOrWhiteSpace(barcodeOptions.Airline) && barcodeOptions.Airline.Trim() != "---")
{
if(Guid.TryParse(barcodeOptions.Airline, out temp))
{
Airline airline = Airline.Load(temp);
// If no airline was found, empty airline fields
if(airline == null)
{
barcodeOptions.Airline = "---";
barcodeOptions.AirlineGuid = null;
}
// Otherwise update fields
else
{
barcodeOptions.Airline = airline.AirlineIATA;
barcodeOptions.AirlineGuid = temp;
}
}
}
// If departure airport, copy to guid field and then replace with iata
if (!string.IsNullOrWhiteSpace(barcodeOptions.DepartureAirport))
{
if(Guid.TryParse(barcodeOptions.DepartureAirport, out temp))
{
CustomerSite site = CustomerSite.Load(temp);
// If no airport was found, that means it doesn't exist, so empties departure fields
if(site == null)
{
barcodeOptions.DepartureAirport = null;
barcodeOptions.DepartureAirportGuid = null;
}
// Otherwise update fields
else
{
barcodeOptions.DepartureAirportGuid = temp;
barcodeOptions.DepartureAirport = site.AirportIATADesignation;
}
}
}
// If destination airport, copy to guid field and then replace with iata
if (!string.IsNullOrWhiteSpace(barcodeOptions.DestinationAirport))
{
if (Guid.TryParse(barcodeOptions.DestinationAirport, out temp))
{
// If the same as departure, just copy name
if(barcodeOptions.DepartureAirport == barcodeOptions.DestinationAirport)
{
barcodeOptions.DestinationAirport = barcodeOptions.DepartureAirport;
barcodeOptions.DestinationAirportGuid = barcodeOptions.DepartureAirportGuid;
}
// Otherwise load airport details
else
{
CustomerSite site = CustomerSite.Load(temp);
// If no airport was found, that means it doesn't exist, so empties departure fields
if (site == null)
{
barcodeOptions.DestinationAirport = null;
barcodeOptions.DestinationAirportGuid = null;
}
// Otherwise update fields
else
{
barcodeOptions.DestinationAirportGuid = temp;
barcodeOptions.DestinationAirport = site.AirportIATADesignation;
}
}
}
}
break;
case "test":
barcodeGenerator = new TestBarcodeGenerator();
break;
default:
return HttpStatusCode.BadRequest;
}
switch (format)
{
case "image":
List<string> returnText = new List<string>();
IBarcodeFileGenerator imageGenerator = new BarcodeImageFileGenerator(barcodeGenerator);
for (var i = 0; i < barcodeOptions.Quantity; i++)
{
returnText.Add(Convert.ToBase64String(imageGenerator.GenerateFile(barcodeOptions).ToArray()));
}
return Response.AsJson(returnText);
//break;
case "email":
var result = new EmailFastTrackBarcodes(_emailer).EmailBarcodeFile(barcodeOptions,
new BarcodePdfFileGenerator(barcodeGenerator, _pdfBarcodesGenerator));
return result ? HttpStatusCode.Accepted : HttpStatusCode.BadRequest;
case "pdf":
var stream =
new BarcodePdfFileGenerator(barcodeGenerator, _pdfBarcodesGenerator).GenerateFile(barcodeOptions);
var streamClone = new MemoryStream(stream.ToArray());
Response response = new Response();
response.Headers.Add("Content-Disposition",
"attachment; filename=GeneratedBarcode" + DateTime.Now.ToString("dd MMM yyyy HH mm") + ".pdf");
response.Headers.Add("responseType", "arraybuffer");
response.Contents = responseStream =>
{
streamClone.CopyTo(responseStream);
};
return response;
}
// Return BadRequest if not returned already
return HttpStatusCode.BadRequest;
};
// Exports all the barcodes
Post["/exportBarcodes/{type}"] = _ =>
{
List<string> barcodeGuids = this.BindTo(new List<string>());
// If no guids were posted, export all
if (barcodeGuids.Count() == 0)
{
return CSVExporter.ExportBarcodes();
}
// Otherwise export select few
else
{
return CSVExporter.ExportBarcodes(barcodeGuids);
}
};
// logs the user in using sems data object
Post["/login/{type}"] = _ =>
{
//bind to object model
var loginParams = this.Bind<Login>();
//decrypt username
loginParams.Username = Decrypt.DecryptString(loginParams.Username, _.type + "key");
//pass sems data obejct user method the username
var user = User.LoadUser(loginParams.Username);
//if no user, return 401
if (user == null)
{
Console.WriteLine("No User");
return HttpStatusCode.Unauthorized;
}
//decrypt password
loginParams.Password = Decrypt.DecryptString(loginParams.Password, _.type + "key");
//if incorrect password, return 401
if (user.Password != loginParams.Password)
{
Console.WriteLine("Wrong Password");
return HttpStatusCode.Unauthorized;
}
var token = user.RecordID;
//login but dont redirect, this is handled front end by angular
return this.LoginWithoutRedirect(token);
};
// logs the user in using sems data object
Post["/login"] = _ =>
{
//bind to object model
var loginParams = this.Bind<Login>();
//pass sems data obejct user method the username
var user = MachSecure.SEMS.DataObjects.User.LoadUser(loginParams.Username);
//if no user, return 401
if (user == null)
{
Console.WriteLine("Wrong Username");
return HttpStatusCode.Unauthorized;
}
//if incorrect password, return 401
if (user.Password != loginParams.Password)
{
Console.WriteLine("Wrong Password");
return HttpStatusCode.Unauthorized;
}
var token = user.RecordID;
//login but dont redirect, this is handled front end by angular
return this.LoginWithoutRedirect(token);
};
// log the user out and redirect to home
Get["/logout"] = _ => this.LogoutAndRedirect("../#/");
// Gets the current logged in user
Get["/user"] = _ =>
{
var user = Context.CurrentUser;
return Response.AsJson(user);
};
// Tests connection
Get["/test"] = _ =>
{
List<string> s = new List<string>();
//SMTP.SendEmail("*****@*****.**", "Test Email", "This is a test e-mail");
for (int i = 0; i < 1000000; i++)
{
s.Add("test");
}
return Response.AsJson(s);
};
// /BARCODE ACTIONS
// ROSTER IMPORT FUNCTIONS
// Returns contents of a csv file
Post["/readCSV"] = _ =>
{
ReadCsvOptions options = this.Bind<ReadCsvOptions>();
ReturnResult result = new ReturnResult();
var files = Request.Files;
// If no file, return
if(files.Count() == 0)
{
result.Success = false;
result.Error = "No file found";
result.ErrorDescription = "No CSV file was uploaded";
result.Result = null;
return Response.AsJson(result);
}
List<CsvObject> csvs = new List<CsvObject>();
foreach (var file in files)
{
string extension = Path.GetExtension(file.Name);
// If not a csv file, return
if(extension != ".csv")
{
result.Success = false;
result.Error = "Invalid file";
result.ErrorDescription = file.Name + " is not a csv file";
result.Result = null;
return Response.AsJson(result);
}
StreamReader csvReader = new StreamReader(file.Value);
CsvObject csv = new CsvObject();
List<string[]> rows = new List<string[]>();
int index = 0;
bool escape = false;
while (!csvReader.EndOfStream && escape != true)
{
string line = csvReader.ReadLine();
string[] values = line.Split(',');
// If headers, place into headers string[]
if (index == 0)
{
csv.Headers = values;
}
else
{
rows.Add(values);
}
index++;
// If there is a limit, and this exceeds it, this sets escape to true
if (options.Limit != null && options.Limit > 0 && index > options.Limit)
{
escape = true;
}
}
csv.Rows = rows;
csvs.Add(csv);
}
// To get this far, it was successful, so it returns so
result.Success = true;
result.Error = null;
result.ErrorDescription = null;
result.Result = csvs;
return Response.AsJson(result);
};
// /ROSTER IMPORT FUNCTIONS
}
//資料查詢
public JsonResult IndexDataJson(string select, string view, string where, string orderby, string iseasyquery, string strquery)
{
ReturnResult ReturnResult = new ReturnResult();
ReturnDBResult ReturnDBResult = new ReturnDBResult();
if (NeedSn(view, where))
{
ReturnResult.ReturnMsgNo = "MQLD0001";
ReturnResult.ReturnMsg = "此查詢必須要有SN";
return Json(ReturnResult, JsonRequestBehavior.AllowGet);
}
ReturnDBResult = ViewQueryLog(select, view, where, orderby, iseasyquery, strquery);
ReturnResult.ReturnMsgNo = Convert.ToString(ReturnDBResult.ReturnMsgNo);
ReturnResult.ReturnMsg = ReturnDBResult.ReturnMsg;
ReturnResult.ReturnTB = ReturnTB(ReturnDBResult);
return Json(ReturnResult, JsonRequestBehavior.AllowGet);
}
