public override List <AccountInfoVO> GetModels(ref AccountInfoPara mp)
{
string where = GetConditionByPara(mp);
int pStart = mp.PageIndex.Value * mp.PageSize.Value;
int pEnd = mp.PageSize.Value;
string cmd = QUERYPAGE
.Replace("@PAGESIZE", pEnd.ToString())
.Replace("@PTOP", pStart.ToString())
.Replace("@WHERE", where)
.Replace("@ORDER", GetOrderByPara(mp));
CodeCommand command = new CodeCommand();
command.CommandText = cmd;
var table = DbProxyFactory.Instance.Proxy.ExecuteTable(command);
List <AccountInfoVO> list = new List <AccountInfoVO>();
for (int i = 0; i < table.Rows.Count; i++)
{
list.Add(new AccountInfoVO(table.Rows[i]));
}
if (!mp.Recount.HasValue)
{
mp.Recount = GetRecords(mp);
}
return(list);
}
public override string GetOrderByPara(AccountInfoPara mp)
{
if (!string.IsNullOrEmpty(mp.OrderBy))
{
return(string.Format(" order by {0}", mp.OrderBy));
}
return("");
}
private void Bind()
{
AccountInfoPara up = new AccountInfoPara();
up.Id = Account.UserId;
var list = AccountInfoBLL.Instance.GetModels(up);
rptTable.DataSource = list;
rptTable.DataBind();
}
public override AccountInfoVO GetSingle(AccountInfoPara mp)
{
var list = GetModels(mp);
if (list.Count == 1)
{
return(list[0]);
}
return(null);
}
public override int GetRecords(AccountInfoPara mp)
{
string where = GetConditionByPara(mp);
CodeCommand command = new CodeCommand();
command.CommandText = QUERYCOUNT + where;
var result = DbProxyFactory.Instance.Proxy.ExecuteScalar(command);
return(int.Parse(result.ToString()));
}
/// <summary>
///
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public LoginResult Login(LoginInfo info)
{
LoginResult result = new LoginResult();
result.Msg = "正在登录";
AccountInfoPara ap = new AccountInfoPara();
ap.UserName = info.UserName;
var list = AccountInfoBLL.Instance.GetModels(ap);
foreach (var item in list)
{
if (item.UserPwd == DN.Framework.Utility.EncryptHelper.GetMd5(info.UserPwd))
{
if (item.IsLock == 0)
{
result.State = true;
result.Msg = "登录成功";
result.Data = item;
}
else
{
result.State = false;
result.Msg = "用户被锁定";
result.Data = item;
}
}
}
if (list.Count == 0)
{
result.Msg = "用户名不存在。";
}
else if (list.Count != 0)
{
if (!result.State)
{
result.Msg = "用户名或密码不正确，请重新输入。";
}
}
LogLoginVO log = new LogLoginVO();
log.BrowseType = DN.Framework.Utility.ClientHelper.GetBrowseInfo();
log.ClientIp = DN.Framework.Utility.ClientHelper.ClientIP();
log.LoginDate = DateTime.Now;
log.LoginDesc = result.Msg;
log.LoginName = info.UserName;
log.LoginState = result.State ? 1 : 0;
LogLoginBLL.Instance.Add(log);
return result;
}
private void Bind(int pageIndex = 1)
{
AccountInfoPara cip = new AccountInfoPara();
cip.OrderBy = " id desc ";
cip.UserType = 1;
var list = AccountInfoBLL.Instance.GetModels(cip);
rptTable.DataSource = list;
rptTable.DataBind();
BindExitFile();
}
private void Bind(int pageIndex = 1)
{
AccountInfoPara cip = new AccountInfoPara();
cip.PageIndex = pageIndex - 1;
cip.PageSize = 10;
cip.OrderBy = " id desc ";
cip.IsLock = 0;
var list = AccountInfoBLL.Instance.GetModels(ref cip);
rptTable.DataSource = list;
rptTable.DataBind();
apPager.RecordCount = cip.Recount.Value;
}
public override bool Delete(AccountInfoPara mp)
{
string where = GetConditionByPara(mp);
CodeCommand command = new CodeCommand();
command.CommandText = DELETE + where;
int result = DbProxyFactory.Instance.Proxy.ExecuteNonQuery(command);
if (result >= 1)
{
return(true);
}
return(false);
}
protected void btnSave_Click(object sender, EventArgs e)
{
AccountInfoVO info = new AccountInfoVO();
info.AccountType = 0;
info.ConsumptionMoney = 0;
info.Email = txtEmail.Value;
info.LastLoginDate = DateTime.Now;
info.LastMoneyDate = DateTime.Now;
info.Money = 0;
info.MoneyCount = 0;
info.MoneyFree = 0;
info.NickName = txtUserName.Value;
info.Phone = txtPhone.Value;
info.RegDate = DateTime.Now;
info.RegIp = DN.Framework.Utility.ClientHelper.ClientIP();
info.UserImg = "";
info.UserName = txtUserName.Value;
info.UserType = int.Parse(ddlUserType.SelectedValue);
info.UserPwd = DN.Framework.Utility.EncryptHelper.GetMd5(txtPwd.Value);
info.IsLock = chkIsLock.Checked ? 1 : 0;
AccountInfoPara ap = new AccountInfoPara();
ap.UserName = info.UserName;
var list = AccountInfoBLL.Instance.GetModels(ap);
if (list.Count == 0)
{
AccountInfoBLL.Instance.Add(info);
Response.Redirect("/Admin/Users/UserList.aspx");
}
else
{
lblMsg.Text = "【登录名称】登录名称己经存在，请重新输入。";
}
}
public static string GetConditionByPara(AccountInfoPara mp)
{
StringBuilder sb = new StringBuilder();
if (mp.UserTypes != null && mp.UserTypes.Count != 0)
{
sb.AppendFormat(" AND UserType IN ({0})", string.Join(",", mp.UserTypes));
}
if (mp.IsNotAdmin.HasValue)
{
if (mp.IsNotAdmin.Value)
{
sb.AppendFormat(" AND UserType <> 100 ");
}
else
{
sb.AppendFormat(" AND UserType = 100 ");
}
}
return(sb.ToString());
}
public override List <AccountInfoVO> GetModels(AccountInfoPara mp)
{
string where = GetConditionByPara(mp);
CodeCommand command = new CodeCommand();
string cmd = LOAD
.Replace("@WHERE", where)
.Replace("@ORDER", GetOrderByPara(mp));
command.CommandText = cmd;
var table = DbProxyFactory.Instance.Proxy.ExecuteTable(command);
List <AccountInfoVO> list = new List <AccountInfoVO>();
for (int i = 0; i < table.Rows.Count; i++)
{
list.Add(new AccountInfoVO(table.Rows[i]));
}
return(list);
}
public override string GetOtherConditionByPara(AccountInfoPara mp)
{
return("");
}
public override string GetConditionByPara(AccountInfoPara mp)
{
StringBuilder sb = new StringBuilder();
if (mp.Id.HasValue)
{
sb.AppendFormat(" AND [Id]='{0}' ", mp.Id);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.UserName)))
{
sb.AppendFormat(" AND [UserName]='{0}' ", mp.UserName);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.NickName)))
{
sb.AppendFormat(" AND [NickName]='{0}' ", mp.NickName);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.Email)))
{
sb.AppendFormat(" AND [Email]='{0}' ", mp.Email);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.Phone)))
{
sb.AppendFormat(" AND [Phone]='{0}' ", mp.Phone);
}
if (mp.UserType.HasValue)
{
sb.AppendFormat(" AND [UserType]='{0}' ", mp.UserType);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.UserPwd)))
{
sb.AppendFormat(" AND [UserPwd]='{0}' ", mp.UserPwd);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.UserImg)))
{
sb.AppendFormat(" AND [UserImg]='{0}' ", mp.UserImg);
}
if (mp.RegDate.HasValue)
{
sb.AppendFormat(" AND [RegDate]='{0}' ", mp.RegDate);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.RegIp)))
{
sb.AppendFormat(" AND [RegIp]='{0}' ", mp.RegIp);
}
if (mp.IsLock.HasValue)
{
sb.AppendFormat(" AND [IsLock]='{0}' ", mp.IsLock);
}
if (mp.LastLoginDate.HasValue)
{
sb.AppendFormat(" AND [LastLoginDate]='{0}' ", mp.LastLoginDate);
}
if (mp.AccountType.HasValue)
{
sb.AppendFormat(" AND [AccountType]='{0}' ", mp.AccountType);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.OpenId)))
{
sb.AppendFormat(" AND [OpenId]='{0}' ", mp.OpenId);
}
if (mp.ConsumptionMoney.HasValue)
{
sb.AppendFormat(" AND [ConsumptionMoney]='{0}' ", mp.ConsumptionMoney);
}
if (mp.Money.HasValue)
{
sb.AppendFormat(" AND [Money]='{0}' ", mp.Money);
}
if (mp.MoneyFree.HasValue)
{
sb.AppendFormat(" AND [MoneyFree]='{0}' ", mp.MoneyFree);
}
if (mp.MoneyCount.HasValue)
{
sb.AppendFormat(" AND [MoneyCount]='{0}' ", mp.MoneyCount);
}
if (mp.LastMoneyDate.HasValue)
{
sb.AppendFormat(" AND [LastMoneyDate]='{0}' ", mp.LastMoneyDate);
}
sb.AppendLine(AccountInfoAccessOther.GetConditionByPara(mp));
sb.Insert(0, " WHERE 1=1 ");
return(sb.ToString());
}
