public async Task <dynamic> DeletedFirstOrDefault([FromUri] UserInfoFilter filter)
{
filter = filter ?? new UserInfoFilter();
var result = await _sqlData.UserInfo.DeletedFirstOrDefault(filter);
return(new { Result = JsonConvert.DeserializeObject(result) });
}
public IQueryable <UserInfo> LoadSearchUserInfo(UserInfoFilter userInfoFilter)
{
var temp = this.DbSession.ModelInfoDal("UserInfoDal").LoadEntities(c => true);
if (!string.IsNullOrEmpty(userInfoFilter.UName))
{
temp = temp.Where <UserInfo>(u => u.UName.Contains(userInfoFilter.UName));
}
if (!string.IsNullOrEmpty(userInfoFilter.URemark))
{
temp = temp.Where <UserInfo>(u => u.Remark.Contains(userInfoFilter.URemark));
}
userInfoFilter.TotalCount = temp.Count();
return(temp.OrderBy <UserInfo, string>(u => u.Sort).Skip <UserInfo>((userInfoFilter.PageIndex - 1) * userInfoFilter.PageSize).Take <UserInfo>(userInfoFilter.PageSize));
}
public int InsertOrUpdateUser(UserInfoFilter userInfo)
{
IDataReader dataReader = null;
try
{
Database db = DatabaseFactory.CreateDatabase("DbConnection");
int currentDate = 0;
int currentTime = 0;
Common.GetCurrentDateTime(out currentDate, out currentTime);
dataReader = BillingDAL.CheckUserNameExists(db, userInfo.UserID, userInfo.UserName);
if (dataReader.Read())
{
dataReader.Close();
return(-1); //username already exists
}
else
{
dataReader.Close();
if (userInfo.UserID > 0)
{
BillingDAL.UpdateUser(db, userInfo.UserID, userInfo.Password, userInfo.FirstName, userInfo.LastName, userInfo.LoginUserID, currentDate, currentTime);
return(userInfo.UserID);
}
else
{
return(BillingDAL.InsertUser(db, userInfo.UserName, userInfo.Password, userInfo.FirstName, userInfo.LastName, userInfo.LoginUserID, currentDate, currentTime));
}
}
}
catch (Exception ex)
{
Common.LogException(ex);
throw new WebFaultException <string>(ex.Message, HttpStatusCode.InternalServerError);
}
finally
{
if (dataReader != null && !dataReader.IsClosed)
{
dataReader.Close();
}
}
}
public ActionResult GetUserInfo()
{
int pageIndex = int.Parse(Request["page"]); //当前页码
int pageSize = int.Parse(Request["rows"]); //当前每页显示记录数
int totalCount = 0;
short deleteType = (short)DeleteEnumType.Normal; //标记 0正常，1逻辑，2物理
if (Request["DoTheSearch"] == "true")
{
string name = Request["name"]; //接收用户名
string remark = Request["remark"]; //接收备注
string email = Request["email"]; //接收邮箱
string phoneNumber = Request["phoneNumber"]; //接收手机号码
UserInfoFilter userInfoFilter = new UserInfoFilter() //构建用户搜索过滤的条件
{
UName = name,
URemark = remark,
UEmail = email,
UPhoneNumber = phoneNumber,
PageIndex = pageIndex,
PageSize = pageSize,
TotalCount = totalCount
};
var userInfoList = userInfoService.LoadSearchUserInfo(userInfoFilter);
var temp = from u in userInfoList
select new { ID = u.ID, UName = u.UName, UPwd = u.UPwd, TUPwd = u.TUPwd, UEmail = u.UEmail, UPhoneNumber = u.UPhoneNumber, Remark = u.Remark, SubTime = u.SubTime, ModifiedOn = u.ModifiedOn, DelFlag = u.DelFlag, Sort = u.Sort };
return(Json(new { rows = temp, total = userInfoFilter.TotalCount }, JsonRequestBehavior.AllowGet));
}
else
{
var userInfoList = userInfoService.LoadPageEntities <int>(pageIndex, pageSize, out totalCount, c => c.DelFlag == deleteType, c => c.ID, true);
var temp = from u in userInfoList
select new { ID = u.ID, UName = u.UName, UPwd = u.UPwd, TUPwd = u.TUPwd, UEmail = u.UEmail, UPhoneNumber = u.UPhoneNumber, Remark = u.Remark, SubTime = u.SubTime, ModifiedOn = u.ModifiedOn, DelFlag = u.DelFlag, Sort = u.Sort };
return(Json(new { rows = temp, total = totalCount }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult GetUserInfo()
{
int pageIndex = int.Parse(Request["page"]);
int pageSize = int.Parse(Request["rows"]);
int totalCount = 0;
string name = Request["name"];
string remark = Request["remark"];
UserInfoFilter userInfoFilter = new UserInfoFilter()
{
UName = name,
URemark = remark,
PageIndex = pageIndex,
PageSize = pageSize,
TotalCount = totalCount
};
var userlist = userInfoService.LoadSearchUserInfo(userInfoFilter);
// short deletetype = (short)DeleteEnumType.Nomal;
// var userlist = userInfoService.LoadPageEntities<string>(pageIndex, pageSize, out totalCount, c => c.DelFlag == deletetype, c => c.Sort, true);
var temp = from u in userlist
select new { ID = u.ID, UName = u.UName, UPwd = u.UPwd, Remark = u.Remark, SubTime = u.SubTime, DelFlag = u.DelFlag, Sort = u.Sort };
return(Json(new { rows = temp, total = userInfoFilter.TotalCount }, JsonRequestBehavior.AllowGet));
}
