コード例 #1
0
        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);
        }
コード例 #2
0
        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);
        }
コード例 #3
0
ファイル: MallAccountService.cs プロジェクト: radtek/work-1
        /// <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);
        }
コード例 #4
0
        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);
        }
コード例 #5
0
ファイル: FieldService.cs プロジェクト: radtek/work-1
        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);
        }
コード例 #6
0
        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);
        }
コード例 #7
0
        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);
        }
コード例 #8
0
ファイル: DictService.cs プロジェクト: radtek/work-1
        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);
        }
コード例 #9
0
        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();
            }
        }
コード例 #10
0
ファイル: UserController.cs プロジェクト: radtek/work-1
        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);
        }
コード例 #11
0
ファイル: CardAccountService.cs プロジェクト: radtek/work-1
        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);
        }
コード例 #12
0
        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);
        }
コード例 #13
0
        /// <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);
        }
コード例 #14
0
        /*
         * 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);
        }
コード例 #15
0
        public OptResult GetTableWithFields(Dictionary <string, string> conditions)
        {
            OptResult rst = null;

            rst = _tableSrv.GetTableWithFields(conditions);
            return(rst);
        }
コード例 #16
0
        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();
            }
        }
コード例 #17
0
        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);
        }
コード例 #18
0
        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));
        }
コード例 #19
0
        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);
        }
コード例 #20
0
        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);
        }
コード例 #21
0
        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);
        }
コード例 #22
0
ファイル: TaskController.cs プロジェクト: radtek/work-1
        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);
        }
コード例 #23
0
ファイル: FieldService.cs プロジェクト: radtek/work-1
        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);
        }
コード例 #24
0
ファイル: TaskController.cs プロジェクト: radtek/work-1
        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);
        }
コード例 #25
0
ファイル: FieldService.cs プロジェクト: radtek/work-1
        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);
        }
コード例 #26
0
ファイル: TaskController.cs プロジェクト: radtek/work-1
        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);
        }
コード例 #27
0
ファイル: MallAccountService.cs プロジェクト: radtek/work-1
        /// <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);
        }
コード例 #28
0
ファイル: TaskController.cs プロジェクト: radtek/work-1
        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);
        }
コード例 #29
0
ファイル: TableService.cs プロジェクト: radtek/work-1
        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);
        }
コード例 #30
0
ファイル: PermissionService.cs プロジェクト: radtek/work-1
        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);
        }