/// <summary> /// 操作日志 /// </summary> /// <param name="logContent">日志内容</param> /// <param name="companyId">渠道编号</param> /// <param name="businessType">业务类型1网贷2保险3信用卡</param> /// <param name="relationId">关联编号</param> /// <returns>操作日志添加结果</returns> static public int OperationLogAdd(int relationId, string logContent, int companyId = 1, int businessType = 1) { int result = -1; try { int userId = -1; string realName = string.Empty; int departmentId = -1; string departmentName = string.Empty; LoginUserCookie currentUser = MerchantFrontCookieBLL.GetMerchantFrontUserCookie(); if (currentUser != null) { UsersBLL op = new UsersBLL(); Users model = new Users(); model = op.GetModel(currentUser.LoginUserID); userId = currentUser.LoginUserID; departmentId = model.DepartmentID; if (model != null) { realName = model.UserName; DepartmentInfoBLL opDepartment = new DepartmentInfoBLL(); DepartmentInfo modelDepartmentInfo = new DepartmentInfo(); modelDepartmentInfo = opDepartment.GetModel(departmentId); if (modelDepartmentInfo != null) { departmentName = modelDepartmentInfo.DepartmentName; } } } StackTrace st = new StackTrace(true); MethodBase mb = st.GetFrame(1).GetMethod(); string clsString = mb.DeclaringType.FullName; string mName = mb.Name; OperationLogBLL opOperationLog = new OperationLogBLL(); OperationLog modelOperationLog = new OperationLog(); modelOperationLog.BusinessType = businessType; modelOperationLog.RelationId = relationId; modelOperationLog.LogContent = logContent; modelOperationLog.Ip = System.Web.HttpContext.Current.Request.UserHostAddress; modelOperationLog.UserId = userId; modelOperationLog.RealName = realName; modelOperationLog.CreateDate = DateTime.Now; modelOperationLog.DepartmentId = departmentId; modelOperationLog.DepartmentName = departmentName; modelOperationLog.CreateDate = DateTime.Now; result = opOperationLog.Add(modelOperationLog); } catch (Exception ex) { ExceptionLogBLL.WriteExceptionLogToDB(ex.ToString()); } return(result); }
public void GetUsersList(HttpContext context) { UsersBLL usersbll = new UsersBLL(); List <UsersBackups> list = new List <UsersBackups>(); string LoginName = context.Request.QueryString["LoginName"]; string UsersName = context.Request.QueryString["UsersName"]; string Mobiles = context.Request.QueryString["Mobiles"]; string Where = " u.RecordIsDelete=0 "; DepartmentInfo df = new DepartmentInfo(); DepartmentInfoBLL bll = new DepartmentInfoBLL(); df = bll.GetModel(ComPage.CurrentAdmin.DepartmentID); if (ComPage.CurrentAdmin.UserType != 1) { if ((df == null) || (df != null && df.IsReceiveBusiness != false)) { Where += " AND u.UserID IN(select ID from [dbo].[GetDepartmentChildren](" + ComPage.CurrentAdmin.UserID + "))"; } } if (!string.IsNullOrEmpty(LoginName)) { Where += " AND LoginName like'%" + LoginName + "%' "; } if (!string.IsNullOrEmpty(Mobiles)) { Where += " AND phone like'%" + Mobiles + "%' "; } if (!string.IsNullOrEmpty(UsersName)) { Where += " AND UserName like'%" + UsersName + "%' "; } //if (!string.IsNullOrEmpty(UsersData) && UsersData != "") //{ // Where += " AND (LoginName like'" + UsersData + "%' or phone like'" + UsersData + "%' or UserName like '" + UsersData + "%') "; //} list = usersbll.GetModelListName(Where); var b = SerializerHelper.SerializeObject(new { data = list }); context.Response.Write(b); }
/// <summary> /// 获取用户列表 /// </summary> static public Object GetUsersList() { string result = string.Empty; try { string sEcho = JsonRequest.GetJsonKeyVal(jsonText, "sEcho"); int displayStart = ComPage.SafeToInt(JsonRequest.GetJsonKeyVal(jsonText, "iDisplayStart")); int displayLength = ComPage.SafeToInt(JsonRequest.GetJsonKeyVal(jsonText, "iDisplayLength")); int pageIndex = (displayStart / displayLength) + 1; int pageSize = displayLength; #region 获取列表 StringBuilder where = new StringBuilder(); where.Append("1=1 and u.RecordIsDelete=0 "); DepartmentInfo df = new DepartmentInfo(); DepartmentInfoBLL bll = new DepartmentInfoBLL(); df = bll.GetModel(ComPage.CurrentAdmin.DepartmentID); if (ComPage.CurrentAdmin.UserType != 1) { if ((df == null) || (df != null && df.IsReceiveBusiness != false)) { where.Append(" AND u. UserID IN(select ID from [BWJSDB].dbo.[GetDepartmentChildren](" + ComPage.CurrentAdmin.UserID + "))"); } } #region 条件搜索 string key = DNTRequest.GetString("searchKey"); if (string.IsNullOrEmpty(key)) { key = JsonRequest.GetJsonKeyVal(jsonText, "searchKey"); } string LoginName = DNTRequest.GetString("LoginName"); string UsersName = DNTRequest.GetString("UsersName"); string Mobiles = DNTRequest.GetString("Mobiles"); string DepartmentInfoID = DNTRequest.GetString("DepartmentInfoID"); if (string.IsNullOrEmpty(LoginName)) { LoginName = JsonRequest.GetJsonKeyVal(jsonText, "LoginName"); LoginName = System.Web.HttpContext.Current.Server.UrlDecode(LoginName); } if (string.IsNullOrEmpty(UsersName)) { UsersName = JsonRequest.GetJsonKeyVal(jsonText, "UsersName"); UsersName = System.Web.HttpContext.Current.Server.UrlDecode(UsersName); } if (string.IsNullOrEmpty(Mobiles)) { Mobiles = JsonRequest.GetJsonKeyVal(jsonText, "Mobiles"); Mobiles = System.Web.HttpContext.Current.Server.UrlDecode(Mobiles); } if (string.IsNullOrEmpty(DepartmentInfoID)) { DepartmentInfoID = JsonRequest.GetJsonKeyVal(jsonText, "DepartmentInfoID"); DepartmentInfoID = System.Web.HttpContext.Current.Server.UrlDecode(DepartmentInfoID); } if (!string.IsNullOrEmpty(LoginName)) { where.AppendFormat(" and u.LoginName like'{0}%' ", LoginName); } if (!string.IsNullOrEmpty(UsersName)) { where.AppendFormat(" and u.UserName like'{0}%' ", UsersName); } if (!string.IsNullOrEmpty(Mobiles)) { where.AppendFormat(" and u.Phone like'{0}%' ", Mobiles); } if (!string.IsNullOrEmpty(DepartmentInfoID) && DepartmentInfoID != "undefined" && DepartmentInfoID != "0") { where.AppendFormat(" and u.DepartmentID ={0} ", DepartmentInfoID); } #endregion string iSortCol_0 = JsonRequest.GetJsonKeyVal(jsonText, "iSortCol_0"); string sSortDir_0 = JsonRequest.GetJsonKeyVal(jsonText, "sSortDir_0"); int iSortingCols = ComPage.SafeToInt(JsonRequest.GetJsonKeyVal(jsonText, "iSortingCols")); string orderBy = string.Empty; if (!string.IsNullOrEmpty(iSortCol_0)) { string orderField = JsonRequest.GetJsonKeyVal(jsonText, string.Format("mDataProp_{0}", iSortCol_0)); orderBy = string.Format(" {0} {1}", orderField, sSortDir_0); } string sql = ""; int zys = 0; int sumcount = 0; UsersBLL Usersbll = new UsersBLL(); DataTable dt = Usersbll.GetList(where.ToString(), pageIndex, pageSize, orderBy, ref sql, ref zys, ref sumcount); /* * iTotalRecord = sumcount, * iTotalDisplayRecords = sumcount, */ object obj = new { result = true, code = "", msg = "", recordsTotal = sumcount, recordsFiltered = sumcount, data = ((dt == null) ? (new DataTable()) : (dt)), sEcho = sEcho, }; result = Newtonsoft.Json.JsonConvert.SerializeObject(obj); #endregion } catch (Exception ex) { result = DNTRequest.GetResultJson(false, "操作异常,请稍候再试", null); ExceptionLogBLL.WriteExceptionLogToDB(ex.ToString()); } return(result); }
/// <summary> /// 获取分利列表 /// </summary> static public Object GetOrderRebateList() { string result = string.Empty; try { string sEcho = JsonRequest.GetJsonKeyVal(jsonText, "sEcho"); int displayStart = ComPage.SafeToInt(JsonRequest.GetJsonKeyVal(jsonText, "iDisplayStart")); int displayLength = ComPage.SafeToInt(JsonRequest.GetJsonKeyVal(jsonText, "iDisplayLength")); int pageIndex = (displayStart / displayLength) + 1; int pageSize = displayLength; #region 获取列表 StringBuilder where = new StringBuilder(); where.Append("1=1 and ort.IsDeleted=0 "); DepartmentInfo df = new DepartmentInfo(); DepartmentInfoBLL bll = new DepartmentInfoBLL(); df = bll.GetModel(ComPage.CurrentAdmin.DepartmentID); if (ComPage.CurrentAdmin.UserType != 1) { if ((df == null) || (df != null && df.IsReceiveBusiness != false)) { //where.Append(" AND moa.UserID IN(select ID from [BWJSDB].dbo.[GetDepartmentChildren](" + ComPage.CurrentAdmin.UserID + "))"); where.Append(" AND moa.UserID IN(SELECT ID from[BWJSDB].dbo.[GetDepartmentChildren](" + ComPage.CurrentAdmin.UserID + "))"); } } #region 条件搜索 string key = DNTRequest.GetString("searchKey"); if (string.IsNullOrEmpty(key)) { key = JsonRequest.GetJsonKeyVal(jsonText, "searchKey"); } string val = DNTRequest.GetString("searchValue"); if (string.IsNullOrEmpty(val)) { val = JsonRequest.GetJsonKeyVal(jsonText, "searchValue"); val = System.Web.HttpContext.Current.Server.UrlDecode(val); } if (!string.IsNullOrEmpty(val)) { where.AppendFormat(" and (moa.InsureNum like'" + val + "%' or ort.TransNo like'" + val + "%') ", val); } #endregion string iSortCol_0 = JsonRequest.GetJsonKeyVal(jsonText, "iSortCol_0"); string sSortDir_0 = JsonRequest.GetJsonKeyVal(jsonText, "sSortDir_0"); int iSortingCols = ComPage.SafeToInt(JsonRequest.GetJsonKeyVal(jsonText, "iSortingCols")); string orderBy = string.Empty; if (!string.IsNullOrEmpty(iSortCol_0)) { string orderField = JsonRequest.GetJsonKeyVal(jsonText, string.Format("mDataProp_{0}", iSortCol_0)); orderBy = string.Format(" {0} {1}", orderField, sSortDir_0); } string sql = ""; int zys = 0; int sumcount = 0; OrderRebateBLL orderRebatebll = new OrderRebateBLL(); DataTable dt = orderRebatebll.GetList(where.ToString(), pageIndex, pageSize, orderBy, ref sql, ref zys, ref sumcount); /* * iTotalRecord = sumcount, * iTotalDisplayRecords = sumcount, */ object obj = new { result = true, code = "", msg = "", recordsTotal = sumcount, recordsFiltered = sumcount, data = ((dt == null) ? (new DataTable()) : (dt)), sEcho = sEcho, }; result = Newtonsoft.Json.JsonConvert.SerializeObject(obj); #endregion } catch (Exception ex) { result = DNTRequest.GetResultJson(false, "操作异常,请稍候再试", null); ExceptionLogBLL.WriteExceptionLogToDB(ex.ToString()); } return(result); }