public CommonResult<CyResourceEntity> GetCyResourceList() { var commonResult = new CommonResult<CyResourceEntity>(); const string sql = @"SELECT [ResourceId] ,[ResourceCode] ,[ResourceName] ,[MenuCode] ,[MenuId] ,[RequestPath] ,[ResourceFlag] ,[Memo] FROM [dbo].[CyResource](nolock)"; using (var conn = DbHelper.CreateOpenConnection(DbConnectionStringConfig.CyReadConnectionStringName)) { try { var model = conn.Query<CyResourceEntity>(sql).ToList(); commonResult.Success = true; commonResult.Message = "执行成功"; commonResult.ResultObjList = model; } catch (Exception ex) { commonResult.Success = false; commonResult.IsHappenEx = true; commonResult.Message = "执行失败"; commonResult.ExMessage = ex.Message; commonResult.ExData = ex; } return commonResult; } }
public async Task<IActionResult> Get() { var res = await _helper.QueryAsync(BookCommandText.GetBooks); CommonResult<Book> json = new CommonResult<Book> { Code = "000", Message = "ok", Data = res }; return Ok(json); }
public IActionResult Post([FromForm]PostForm form) { DynamicParameters dp = new DynamicParameters(); dp.Add("@Id", form.Id, DbType.Int32, ParameterDirection.Input); var res = _helper.Query<Book>(BookCommandText.GetBookById, dp, null, true, null, CommandType.StoredProcedure).FirstOrDefault(); CommonResult<Book> json = new CommonResult<Book> { Code = "000", Message = "ok", Data = res }; return Ok(json); }
/// <summary> /// 保存客户端上传的相关数据列表 /// </summary> /// <param name="list">数据列表</param> /// <returns></returns> public ActionResult SaveExcelData(List <CompetitorInfo> list) { CommonResult result = new CommonResult(); if (list != null && list.Count > 0) { #region 采用事务进行数据提交 DbTransaction trans = BLLFactory <Competitor> .Instance.CreateTransaction(); if (trans != null) { try { //int seq = 1; foreach (CompetitorInfo detail in list) { //detail.Seq = seq++;//增加1 detail.CreateTime = DateTime.Now; detail.Creator = CurrentUser.ID.ToString(); detail.Editor = CurrentUser.ID.ToString(); detail.EditTime = DateTime.Now; detail.Company_ID = CurrentUser.Company_ID; detail.Dept_ID = CurrentUser.Dept_ID; BLLFactory <Competitor> .Instance.Insert(detail, trans); } trans.Commit(); result.Success = true; } catch (Exception ex) { LogHelper.WriteLog(LogLevel.LOG_LEVEL_CRIT, ex, typeof(CompetitorController)); result.ErrorMessage = ex.Message; trans.Rollback(); } } #endregion } else { result.ErrorMessage = "导入信息不能为空"; } return(ToJsonContent(result)); }
/// <summary> /// 保存客户端上传的相关数据列表 /// </summary> /// <param name="list">数据列表</param> /// <returns></returns> public ActionResult SaveExcelData(List <DictDataInfo> list) { CommonResult result = new CommonResult(); if (list != null && list.Count > 0) { #region 采用事务进行数据提交 DbTransaction trans = BLLFactory <DictData> .Instance.CreateTransaction(); if (trans != null) { try { //int seq = 1; foreach (DictDataInfo detail in list) { DictTypeInfo typeInfo = BLLFactory <DictType> .Instance.FindSingle(string.Format("Name ='{0}'", detail.DictType_ID)); if (typeInfo != null) { //detail.Seq = seq++;//增加1 detail.Editor = CurrentUser.ID.ToString(); detail.LastUpdated = DateTime.Now; BLLFactory <DictData> .Instance.Insert(detail, trans); } } trans.Commit(); result.Success = true; } catch (Exception ex) { LogHelper.WriteLog(LogLevel.LOG_LEVEL_CRIT, ex, typeof(DictDataController)); result.ErrorMessage = ex.Message; trans.Rollback(); } } #endregion } else { result.ErrorMessage = "导入信息不能为空"; } return(ToJsonContent(result)); }
public CommonResult <PageResult <DbTableInfo> > FindListTable(SearchModel search) { CommonResult <PageResult <DbTableInfo> > result = new CommonResult <PageResult <DbTableInfo> >(); if (!string.IsNullOrEmpty(search.EnCode)) { YuebonCacheHelper yuebonCacheHelper = new YuebonCacheHelper(); object connCode = yuebonCacheHelper.Get("CodeGeneratorDbConn"); if (connCode != null) { string SqlConnectionString = connCode.ToString(); string[] sqlconn = SqlConnectionString.Split(";"); string[] dataName = sqlconn[1].Split("="); dataName[1] = search.EnCode; sqlconn[1] = dataName.Join("="); string newConnStr = sqlconn.Join(";"); TimeSpan expiresSliding = DateTime.Now.AddMinutes(30) - DateTime.Now; yuebonCacheHelper.Add("CodeGeneratorDbConn", newConnStr, expiresSliding, false); yuebonCacheHelper.Add("CodeGeneratorDbName", search.EnCode, expiresSliding, false); } } string orderByDir = search.Order; string orderFlied = string.IsNullOrEmpty(search.Sort)? "TableName": search.Sort; bool order = orderByDir == "asc" ? false : true; string where = "1=1"; if (!string.IsNullOrEmpty(search.Keywords)) { where += " and TableName like '%" + search.Keywords + "%'"; } PagerInfo pagerInfo = new PagerInfo { PageSize = search.PageSize, CurrenetPageIndex = search.CurrenetPageIndex }; DbExtractor dbExtractor = new DbExtractor(); List <DbTableInfo> listTable = dbExtractor.GetTablesWithPage(search.Keywords, orderFlied, order, pagerInfo); PageResult <DbTableInfo> pageResult = new PageResult <DbTableInfo>(); pageResult.CurrentPage = pagerInfo.CurrenetPageIndex; pageResult.Items = listTable; pageResult.ItemsPerPage = pagerInfo.PageSize; pageResult.TotalItems = pagerInfo.RecordCount; result.ResData = pageResult; result.ErrCode = ErrCode.successCode; return(result); }
/// <summary> /// 保存客户端上传的相关数据列表 /// </summary> /// <param name="list">数据列表</param> /// <returns></returns> public ActionResult SaveExcelData(List <BootstrapIconInfo> list) { CommonResult result = new CommonResult(); if (list != null && list.Count > 0) { #region 采用事务进行数据提交 DbTransaction trans = BLLFactory <BootstrapIcon> .Instance.CreateTransaction(); if (trans != null) { try { //int seq = 1; foreach (BootstrapIconInfo detail in list) { //detail.Seq = seq++;//增加1 detail.CreateTime = DateTime.Now; BLLFactory <BootstrapIcon> .Instance.Insert(detail, trans); } trans.Commit(); result.Success = true; } catch (Exception ex) { LogTextHelper.Error(ex); result.ErrorMessage = ex.Message; trans.Rollback(); } finally { trans.Connection.Close(); trans.Connection.Dispose(); trans.Dispose(); } } #endregion } else { result.ErrorMessage = "导入信息不能为空"; } return(ToJsonContent(result)); }
/// <summary> /// 保存客户端上传的相关数据列表 /// </summary> /// <param name="list">数据列表</param> /// <returns></returns> public ActionResult SaveExcelData(List <ReimbursementInfo> list) { CommonResult result = new CommonResult(); if (list != null && list.Count > 0) { #region 采用事务进行数据提交 var trans = BLLFactory <Reimbursement> .Instance.CreateTransaction(); if (trans != null) { try { //int seq = 1; foreach (ReimbursementInfo detail in list) { //detail.Seq = seq++;//增加1 /* * detail.CreateTime = DateTime.Now; * detail.Creator = CurrentUser.ID.ToString(); * detail.Editor = CurrentUser.ID.ToString(); * detail.EditTime = DateTime.Now; */ BLLFactory <Reimbursement> .Instance.Insert(detail, trans); } trans.Commit(); result.Success = true; } catch (Exception ex) { LogTextHelper.Error(ex); result.ErrorMessage = ex.Message; trans.Rollback(); } } #endregion } else { result.ErrorMessage = "导入信息不能为空"; } return(ToJsonContent(result)); }
public ActionResult DepositAccount(int custNo) { CommonResult result = new CommonResult(); try { //up_DepositWriteoff(预付费模式预存款销账) //CREATEPROCEDURE[dbo].[up_DepositWriteoff] //@iCustNo INTEGER = 1, --< !--客户编号-- > //@sUserID VARCHAR(8),--< !--操作员编号-- > //@sReturn VARCHAR(MAX)OUTPUT lock (objLock) { //System.Threading.Thread.Sleep(3000); List <SqlParameter> param = new List <SqlParameter>(); param.Add(new SqlParameter("@iCustNo", SqlDbType.Int) { Value = custNo }); param.Add(new SqlParameter("@sUserID", SqlDbType.VarChar, 8) { Value = UserInfo.ID }); param.Add(new SqlParameter("@sReturn", SqlDbType.VarChar, 256) { Direction = ParameterDirection.Output }); BLLFactory <Core.BLL.AccPayment> .Instance.ExecStoreProc("up_DepositWriteoff", param); if (param[param.Count - 1].Value.ToString() == "0") { result.Success = true; } else { result.ErrorMessage = "操作失败!错误如下:" + param[param.Count - 1].Value; } } } catch (Exception ex) { result.ErrorMessage = "操作失败!错误如下:" + ex.Message; } return(ToJsonContent(result)); }
/// <summary> /// 系统-菜单-删除 /// </summary> /// <returns></returns> public ActionResult Sys_Menu_Del_Server(string Ids) { CommonResult result = new CommonResult(); var arrIds = Ids.Split(','); var rs = new AuthorityClient().Sys_Menu_BatchDel(arrIds); if (rs == "0") { result.IsSuccess = true; } else { result.IsSuccess = false; result.ErrorMsg = rs; } return(ToJsonContent(result)); }
/// <summary> /// xxp 获取设备的执行信息 /// </summary> /// <param name="strDevCode">设备编码</param> /// <returns></returns> public CommonResult <List <V_DV_DevExecute> > GetDeviceExecuteByDevCode(string strDevCode) { var result = new CommonResult <List <V_DV_DevExecute> >(); try { var dbSession = new DBService <V_DV_DevExecute>().DbSession; result.Data = dbSession.GetQueryable(t => t.ZGCode == strDevCode).ToList(); } catch (Exception ex) { Utils.Logger.Error(ex.ToString()); throw ex; } return(result); }
public IActionResult SendMakePhoneCallNotice(string userId, string tell, string tell2) { CommonResult result = new CommonResult(); try { tell = tell.Replace(" ", ""); string message = "{\"telphone\":\"" + tell2 + "\"}"; result = Messenger.SendMakePhoneCallNotice(userId, tell, message, ""); } catch (Exception ex) { result.ErrMsg = ex.Message; Log4NetHelper.Error("更新用户电话号码 UpdatePhone", ex); } return(ToJsonContent(result)); }
public override async Task <IActionResult> UpdateAsync(MenuInputDto tinfo) { CommonResult result = new CommonResult(); Menu info = iService.Get(tinfo.Id); info.FullName = tinfo.FullName; info.EnCode = tinfo.EnCode; info.SystemTypeId = tinfo.SystemTypeId; info.ParentId = tinfo.ParentId; info.Icon = tinfo.Icon; info.EnabledMark = tinfo.EnabledMark; info.SortCode = tinfo.SortCode; info.Description = tinfo.Description; info.MenuType = tinfo.MenuType; info.ActiveMenu = tinfo.ActiveMenu; if (info.MenuType == "F") { info.IsFrame = false; info.Component = ""; info.UrlAddress = ""; } else { info.Component = tinfo.Component; info.IsFrame = tinfo.IsFrame; info.UrlAddress = tinfo.UrlAddress; } info.IsShow = tinfo.IsShow; OnBeforeUpdate(info); bool bl = await iService.UpdateAsync(info, tinfo.Id).ConfigureAwait(false); if (bl) { result.ErrCode = ErrCode.successCode; result.ErrMsg = ErrCode.err0; } else { result.ErrMsg = ErrCode.err43002; result.ErrCode = "43002"; } return(ToJsonContent(result)); }
/// <summary> /// 系统-菜单-删除 /// </summary> /// <returns></returns> public ActionResult Sys_Menu_Del_Server(string Ids) { CommonResult result = new CommonResult(); var arrIds = Ids.Split(','); var rs = new WaterFeeWeb.ServiceReference1.AuthorityClient().Sys_Menu_BatchDel(arrIds); if (rs == "0") { result.Success = true; } else { result.Success = false; result.ErrorMessage = rs; } return(ToJsonContent(result)); }
/// <summary> /// 根据设备编码获取数据,初期用于设备状态的获取XCQ20161217 /// </summary> /// <param name="Devcode"></param> /// <returns></returns> public CommonResult <List <vw_DurmsUpFeeding> > GetDurmsUpFeedingByDevCode(string Devcode) { var result = new CommonResult <List <vw_DurmsUpFeeding> >(); try { var dbSession = new DBService <vw_DurmsUpFeeding>().DbSession; result.Data = dbSession.GetQueryable(t => t.DevCode == Devcode).ToList(); } catch (Exception ex) { result.IsSuccess = false; result.Message = ex.Message; result.StackTrace = ex.StackTrace; } return(result); }
/// <summary> /// 根据排配单号获取当前工艺操作明细列表 XCQ20161217 /// </summary> /// <param name="ArrangedVouchCode"></param> /// <returns></returns> public CommonResult <List <ArrangedVouchLog> > GetArrangedVouchLogByCode(string ArrangedVouchCode) { var result = new CommonResult <List <ArrangedVouchLog> >(); try { var dbSession = new DBService <ArrangedVouchLog>().DbSession; result.Data = dbSession.GetQueryable(t => t.ArrangedVouchCode == ArrangedVouchCode).OrderByDescending(t => t.AutoID).ToList(); } catch (Exception ex) { result.IsSuccess = false; result.Message = ex.Message; result.StackTrace = ex.StackTrace; } return(result); }
/// <summary> /// 根据登录名称获取体重数据 /// </summary> /// <param name="PerCode"></param> /// <returns></returns> public CommonResult <Person> GetPersonByPerCode(string PerCode) { var result = new CommonResult <Person>(); try { var dbSession = new DBService <Person>().DbSession; result.Data = dbSession.GetQueryable(t => t.PersonCode == PerCode).FirstOrDefault(); } catch (Exception ex) { Utils.Logger.Error(ex.Message); throw ex; } return(result); }
/// <summary> /// 获取当天的排配数据 /// </summary> /// <returns></returns> public CommonResult <ArrangedVouch> GetArrangedBySameTime() { var result = new CommonResult <ArrangedVouch>(); try { var dbSession = new DBService <ArrangedVouch>().DbSession; result.Data = dbSession.GetQueryable(t => t.VouchDate.Year == DateTime.Now.Year && t.VouchDate.Month == DateTime.Now.Month && t.VouchDate.Day == DateTime.Now.Day).OrderByDescending(t => t.ID).FirstOrDefault(); } catch (Exception ex) { result.IsSuccess = false; result.Message = ex.Message; result.StackTrace = ex.StackTrace; } return(result); }
public ActionResult UpDown(string id, bool up) { CommonResult result = new CommonResult(); if (!string.IsNullOrEmpty(id)) { try { result.Success = BLLFactory <WebFavorite> .Instance.UpDown(id, up); } catch (Exception ex) { result.ErrorMessage = ex.Message; } } return(ToJsonContent(result)); }
//客户档案统计 public ActionResult StatClientArcData_Server() { CommonResult result = new CommonResult(); var endcode = Session["IntEndCode"] ?? "0"; var DteBegin = Request["WHC_dtStart"].ToDateTime(); var DteEnd = Request["WHC_dtEnd"].ToDateTime(); try { var rs = new DbServiceReference.ServiceDbClient().StatClientArcData(endcode.ToString().ToInt(), DteBegin, DteEnd); if (rs.IsSuccess) { DataTable dts = JsonConvert.DeserializeObject <DataTable>(rs.StrData1); if (dts.Rows.Count > 0) { int rows = Request["rows"] == null ? 10 : int.Parse(Request["rows"]); int page = Request["page"] == null ? 1 : int.Parse(Request["page"]); DataTable dat = new DataTable(); //复制源的架构和约束 dat = dts.Clone(); // 清除目标的所有数据 dat.Clear(); //对数据进行分页 for (int i = (page - 1) * rows; i < page * rows && i < dts.Rows.Count; i++) { dat.ImportRow(dts.Rows[i]); } //最重要的是在后台取数据放在json中要添加个参数total来存放数据的总行数,如果没有这个参数则不能分页 int total = dts.Rows.Count; var dt = new { total, rows = dat }; result.Success = true; return(ToJsonContentDate(dt)); } } else { result.ErrorMessage = rs.ErrorMsg; result.Success = false; } } catch (Exception ex) { result.ErrorMessage = "查询失败!错误如下:" + ex.Message; } return(ToJsonContentDate(result)); }
/// <summary> /// 查询执行主表数据CraftsProcessExecute,用于初期对象建立 /// </summary> /// <returns></returns> public CommonResult <List <CraftsProcessExecute> > GetCfPExecutes(string ArrangedVouchCode) { var result = new CommonResult <List <CraftsProcessExecute> >(); // string strArrangedVouchCode = null; try { var dbSession = new DBService <CraftsProcessExecute>().DbSession; result.Data = dbSession.GetQueryable(t => t.ArrangedVouchCode == ArrangedVouchCode).ToList(); } catch (Exception ex) { Utils.Logger.Error(ex.Message); throw ex; } return(result); }
/// <summary> /// 根据排配单号获取最新执行主表CraftsProcessExecute数据 /// 2017-01-09修正为当前最新执行状态数据,增加t.ExecuteStatus != 0 && t.ExecuteStatus != 99判断条件 /// </summary>20170110XC1 /// <param name="ArrangedVouchCode"></param> /// <returns></returns> public CommonResult <CraftsProcessExecute> GetCfPExecuteByArrangedVouchCode(string ArrangedVouchCode) { var result = new CommonResult <CraftsProcessExecute>(); try { var dbSession = new DBService <CraftsProcessExecute>().DbSession; result.Data = dbSession.GetQueryable(t => t.ArrangedVouchCode == ArrangedVouchCode && t.ExecuteStatus != 0 && t.ExecuteStatus != 99).OrderByDescending(t => t.ExecuteID).FirstOrDefault(); // result.Data = dbSession.GetQueryable().OrderBy(t => t.ExecuteID).OrderBy(t => t.CraftsName).ToList(); } catch (Exception ex) { Utils.Logger.Error(ex.Message); throw ex; } return(result); }
public virtual async Task <IActionResult> DeleteAsync(TKey id) { CommonResult result = new CommonResult(); bool bl = await iService.DeleteAsync(id).ConfigureAwait(false); if (bl) { result.ErrCode = ErrCode.successCode; result.ErrMsg = ErrCode.err0; } else { result.ErrMsg = ErrCode.err43003; result.ErrCode = "43003"; } return(ToJsonContent(result)); }
/// <summary> /// 遍历获取IP登记表所有IP数据,暂定匹配条件为状态是0的时候,登记表中新建数据默认status为0 /// </summary>20170117XCQ /// <returns></returns> public CommonResult <List <IPRegistForm> > GetAllIPRegistForm() { var result = new CommonResult <List <IPRegistForm> >(); try { var dbSession = new DBService <IPRegistForm>().DbSession; result.Data = dbSession.GetQueryable(t => t.Status == 0).ToList(); } catch (Exception ex) { Utils.Logger.Error(ex.Message); throw ex; } return(result); }
public virtual async Task <CommonResult <TODto> > GetById(TKey id) { CommonResult <TODto> result = new CommonResult <TODto>(); TODto info = await iService.GetOutDtoAsync(id); if (info != null) { result.ErrCode = ErrCode.successCode; result.ResData = info; } else { result.ErrMsg = ErrCode.err50001; result.ErrCode = "50001"; } return(result); }
///2016/12/02 /// <summary> /// 获取设备接口集合 /// </summary> /// <param name="PageSize">每页大小</param> /// <param name="CurrPage">当前页面</param> /// <param name="TotalNum">总条数</param> /// <param name="strDevCode">设备编码</param> /// <param name="strDeviCode">设备接口编码</param> /// <param name="strDeviName">设备接口名称</param> /// <returns></returns> public CommonResult <List <QC_DrumsFindLeakReport> > GetQCDrumsFindLeak()//int PageSize, int CurrPage, ref int TotalNum,string DevpCodet => t.DevpCode == DevpCode { var result = new CommonResult <List <QC_DrumsFindLeakReport> >(); try { var dbSession = new DBService <QC_DrumsFindLeakReport>().DbSession; result.Data = dbSession.GetQueryable().ToList(); } catch (Exception ex) { result.IsSuccess = false; result.Message = ex.Message; result.StackTrace = ex.StackTrace; } return(result); }
public virtual IActionResult Delete(TKey id) { CommonResult result = new CommonResult(); bool bl = iService.Delete(id); if (bl) { result.ErrCode = ErrCode.successCode; result.ErrMsg = ErrCode.err0; } else { result.ErrMsg = ErrCode.err43003; result.ErrCode = "43003"; } return(ToJsonContent(result)); }
public IActionResult Logout() { CommonResult result = new CommonResult(); YuebonCacheHelper yuebonCacheHelper = new YuebonCacheHelper(); yuebonCacheHelper.Remove("login_user_" + CurrentUser.UserId); yuebonCacheHelper.Remove("User_Function_" + CurrentUser.UserId); UserLogOn userLogOn = _userLogOnService.GetWhere("UserId='" + CurrentUser.UserId + "'"); userLogOn.UserOnLine = false; _userLogOnService.Update(userLogOn, userLogOn.Id); CurrentUser = null; result.Success = true; result.ErrCode = ErrCode.successCode; result.ErrMsg = "成功退出"; return(ToJsonContent(result)); }
/// <summary> /// 直接获取操作日志列表XCQ20161217 /// </summary> /// <returns></returns> public CommonResult <List <ArrangedVouchLog> > GetArrangedVouchLog() { var result = new CommonResult <List <ArrangedVouchLog> >(); try { var dbSession = new DBService <ArrangedVouchLog>().DbSession; result.Data = dbSession.GetQueryable().ToList(); } catch (Exception ex) { result.IsSuccess = false; result.Message = ex.Message; result.StackTrace = ex.StackTrace; } return(result); }
public async Task <IActionResult> SaveUserTheme(UserThemeInputDto info) { CommonResult result = new CommonResult(); try { result.Success = await userLogOnService.SaveUserTheme(info, CurrentUser.UserId); result.ErrCode = ErrCode.successCode; } catch (Exception ex) { Log4NetHelper.Error("保存用户自定义的软件主题异常", ex);//错误记录 result.ErrMsg = ex.Message; } return(ToJsonContent(result)); }
public CommonResult <V_DV_DevExecute> GetDeviceExecuteByID(int strExctueID) { var result = new CommonResult <V_DV_DevExecute>(); try { var dbSession = new DBService <V_DV_DevExecute>().DbSession; result.Data = dbSession.GetQueryable(t => t.ExecuteID == strExctueID).FirstOrDefault(); // result.Data = dbSession.GetQueryable(t => t.== strExctueID).FirstOrDefault(); } catch (Exception ex) { Utils.Logger.Error(ex.ToString()); throw ex; } return(result); }
/// <summary> /// 根据转鼓名称获取数采仪数据20170414-BY XCQ /// </summary> /// <param name="Address"></param> /// <returns></returns> public CommonResult <List <V_DV_DevExecute> > GetDevViewListByZGName(string ZGName) { var result = new CommonResult <List <V_DV_DevExecute> >(); try { var dbSession = new DBService <V_DV_DevExecute>().DbSession; result.Data = dbSession.GetQueryable(t => t.ZGName == ZGName && t.InterFaceStatus == 0 && t.WorkStatus == 0 && t.EquipStatus == 0).ToList(); //&& t.ZGCode == "ZG0102"&& t.ZGCode == "ZG0102" } catch (Exception ex) { Utils.Logger.Error(ex.ToString()); throw ex; } return(result); }
public CommonResult <List <DeviceExecute> > GetAllExecute() { var result = new CommonResult <List <DeviceExecute> >(); try { var dbSession = new DBService <DeviceExecute>().DbSession; result.Data = dbSession.GetQueryable().ToList(); } catch (Exception ex) { Utils.Logger.Error(ex.ToString()); throw ex; } return(result); }
public JsonResult LoginIn(LoginUser loginUser) { var userResult = new CommonResult<CyUserEntity>(); try { var user = new CyUserEntity() { UserName = loginUser.UserName, UserPwd = loginUser.UserPwd, ValideCode = loginUser.ValideCode }; //验证用户信息 userResult = CyUserService.Login(user); //验证成功 if (userResult.Success) { var cyUser = userResult.ResultObj; var model = new UserModel() { UserNo = cyUser.UserNo, UserName = cyUser.UserName, NickName = cyUser.NickName, TrueName = cyUser.TrueName, MemberType = cyUser.MemberType, Role = cyUser.Role }; UserContext.SetAuthCookie(model, true); var loginLog = new CyUserLoginLogEntity() { UserNo = cyUser.UserNo, LoginIp = IpHelper.GetUserIpAddress(), LoginTime = DateTime.Now }; CyUserService.AddCyUserLoginLog(loginLog); } } catch (Exception ex) { userResult.Success = false; userResult.Message = ex.Message; } return Json(userResult, JsonRequestBehavior.AllowGet); }
/// <summary> /// 查询用户信息 /// </summary> /// <param name="userName">用户名</param> /// <returns></returns> public CommonResult<CyUserEntity> GetCyUserByUserName(string userName) { var commonResult = new CommonResult<CyUserEntity>(); const string sql = @"SELECT [UserId] ,[UserNo] ,[UserName] ,[UserPwd] ,[NickName] ,[TrueName] ,[Gender] ,[MobilePhone] ,[Email] ,[QQ] ,[Industry] ,[Position] ,[Birthday] ,[BirthPlace] ,[Residence] ,[MemberType] ,[Role] ,[CreateUserNo] ,[CreateTime] ,[UpdateUserNo] ,[UpdateTime] ,[DataStatus] FROM [dbo].[CyUser](NOLOCK) WHERE UserName=@UserName AND DataStatus=@DataStatus"; using (var conn = DbHelper.CreateOpenConnection(DbConnectionStringConfig.CyReadConnectionStringName)) { try { var model = conn.Query<CyUserEntity>(sql, new { UserName = userName, DataStatus = DataStatus.Valid }).ToList(); commonResult.Success = true; commonResult.Message = "执行成功"; commonResult.ResultObjList = model; } catch (Exception ex) { commonResult.Success = false; commonResult.IsHappenEx = true; commonResult.Message = "执行失败"; commonResult.ExMessage = ex.Message; commonResult.ExData = ex; } return commonResult; } }
/// <summary> /// 添加用户信息 /// </summary> /// <param name="entity">实体</param> /// <param name="trans">事务</param> /// <returns>执行结果</returns> public CommonResult<string> AddCyUser(CyUserEntity entity, IDbTransaction trans = null) { var commonResult = new CommonResult<string>(); const string sql = @"INSERT INTO [dbo].[CyUser] ([UserNo] ,[UserName] ,[UserPwd] ,[NickName] ,[TrueName] ,[Gender] ,[MobilePhone] ,[Email] ,[QQ] ,[Industry] ,[Position] ,[Birthday] ,[BirthPlace] ,[Residence] ,[MemberType] ,[Role] ,[CreateUserNo] ,[CreateTime] ,[UpdateUserNo] ,[UpdateTime] ,[DataStatus]) VALUES (@UserNo ,@UserName ,@UserPwd ,@NickName ,@TrueName ,@Gender ,@MobilePhone ,@Email ,@QQ ,@Industry ,@Position ,@Birthday ,@BirthPlace ,@Residence ,@MemberType ,@Role ,@CreateUserNo ,@CreateTime ,@UpdateUserNo ,@UpdateTime ,@DataStatus)"; if (trans == null) { using (var conn = DbHelper.CreateOpenConnection(DbConnectionStringConfig.CyMainDbConnectionStringName)) { try { var rows = conn.Execute(sql, entity); commonResult.Success = true; commonResult.Message = "执行成功"; commonResult.EffectRows = rows; } catch (Exception ex) { commonResult.Success = false; commonResult.IsHappenEx = true; commonResult.Message = "执行失败"; commonResult.ExMessage = ex.Message; commonResult.ExData = ex; } } } else { try { var rows = trans.Connection.Execute(sql, entity, transaction: trans); commonResult.Success = true; commonResult.Message = "执行成功"; commonResult.EffectRows = rows; } catch (Exception ex) { commonResult.Success = false; commonResult.IsHappenEx = true; commonResult.Message = "执行失败"; commonResult.ExMessage = ex.Message; commonResult.ExData = ex; } } return commonResult; }
/// <summary> /// 修改用户信息 /// </summary> /// <param name="entity">实体</param> /// <param name="trans">事务</param> /// <returns>执行结果</returns> public CommonResult<string> ModifyCyUser(CyUserEntity entity, IDbTransaction trans = null) { var commonResult = new CommonResult<string>(); const string sql = @"UPDATE [dbo].[CyUser] SET [NickName] =@NickName ,[TrueName] =@TrueName ,[Gender] =@Gender ,[MobilePhone] =@MobilePhone ,[Email] =@Email ,[QQ] =@QQ ,[Birthday] =@Birthday ,[BirthPlace] =@BirthPlace ,[Residence] =@Residence ,[UpdateUserNo] =@UpdateUserNo ,[UpdateTime] =@UpdateTime WHERE UserNo=@UserNo"; if (trans == null) { using (var conn = DbHelper.CreateOpenConnection(DbConnectionStringConfig.CyMainDbConnectionStringName)) { try { var rows = conn.Execute(sql, entity); commonResult.Success = true; commonResult.Message = "执行成功"; commonResult.EffectRows = rows; } catch (Exception ex) { commonResult.Success = false; commonResult.IsHappenEx = true; commonResult.Message = "执行失败"; commonResult.ExMessage = ex.Message; commonResult.ExData = ex; } } } else { try { var rows = trans.Connection.Execute(sql, entity, transaction: trans); commonResult.Success = true; commonResult.Message = "执行成功"; commonResult.EffectRows = rows; } catch (Exception ex) { commonResult.Success = false; commonResult.IsHappenEx = true; commonResult.Message = "执行失败"; commonResult.ExMessage = ex.Message; commonResult.ExData = ex; } } return commonResult; }
/// <summary> /// 添加登录日志 /// </summary> /// <param name="entity"></param> /// <param name="trans"></param> /// <returns></returns> public CommonResult<string> AddCyUserLoginLog(CyUserLoginLogEntity entity, IDbTransaction trans = null) { var commonResult = new CommonResult<string>(); const string sql = @"INSERT INTO [dbo].[CyUserLoginLog] ([UserNo] ,[LoginTime] ,[LoginIp]) VALUES (@UserNo ,@LoginTime ,@LoginIp)"; if (trans == null) { using (var conn = DbHelper.CreateOpenConnection(DbConnectionStringConfig.CyMainDbConnectionStringName)) { try { var rows = conn.Execute(sql, entity); commonResult.Success = true; commonResult.Message = "执行成功"; commonResult.EffectRows = rows; } catch (Exception ex) { commonResult.Success = false; commonResult.IsHappenEx = true; commonResult.Message = "执行失败"; commonResult.ExMessage = ex.Message; commonResult.ExData = ex; } } } else { try { var rows = trans.Connection.Execute(sql, entity, transaction: trans); commonResult.Success = true; commonResult.Message = "执行成功"; commonResult.EffectRows = rows; } catch (Exception ex) { commonResult.Success = false; commonResult.IsHappenEx = true; commonResult.Message = "执行失败"; commonResult.ExMessage = ex.Message; commonResult.ExData = ex; } } return commonResult; }
public CommonResult<CyUserEntity> Login(CyUserEntity user) { try { var commonResult = new CommonResult<CyUserEntity>(); if (string.IsNullOrEmpty(user.UserName)) { commonResult.Success = false; commonResult.Message = "用户名为空"; return commonResult; } if (string.IsNullOrEmpty(user.UserPwd)) { commonResult.Success = false; commonResult.Message = "密码为空"; return commonResult; } var userResult = CyUserProvider.GetCyUserByUserName(user.UserName); if (userResult.Success) { var userModel = userResult.ResultObjList; if (userModel.Count == 0) { commonResult.Success = false; commonResult.Message = "用户名不存在"; return commonResult; } //如果同一用户名出现重复记录 if (userModel.Count > 1) { commonResult.Success = false; commonResult.Message = "用户信息异常请联系管理员"; return commonResult; } if (userModel[0].UserPwd != StringUtil.ToHashString(user.UserPwd)) { commonResult.Success = false; commonResult.Message = "密码错误"; return commonResult; } if (!string.Equals(HttpContext.Current.Session["vcode"].ToString(), user.ValideCode, StringComparison.CurrentCultureIgnoreCase)) { commonResult.Success = false; commonResult.Message = "验证码填写错误"; return commonResult; } commonResult.Success = true; commonResult.Message = "验证成功"; commonResult.ResultObj = userModel[0]; } else { commonResult = userResult; return commonResult; } return commonResult; } catch (Exception) { throw; } }
public CommonResult<string> AddCyCompany(CyCompanyEntity entity, IDbTransaction trans = null) { var commonResult = new CommonResult<string>(); const string sql = @"INSERT INTO [dbo].[CyCompany] ([UserNo] ,[CompanyName] ,[Industry] ,[ContactName] ,[ContactPhone] ,[ContactEmail] ,[CompanyTel] ,[CompanyFax] ,[CompanyAddress] ,[CompanyWebsite] ,[CompanyProfile] ,[CreateUserNo] ,[CreateTime] ,[UpdateUserNo] ,[UpdateTime] ,[DataStatus]) VALUES (@UserNo ,@CompanyName ,@Industry ,@ContactName ,@ContactPhone ,@ContactEmail ,@CompanyTel ,@CompanyFax ,@CompanyAddress ,@CompanyWebsite ,@CompanyProfile ,@CreateUserNo ,@CreateTime ,@UpdateUserNo ,@UpdateTime ,@DataStatus)"; if (trans == null) { using (var conn = DbHelper.CreateOpenConnection(DbConnectionStringConfig.CyMainDbConnectionStringName)) { try { var rows = conn.Execute(sql, entity); commonResult.Success = true; commonResult.Message = "执行成功"; commonResult.EffectRows = rows; } catch (Exception ex) { commonResult.Success = false; commonResult.IsHappenEx = true; commonResult.Message = "执行失败"; commonResult.ExMessage = ex.Message; commonResult.ExData = ex; } } } else { try { var rows = trans.Connection.Execute(sql, entity, transaction: trans); commonResult.Success = true; commonResult.Message = "执行成功"; commonResult.EffectRows = rows; } catch (Exception ex) { commonResult.Success = false; commonResult.IsHappenEx = true; commonResult.Message = "执行失败"; commonResult.ExMessage = ex.Message; commonResult.ExData = ex; } } return commonResult; }