public ADeeWu.HuoBi3J.Model.Users[] GetEntityList(string orderBy,string[] columns,params object[] values)
{
StringBuilder builder = new StringBuilder();
builder.Append("select * from [Users] where 1=1");
db.Parameters.Clear();
for(int i=0;i<columns.Length;i++)
{
builder.AppendFormat(" and [{0}]=@{0}", columns[i]);
db.Parameters.Append("@"+columns[i],values[i]);
}
if (!string.IsNullOrEmpty(orderBy))
{
builder.AppendFormat(" order by {0}", orderBy);
}
DataTable dt = db.Select(builder.ToString());
ADeeWu.HuoBi3J.Model.Users[] EntityList = new ADeeWu.HuoBi3J.Model.Users[dt.Rows.Count];
if (dt.Rows.Count == 0) return EntityList;
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow dr = dt.Rows[i];
ADeeWu.HuoBi3J.Model.Users Entity = new ADeeWu.HuoBi3J.Model.Users();
Entity.ID = long.Parse(dr["ID"].ToString());
Entity.UserType = int.Parse(dr["UserType"].ToString());
Entity.UIN = (string)(dr["UIN"]);
Entity.LoginName = (string)(dr["LoginName"]);
Entity.LoginPwd = (string)(dr["LoginPwd"]);
Entity.Money = decimal.Parse(dr["Money"].ToString());
Entity.Coins = decimal.Parse(dr["Coins"].ToString());
Entity.Points = int.Parse(dr["Points"].ToString());
Entity.AlipayAccount = (string)(dr["AlipayAccount"]);
Entity.ProvinceID = long.Parse(dr["ProvinceID"].ToString());
Entity.CityID = long.Parse(dr["CityID"].ToString());
Entity.AreaID = long.Parse(dr["AreaID"].ToString());
Entity.Province = (string)(dr["Province"]);
Entity.City = (string)(dr["City"]);
Entity.Area = (string)(dr["Area"]);
Entity.CheckState = int.Parse(dr["CheckState"].ToString());
Entity.LastLoginIP = (string)(dr["LastLoginIP"]);
Entity.LastLogin = DateTime.Parse(dr["LastLogin"].ToString());
Entity.LoginTimes = int.Parse(dr["LoginTimes"].ToString());
Entity.RegTime = DateTime.Parse(dr["RegTime"].ToString());
Entity.Name = (string)(dr["Name"]);
Entity.Tel = (string)(dr["Tel"]);
Entity.Email = (string)(dr["Email"]);
EntityList[i] = Entity;
}
return EntityList;
}
protected void Page_Load(object sender, System.EventArgs e)
{
long realBusinessUserID = this.GetRealBusinessUserID();
entUser = dalUser.GetEntity(realBusinessUserID);
if (entUser == null)
{
ADeeWu.HuoBi3J.Libary.WebUtility.ShowMsg("当前用户数据已被删除!");
return;
}
if (!IsPostBack)
{
//检测是否已提交申请转帐
if (dalApplication.Exist(
string.Format("UserID={0} and CheckState <> 1", entUser.ID)
))
{
ADeeWu.HuoBi3J.Libary.WebUtility.ShowMsg("不能重复提交申请,您已提交的申请还没有处理!");
this.litMsg.Text = "不能重复提交申请,您已提交的申请还没有处理!";
this.btnSubmit.Enabled = false;
}
this.litSpareMoney.Text = entUser.Money.ToString() + "元";
if (entUser.Money >= GlobalParameter.MinTransferMoney)
{
this.litTransferMoney.Visible = false;
this.phTxtTransferMoney.Visible = true;
}
else
{
this.litTransferMoney.Visible = true;
this.phTxtTransferMoney.Visible = false;
this.litTransferMoney.Text = string.Format("当前余额不足转帐最低金额:<span style='color:#f00'>{0} </span>元", GlobalParameter.MinTransferMoney);
this.btnSubmit.Enabled = false;
}
this.txtAlipayAccount.Text = entUser.AlipayAccount;
}
}
public ADeeWu.HuoBi3J.Model.Users GetEntity(string where)
{
DataTable dt = this.Select(where,"");
if(dt.Rows.Count==0) return null;
DataRow dr = dt.Rows[0];
ADeeWu.HuoBi3J.Model.Users Entity = new ADeeWu.HuoBi3J.Model.Users();
Entity.ID = long.Parse(dr["ID"].ToString());
Entity.UserType = int.Parse(dr["UserType"].ToString());
Entity.UIN = (string)(dr["UIN"]);
Entity.LoginName = (string)(dr["LoginName"]);
Entity.LoginPwd = (string)(dr["LoginPwd"]);
Entity.Money = decimal.Parse(dr["Money"].ToString());
Entity.Coins = decimal.Parse(dr["Coins"].ToString());
Entity.Points = int.Parse(dr["Points"].ToString());
Entity.AlipayAccount = (string)(dr["AlipayAccount"]);
Entity.ProvinceID = long.Parse(dr["ProvinceID"].ToString());
Entity.CityID = long.Parse(dr["CityID"].ToString());
Entity.AreaID = long.Parse(dr["AreaID"].ToString());
Entity.Province = (string)(dr["Province"]);
Entity.City = (string)(dr["City"]);
Entity.Area = (string)(dr["Area"]);
Entity.CheckState = int.Parse(dr["CheckState"].ToString());
Entity.LastLoginIP = (string)(dr["LastLoginIP"]);
Entity.LastLogin = DateTime.Parse(dr["LastLogin"].ToString());
Entity.LoginTimes = int.Parse(dr["LoginTimes"].ToString());
Entity.RegTime = DateTime.Parse(dr["RegTime"].ToString());
Entity.Name = (string)(dr["Name"]);
Entity.Tel = (string)(dr["Tel"]);
Entity.Email = (string)(dr["Email"]);
return Entity;
}
