public OptResult Login(string username, string pwd) { OptResult rst = null; if (string.IsNullOrEmpty(username) || string.IsNullOrEmpty(pwd)) { rst = OptResult.Build(ResultCode.ParamError, Msg_Login + "失败,用户名或密码不能为空"); return(rst); } //用户名 var where = Predicates.Field <User>(u => u.user_name, Operator.Eq, username); var usr = _usrRep.GetList(where).FirstOrDefault(); if (usr == null) { rst = OptResult.Build(ResultCode.Fail, Msg_Login + "失败,用户不存在"); return(rst); } //密码 var pwdHash = EncryptionExtension.GetMd5Hash(pwd); if (string.Equals(pwdHash, usr.user_pwd)) { rst = OptResult.Build(ResultCode.Success, null, usr); } else { rst = OptResult.Build(ResultCode.Fail, Msg_Login + "失败,密码不正确"); } return(rst); }
public OptResult CheckUpgrade(string appid, string v2) { OptResult rst = null; var app = _apps.Where(a => a.appid == appid).FirstOrDefault(); if (app == null) { rst = OptResult.Build(ResultCode.ParamError, Msg_CheckUpgrade + ",未识别的appid!"); return(rst); } Version _v2 = null;//客户端传递来的版本 if (!Version.TryParse(v2, out _v2)) { rst = OptResult.Build(ResultCode.ParamError, Msg_CheckUpgrade + ",非法版本格式!"); return(rst); } Version _v1 = null;//服务端设置的最新客户端版本 if (!Version.TryParse(app.version, out _v1)) { rst = OptResult.Build(ResultCode.ParamError, Msg_CheckUpgrade + ",非法版本格式!"); return(rst); } if (_v1 > _v2) { //有新版本 rst = OptResult.Build(ResultCode.NewVersion, Msg_CheckUpgrade + ",有新版本", new { version = app.version }); return(rst); } rst = OptResult.Build(ResultCode.NewestVersion, Msg_CheckUpgrade + ",当前已是最新版本"); return(rst); }
/// <summary> /// 调用商城接口——修改手机号 /// </summary> /// <param name="idcard"></param> /// <param name="phone"></param> /// <returns></returns> public OptResult ChangePhone(string idcard, string phone) { OptResult rst; string msg = string.Empty; var apiUrl = GetMallApiUrl(Key_Api_ChangePhone, ref msg); if (string.IsNullOrEmpty(apiUrl)) { rst = OptResult.Build(ResultCode.Fail, Msg_ChangePhone + "失败," + msg); return(rst); } //调用商城接口:修改手机号 try { rst = HttpUtils.PostResult(apiUrl, new { idcard = idcard, phone = phone }); } catch (Exception ex) { LogHelper.LogError(Msg_ChangePhone, ex); rst = OptResult.Build(ResultCode.Fail, Msg_ChangePhone + "失败," + ex.Message); } return(rst); }
public OptResult reloadProperty() { OptResult result = new OptResult(true); props.Clear(); try { xmlDoc = new XmlDocument(); xmlDoc.Load(fileName); XmlNodeList nodeList = xmlDoc.SelectNodes("//property"); foreach (XmlElement node in nodeList) { if (node.GetAttribute("type") == null || !node.GetAttribute("type").Equals("list")) { props.Add(node.GetAttribute("id"), node.InnerText.Trim()); } } } catch (Exception er) { result.result = false; result.info = er.ToString(); } return(result); }
public OptResult Init(IEnumerable <Field> fields) { OptResult rst = null; if (fields.IsEmpty()) { rst = OptResult.Build(ResultCode.ParamError, string.Format("{0},参数不能为空!", Msg_InitFields)); return(rst); } //1、预处理——字段名 var tables = _tableRep.GetList(Predicates.Field <Table>(t => t.id, Operator.Eq, fields.Select(f => f.tbid).Distinct())); rst = ProcessFieldName(fields, tables); if (rst.code != ResultCode.Success) { return(rst); } //2、清空当前查询字段后,保存 var tran = _fieldRep.Begin(); try { _fieldRep.Delete(Predicates.Field <Field>(f => f.id, Operator.Eq, null, true), tran); _fieldRep.InsertBatch(fields, tran); _fieldRep.Commit(); rst = OptResult.Build(ResultCode.Success, Msg_InitFields); } catch (Exception ex) { LogHelper.LogError(Msg_InitFields, ex); rst = OptResult.Build(ResultCode.DbError, Msg_InitFields); } return(rst); }
public OptResult GetList() { OptResult rst = null; //排序 IList <ISort> sort = new[] { new Sort { PropertyName = "type_code", Ascending = true } }; try { var types = _dictTypeRep.GetList(null, sort); rst = OptResult.Build(ResultCode.Success, null, new { rows = types }); } catch (Exception ex) { LogHelper.LogError(Msg_GetList, ex); rst = OptResult.Build(ResultCode.DbError, Msg_GetList); } return(rst); }
public OptResult Refund(RefundViewModel vmRefund) { OptResult rst = null; if (vmRefund == null) { rst = OptResult.Build(ResultCode.ParamError, "参数不能为空"); return(rst); } if (ModelState.IsValid == false) { rst = OptResult.Build(ResultCode.ParamError, ModelState.Parse()); return(rst); } var token = base.ParseToken(ActionContext); if (string.IsNullOrEmpty(vmRefund.opt)) { vmRefund.opt = token.iss; } var refundEntity = OOMapper.Map <RefundViewModel, RefundEntity>(vmRefund); rst = _cardMoneySrv.Refound(refundEntity); return(rst); }
public OptResult Delete(dynamic pkId) { OptResult rst = null; //1、字典数据是否存在 var predicate = Predicates.Field <Dict>(t => t.dict_id, Operator.Eq, pkId as object); var dict = _dictRep.GetList(predicate).FirstOrDefault(); if (dict == null) { rst = OptResult.Build(ResultCode.DataNotFound, Msg_Delete); return(rst); } //2、是否已被引用,暂不实现(可以在一张中间表保存依赖关系?) //TODO //3、是否系统预制 if (dict.dict_system) { rst = OptResult.Build(ResultCode.DataSystem, Msg_Delete + ",不能删除系统预制字典数据!"); return(rst); } //4、删除 try { bool val = _dictRep.Delete(predicate); rst = OptResult.Build(val ? ResultCode.Success : ResultCode.Fail, Msg_Delete); } catch (Exception ex) { LogHelper.LogError(Msg_Delete, ex); rst = OptResult.Build(ResultCode.DbError, Msg_Delete); } return(rst); }
public void delWord(String id) { TransDataModel rmData = new TransDataModel(); foreach (TransDataModel data in gridData) { if (data.id.Equals(id)) { rmData = data; break; } } OptResult r = translator.delWordFromDict(id); if (r.result == true) { gridData.Remove(rmData); dataGrid.ItemsSource = null; dataGrid.ItemsSource = gridData; } else { new Alert(r.info, this).ShowDialog(); } }
public OptResult Login(LoginVM vmLogin) { OptResult rst = null; if (vmLogin == null) { rst = OptResult.Build(ResultCode.ParamError, "参数不能为空"); return(rst); } rst = _usrSrv.Login(vmLogin.username, vmLogin.pwd); if (rst.code == ResultCode.Success) { //生成JWT var payload = new TokenData { iss = rst.data.user_id, iat = (int)(DateTime.UtcNow - DateTimeExtension.GetMinUtcTime()).TotalSeconds }; string token = JWT.JsonWebToken.Encode(payload, ApiContext.JwtSecretKey, JWT.JwtHashAlgorithm.HS256); rst = OptResult.Build(ResultCode.Success, "用户登录成功,并已生成token", new { token = token, usrid = rst.data.user_id }); } return(rst); }
public OptResult GetAccountByIdcard(string idcard) { OptResult rst = null; if (idcard.IsEmpty()) { rst = OptResult.Build(ResultCode.ParamError, Msg_GetAccountByIdcard + ",身份证号不能为空!"); return(rst); } try { var account = _acntRep.GetList(Predicates.Field <CardAccount>(a => a.idcard, Operator.Eq, idcard)); if (account.IsEmpty()) { rst = OptResult.Build(ResultCode.DataNotFound); return(rst); } rst = OptResult.Build(ResultCode.Success, Msg_GetAccountByIdcard, account.First()); } catch (Exception ex) { LogHelper.LogError(Msg_GetAccountByIdcard, ex); rst = OptResult.Build(ResultCode.DbError, Msg_GetAccountByIdcard); } return(rst); }
public OptResult searchByID(String id, LanguageEnum to) { OptResult result = new OptResult(true); try { XmlNode node = xmlDoc.SelectSingleNode("//group[@id='" + id + "']"); if (node != null) { result.info = node.SelectSingleNode(to.ToString().ToLower()).InnerText.Trim(); } else { try { int.Parse(id); result.info = id; } catch { result.result = false; result.info = "'id = " + id + "' is not found."; } } } catch (Exception er) { result.result = false; result.info = er.ToString(); } return(result); }
/// <summary> /// 删除一个翻译条目 /// </summary> /// <param name="id"> 想要删除的字典条目ID </param> public OptResult delItem(String id) { OptResult result = new OptResult(true); try { XmlNode node = xmlDoc.SelectSingleNode("//group[@id='" + id + "']"); if (node != null) { foreach (XmlNode childNode in node.ChildNodes) { allWords.Remove(childNode.InnerText.Trim()); } xmlDoc.DocumentElement.RemoveChild(node); xmlDoc.Save(fileName); } else { result.result = false; result.info = "'id = " + id + "' is not found."; } } catch (Exception er) { result.result = false; result.info = er.ToString(); } return(result); }
/* * public void addLanguage(LanguageEnum lang) * { * // 首先检测是否有重复,否则可能会出现重复数据 todo * XmlElement newEle = xmlDoc.CreateElement("group"); * newEle.SetAttribute("id", id); * foreach (var item in dic) * { * XmlElement temp = xmlDoc.CreateElement(item.Key.ToString().ToLower()); * temp.InnerText = item.Value; * newEle.AppendChild(temp); * } * xmlDoc.DocumentElement.AppendChild(newEle); * xmlDoc.Save(fileName); * }*/ /// <summary> /// 修改一个翻译条目 /// </summary> /// <param name="id"> 字典条目ID </param> /// <param name="dic"> 想要更新的内容 </param> public OptResult editItem(String id, Dictionary <LanguageEnum, String> dic) { OptResult result = new OptResult(true); try { XmlNode node = xmlDoc.SelectSingleNode("//group[@id='" + id + "']"); if (node != null) { foreach (var item in dic) { XmlNode temp = node.SelectSingleNode(item.Key.ToString().ToLower()); allWords.Add(item.Value); allWords.Remove(temp.InnerText.Trim()); temp.InnerText = item.Value; } xmlDoc.Save(fileName); } else { result.result = false; result.info = "'id = " + id + "' is not found."; } } catch (Exception er) { result.result = false; result.info = er.ToString(); } return(result); }
public OptResult GetTableWithFields(Dictionary <string, string> conditions) { OptResult rst = null; rst = _tableSrv.GetTableWithFields(conditions); return(rst); }
public void addNewWord(String chinese, String english) { TransDataModel newData = new TransDataModel() { id = english.Substring(0, 1).ToUpper() + english.Substring(1), chinese = chinese, english = english }; OptResult r = translator.addNewWordToDict(newData.id, new Dictionary <LanguageEnum, string>() { { LanguageEnum.CHINESE, newData.chinese }, { LanguageEnum.ENGLISH, newData.english } }); if (r.result == true) { gridData.Add(newData); dataGrid.ItemsSource = null; dataGrid.ItemsSource = gridData; } else { new Alert(r.info, this).ShowDialog(); } }
public OptResult GetPermissions(string usrId) { OptResult rst = null; //1、用户名是否存在 var usr = _usrRep.GetById(usrId); if (usr == null) { rst = OptResult.Build(ResultCode.DataNotFound, string.Format("{0}失败,用户不存在!", Msg_GetPer)); return(rst); } //2、执行查询 try { var pers = _usrPerRelRep.QueryBySqlName <Permission>("getper", new { user_id = usrId }); rst = OptResult.Build(ResultCode.Success, Msg_GetPer, new { user_id = usrId, pers = pers }); } catch (Exception ex) { LogHelper.LogError(Msg_GetPer, ex); rst = OptResult.Build(ResultCode.DbError, Msg_GetPer); } return(rst); }
private void loginClick(object sender, RoutedEventArgs e) { String userName = userNameTextbox.Text; String password = passwordTextbox.Password; // loginResult 应该调用后台接口获得 // Common.OptResult loginResult = login(userName, password); OperationLevelEnum optLevel = OperationLevelEnum.ADMINISTRATOR; OptResult loginResult = new OptResult(true, optLevel.ToString()); // <<------------------------------------------------------------------------ if (userName.Equals("JENNINGLANG") && password.Equals("JENNINGLANG")) { loginResult.result = true; } if (loginResult.result) { FrontFramework.MainWindow mainWindow = new FrontFramework.MainWindow(userName, optLevel); mainWindow.Show(); this.Close(); } else { statusDisplay.Content = translator.getComponentTranslation(new String[] { "Login", "Failure" }) + "!"; } //FrontFramework.Log.LogHelper.writeFuncErrorLog("测试Log4Net日志是否写入", new Exception("ceshi")); //FrontFramework.Log.LogHelper.writeUserOperation("Tester", "Logging", new Object[] { 12, "Hello" }, new FrontFramework.Common.OprResult(true)); }
public OptResult Pay(PayViewModel vmPay) { OptResult rst = null; if (vmPay == null) { rst = OptResult.Build(ResultCode.ParamError, "参数不能为空"); return(rst); } if (ModelState.IsValid == false) { rst = OptResult.Build(ResultCode.ParamError, ModelState.Parse()); return(rst); } var token = base.ParseToken(ActionContext); if (string.IsNullOrEmpty(vmPay.opt)) { vmPay.opt = token.iss; } var payEntity = OOMapper.Map <PayViewModel, PayEntity>(vmPay); rst = _cardMoneySrv.Pay(payEntity); return(rst); }
public OptResult Query(QueryModel queryModel) { OptResult rst = null; if (queryModel == null) { rst = OptResult.Build(ResultCode.ParamError, Msg_ExeQuery + ",查询模型参数不能为空!"); return(rst); } try { PageQuerySqlEntity sqlEntity = _cqRep.GetPageQuerySql(SqlName_PageQuery); if (sqlEntity == null) { rst = OptResult.Build(ResultCode.ParamError, Msg_ExeQuery + ",未能获取sql配置!"); return(rst); } //1、查询模型转换 ConvertQueryModel(queryModel, sqlEntity); //2、执行查询 IEnumerable <dynamic> data = _cqRep.PageQueryBySp <dynamic>(sqlEntity: sqlEntity, page: queryModel.Page); rst = OptResult.Build(ResultCode.Success, Msg_ExeQuery, new { total = queryModel.Page.total, pagecount = queryModel.Page.pageTotal, rows = data }); } catch (Exception ex) { LogHelper.LogError(Msg_ExeQuery, ex); rst = OptResult.Build(ResultCode.DbError, Msg_ExeQuery); } return(rst); }
public OptResult setListStrProp(String name, Dictionary <String, Dictionary <String, String> > value) { OptResult result = new OptResult(true); try { XmlElement node = (XmlElement)xmlDoc.SelectSingleNode("//property[@id='" + name + "']"); node.InnerXml = ""; foreach (var item in value) { XmlElement innerNode = xmlDoc.CreateElement("item"); innerNode.InnerText = item.Key.Trim(); foreach (var prop in item.Value) { XmlAttribute attr = xmlDoc.CreateAttribute(prop.Key.Trim()); attr.Value = prop.Value.Trim(); innerNode.Attributes.Append(attr); } node.AppendChild(innerNode); } xmlDoc.Save(fileName); } catch (Exception er) { result.result = false; result.info = er.ToString(); } reloadProperty(); return(result); }
public OptResult TaskComplete() { var tasks = _rep.GetList(Predicates.Field <TaskModel>(t => t.state, Operator.Eq, "已完成")); if (tasks == null || tasks.Count() < 1) { return(OptResult.Build(ResultCode.Success, "", new { has = "0" })); } var infos = tasks.Select <TaskModel, String>(t => { return(string.Format("任务【{0}】已完成", t.name)); }); OptResult rst = OptResult.Build(ResultCode.Success, "", new { has = "1", infos = infos }); return(rst); }
public OptResult DeleteBatch(IList <string> ids) { OptResult rst = null; if (ids.IsEmpty()) { rst = OptResult.Build(ResultCode.ParamError, string.Format("{0},参数不能为空!", Msg_BatchDeleteField)); return(rst); } //1、是否有不存在的数据 var where = Predicates.Field <Field>(f => f.id, Operator.Eq, ids); var count = _fieldRep.Count(where); if (count != ids.Count) { rst = OptResult.Build(ResultCode.DataNotFound, Msg_BatchDeleteField); return(rst); } //2、删 try { bool val = _fieldRep.Delete(where); rst = OptResult.Build(val ? ResultCode.Success : ResultCode.Fail, Msg_BatchDeleteField); } catch (Exception ex) { LogHelper.LogError(Msg_BatchDeleteField, ex); rst = OptResult.Build(ResultCode.DbError, Msg_BatchDeleteField); } return(rst); }
public OptResult Release(ProcessByIdModel vm) { OptResult rst = null; if (vm == null || string.IsNullOrEmpty(vm.id)) { rst = OptResult.Build(ResultCode.ParamError, "参数不能为空或格式不正确"); return(rst); } var task = _rep.GetById(vm.id); if (task == null) { rst = OptResult.Build(ResultCode.DataNotFound, "未找到指定数据", new { id = vm.id }); return(rst); } task.issue_time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); task.state = "已发布"; task.complete_state = "未领"; _rep.Update(task); rst = OptResult.Build(ResultCode.Success, "发布成功"); return(rst); }
private OptResult ProcessFieldName(IEnumerable <Field> fields, IEnumerable <Table> tables) { OptResult rst; if (tables.IsEmpty()) { rst = OptResult.Build(ResultCode.DataNotFound, string.Format("{0},查询表不存在!", Msg_InitFields)); return(rst); } var groups = fields.GroupBy(f => f.tbid); Table tb = null; foreach (var gp in groups) { tb = tables.Where(t => t.id == gp.Key).FirstOrDefault(); if (tb == null) { rst = OptResult.Build(ResultCode.DataNotFound, string.Format("{0},查询表不存在!", Msg_InitFields)); return(rst); } foreach (var field in gp) { ProcessFieldName(field, tb); field.id = GuidExtension.GetOne(); if (field.displayname.IsEmpty()) { field.displayname = field.fieldname; } } } rst = OptResult.Build(ResultCode.Success, Msg_InitFields); return(rst); }
public OptResult Complete(TaskModel task) { OptResult rst = null; if (task == null || string.IsNullOrEmpty(task.id)) { rst = OptResult.Build(ResultCode.ParamError, "参数不能为空或格式不正确"); return(rst); } var oldTask = _rep.GetById(task.id); if (task == null) { rst = OptResult.Build(ResultCode.DataNotFound, "未找到指定任务", new { id = task.id }); return(rst); } oldTask.progress = task.progress; oldTask.complete_state = "已完成"; oldTask.state = "已完成"; _rep.Update(oldTask); rst = OptResult.Build(ResultCode.Success, "任务完成成功"); return(rst); }
/// <summary> /// 调用商城接口——封停指定身份证号的商城账户 /// </summary> /// <param name="idcard"></param> /// <returns></returns> public OptResult CloseDownAccount(string idcard) { OptResult rst; string msg = string.Empty; var apiUrl = GetMallApiUrl(Key_Api_CloseDownAccount, ref msg); if (string.IsNullOrEmpty(apiUrl)) { rst = OptResult.Build(ResultCode.Fail, Msg_CloseDownAccount + "失败," + msg); return(rst); } //调用商城接口:封停账户 try { rst = HttpUtils.PostResult(apiUrl, new { idcard = idcard }); } catch (Exception ex) { LogHelper.LogError(Msg_CloseDownAccount, ex); rst = OptResult.Build(ResultCode.Fail, Msg_CloseDownAccount + "失败," + ex.Message); } return(rst); }
public OptResult Save(TaskModel task) { OptResult rst = null; if (task == null) { rst = OptResult.Build(ResultCode.ParamError, "参数不能为空或格式不正确"); return(rst); } if (string.IsNullOrEmpty(task.id)) { task.id = GuidExtension.GetOne(); task.state = "编辑"; _rep.Insert(task); } else { var oldTask = _rep.GetById(task.id); oldTask.name = task.name; oldTask.content = task.content; oldTask.priority = task.priority; oldTask.receiver = task.receiver; oldTask.expire_time = task.expire_time; _rep.Update(oldTask); } rst = OptResult.Build(ResultCode.Success, "保存成功"); return(rst); }
public OptResult Add(Table table) { OptResult rst = null; if (table == null) { rst = OptResult.Build(ResultCode.ParamError, string.Format("{0},参数不能为空!", Msg_AddTable)); return(rst); } //1、表名或别名是否存在 if (IsRepeat(table)) { rst = OptResult.Build(ResultCode.DataRepeat, string.Format("{0},查询表名称或别名已存在!", Msg_AddTable)); return(rst); } //2、插入数据库 table.id = GuidExtension.GetOne(); try { _tableRep.Insert(table); rst = OptResult.Build(ResultCode.Success, Msg_AddTable); } catch (Exception ex) { LogHelper.LogError(Msg_AddTable, ex); rst = OptResult.Build(ResultCode.DbError, Msg_AddTable); } return(rst); }
public OptResult QueryByPage(PageQuery page) { OptResult rst = null; if (page == null) { rst = OptResult.Build(ResultCode.ParamError, Msg_QueryByPage + ",分页参数不能为空!"); return(rst); } PageQuerySqlEntity sqlEntity = _perRep.GetPageQuerySql(SqlName_PageQuery); if (sqlEntity == null) { rst = OptResult.Build(ResultCode.ParamError, Msg_QueryByPage + ",未能获取sql配置!"); return(rst); } //构造where #region where条件 if (page.conditions != null && page.conditions.Count > 0) { if (page.conditions.ContainsKey("per_code") && !page.conditions["per_code"].IsEmpty()) { sqlEntity.where.AppendFormat(" and p.per_code='{0}' ", page.conditions["per_code"]); } if (page.conditions.ContainsKey("per_name") && !page.conditions["per_name"].IsEmpty()) { sqlEntity.where.AppendFormat(" and p.per_name like '%{0}%' ", page.conditions["per_name"]); } if (page.conditions.ContainsKey("per_type") && !page.conditions["per_type"].IsEmpty()) { sqlEntity.where.AppendFormat(" and p.per_type = '{0}' ", page.conditions["per_type"]); } if (page.conditions.ContainsKey("per_parent") && !page.conditions["per_parent"].IsEmpty()) { sqlEntity.where.AppendFormat(" and p.per_parent = '{0}' ", page.conditions["per_parent"]); } else if (page.conditions.ContainsKey("per_parent_name") && !page.conditions["per_parent_name"].IsEmpty()) { sqlEntity.where.AppendFormat(" and pp.per_name like '%{0}%' ", page.conditions["per_parent_name"]); } } #endregion try { var pers = _perRep.PageQueryBySp <dynamic>(sqlEntity: sqlEntity, page: page); rst = OptResult.Build(ResultCode.Success, Msg_QueryByPage, new { total = page.total, pagecount = page.pageTotal, rows = pers }); } catch (Exception ex) { LogHelper.LogError(Msg_QueryByPage, ex); rst = OptResult.Build(ResultCode.DbError, Msg_QueryByPage); } return(rst); }