public static DataTable SearchUser(XiHuan_UserSearchFilter f, out int rowcount)
{
int minId = f.PageIndex * f.PageSize;
int maxId = (f.PageIndex + 1) * f.PageSize + 1;
string sql = @"DECLARE @indextable table(Id int identity(1,1) PRIMARY KEY,uid int);
insert into @indextable(uid) select Id from XiHuan_UserInfo with(nolock) where IsLocked=0 {0};
select @@ROWCOUNT;
select {1} from XiHuan_UserInfo u with(nolock) inner join @indextable t on u.Id=t.uid
and t.Id>{2} and t.Id<{3} ";
StringBuilder sqlwhere = new StringBuilder("");
if (f.UserName.Trim().Length > 0)
{
sqlwhere.AppendFormat(" AND UserName like'%{0}%' ", ValidatorHelper.SafeSql(f.UserName.Trim()));
}
if (f.ProvinceId != int.MaxValue)
{
sqlwhere.AppendFormat(" AND ProvinceId={0} ", f.ProvinceId);
}
if (f.CityId != int.MaxValue)
{
sqlwhere.AppendFormat(" AND CityId={0} ", f.CityId);
}
if (f.AreaId != int.MaxValue)
{
sqlwhere.AppendFormat(" AND AreaId={0} ", f.AreaId);
}
if (f.SchooId != int.MaxValue)
{
sqlwhere.AppendFormat(" AND SchoolId={0} ", f.SchooId);
}
if (f.IsStartUser != int.MaxValue)
{
sqlwhere.AppendFormat(" AND IsStarUser={0} ", f.IsStartUser);
}
if (f.Gender != int.MaxValue)
{
sqlwhere.AppendFormat(" AND Gender={0} ", f.Gender);
}
if (f.IsHavePhoto != int.MaxValue)
{
sqlwhere.Append(" AND HeadImage <> 'images/nophoto.gif'");
}
if (f.CreateDateBegin != DateTime.MinValue)
{
sqlwhere.AppendFormat(" AND RegisterDate>='{0}' ", f.CreateDateBegin);
}
if (f.CreateDateEnd != DateTime.MaxValue)
{
sqlwhere.AppendFormat(" AND RegisterDate<'{0}' ", f.CreateDateEnd.AddDays(1));
}
DataSet ds = Query.ProcessMultiSql(string.Format(sql, sqlwhere.ToString() + " order by " + f.OrderByParam, f.SelectFileds, minId, maxId), GlobalVar.DataBase_Name);
rowcount = CommonMethodFacade.ConvertToInt(ds.Tables[0].Rows[0][0], 0);
return(ds.Tables[1]);
}
public static int GetNewChangeRequireCount(int uid)
{
Query require = new Query(typeof(XiHuan_UserGoodsChangeRequireEntity));
Condition c = require.GetQueryCondition();
c.AddEqualTo(XiHuan_UserGoodsChangeRequireEntity.__OWNERID, uid);
c.AddEqualTo(XiHuan_UserGoodsChangeRequireEntity.__FLAG, ChangeRequireState.新发起.ToString("d"));
require.SelectCount(XiHuan_MessageEntity.__ID, "requirecount");
return(CommonMethodFacade.ConvertToInt(require.ExecuteScalar(), 0));
}
/// <summary>
/// 判断用户名是否已经被占用,被占用返回TRUE，否则False
/// </summary>
/// <param name="username">用户名</param>
/// <returns>被占用返回TRUE，否则False</returns>
public static bool IsUserNameAlreayUse(string username)
{
username = CommonMethodFacade.FinalString(username);
Query checkuser = new Query(typeof(XiHuan_UserInfoEntity));
Condition c = checkuser.GetQueryCondition();
c.AddEqualTo(XiHuan_UserInfoEntity.__USERNAME, username);
checkuser.SelectCount(XiHuan_UserInfoEntity.__ID, "usercount");
return(Convert.ToInt32(checkuser.ExecuteScalar()) > 0);
}
public static int GetNewNotesCount(int uid)
{
Query notes = new Query(typeof(XiHuan_GuestBookEntity));
Condition c = notes.GetQueryCondition();
c.AddEqualTo(XiHuan_GuestBookEntity.__TOID, uid);
c.AddEqualTo(XiHuan_GuestBookEntity.__ISCHECKED, 1);
notes.SelectCount(XiHuan_GuestBookEntity.__ID, "notescount");
return(CommonMethodFacade.ConvertToInt(notes.ExecuteScalar(), 0));
}
public static string GetSchoolNameById(string pid, string cid, string sid)
{
DataTable dt = ProvinceCityFacade.GetInstance().GetSchoolInfo(pid, cid);
DataRow[] dr = dt.Select("Id=" + sid);
if (dr.Length > 0)
{
return(CommonMethodFacade.FinalString(dr[0]["SchoolName"]));
}
else
{
return(string.Empty);
}
}
public static string GetProvinceNameById(string pid)
{
DataTable dt = ProvinceCityFacade.GetInstance().GetProvince();
DataRow[] dr = dt.Select("provinceID=" + pid);
if (dr.Length > 0)
{
return(CommonMethodFacade.FinalString(dr[0]["province"]));
}
else
{
return(string.Empty);
}
}
public static string GetAreaNameById(string aid)
{
DataTable dt = ProvinceCityFacade.GetInstance().GetAreaInfo("");
DataRow[] dr = dt.Select("areaId=" + aid);
if (dr.Length > 0)
{
return(CommonMethodFacade.FinalString(dr[0]["area"]));
}
else
{
return(string.Empty);
}
}
public static int GetIdByName(string uname)
{
uname = CommonMethodFacade.FinalString(uname);
RetrieveCriteria rc = new RetrieveCriteria(typeof(XiHuan_UserInfoEntity));
Condition c = rc.GetNewCondition();
c.AddEqualTo(XiHuan_UserInfoEntity.__USERNAME, uname);
rc.AddSelect(XiHuan_UserInfoEntity.__ID);
XiHuan_UserInfoEntity user = rc.AsEntity() as XiHuan_UserInfoEntity;
if (user != null)
{
return(user.ID);
}
else
{
return(0);
}
}
/// <summary>
/// 发送邮件
/// </summary>
/// <param name="maito">接收人，多个接收人，用逗号隔开</param>
/// <param name="subject">标题</param>
/// <param name="body">内容</param>
public static void sendEmail(string maito, string subject, string body)
{
//发邮件的账号
string mailsender = CommonMethodFacade.GetConfigValue("EmailSender");
//显示的账号名称
string maildisplayname = CommonMethodFacade.GetConfigValue("EmailDisplayName");
//使用的SMTP主机
string mailhost = CommonMethodFacade.GetConfigValue("EmailSmtpHost");
// 账号密码
string mailpwd = CommonMethodFacade.GetConfigValue("EmailSmtpPassword");
System.Net.Mail.MailMessage msg = new System.Net.Mail.MailMessage();
msg.From = new MailAddress(mailsender, maildisplayname, Encoding.UTF8);
string[] mailto = maito.Split(';');
MailAddressCollection addcollection = new MailAddressCollection();
for (int i = 0; i < mailto.Length; i++)
{
if (ValidatorHelper.IsEmail(mailto[i]))
{
msg.To.Add(new MailAddress(mailto[i]));
}
}
msg.Subject = subject;
msg.Body = body;
msg.IsBodyHtml = true; //设置正文是否为html格式的值
msg.Priority = System.Net.Mail.MailPriority.High; //设置此邮件具有高优先级
SmtpClient smtp = new SmtpClient(mailhost); //允许应用程序使用SMTP发邮件
smtp.Credentials = new System.Net.NetworkCredential(mailsender, mailpwd); //设置验证发件人的凭据（邮件服务器需要身份验证）
smtp.Timeout = 60 * 1000; //设定超时时间为1分钟
try
{
smtp.Send(msg); //发信
msg.Dispose(); //释放有MailMessage使用的所有资源
}
catch
{
}
}
public static bool IsUserValid(string uname, string upass)
{
uname = CommonMethodFacade.FinalString(uname);
upass = CommonMethodFacade.FinalString(upass);
if (uname.Length > 0 && upass.Length > 0)
{
string sqlLogin = @"UPDATE XiHuan_UserInfo SET LastLoginTime=getdate(),
Score=Score+(CASE WHEN LastLoginTime<'{0}' THEN {1} ELSE 0 END )
WHERE UserName='******' AND OrignalPwd='{3}' ;";
int effcount = Query.ProcessSqlNonQuery(string.Format(sqlLogin, DateTime.Now.ToString("yyyy-MM-dd"),
SystemConfigFacade.Instance().LoginAddScore(), ValidatorHelper.SafeSql(uname),
ValidatorHelper.SafeSql(upass)),
GlobalVar.DataBase_Name);
return(effcount > 0);
}
else
{
return(false);
}
}
public DataTable GetGoodsChildType(string parentid)
{
this.dtinfo = this.dtChildTypeInfo.Clone();
if (CommonMethodFacade.FinalString(parentid).Length > 0)
{
DataRow[] dr = this.dtChildTypeInfo.Select("ParentId=" + parentid);
foreach (DataRow row in dr)
{
DataRow newrow = dtinfo.NewRow();
newrow["Id"] = row["Id"];
newrow["Name"] = row["Name"];
dtinfo.Rows.Add(newrow);
}
return(this.dtinfo);
}
else
{
return(this.dtChildTypeInfo);
}
}
public DataTable GetSchoolInfo(string pid, string cid)
{
pid = CommonMethodFacade.FinalString(pid);
cid = CommonMethodFacade.FinalString(cid);
if (pid.Length == 0 && cid.Length == 0)
{
return(this.schoolDt);
}
else
{
string filter = string.Empty;
schoolInfo = schoolDt.Clone();
if (pid.Length > 0 && cid.Length > 0)
{
filter += string.Format("ProvinceId={0} and CityId={1} ", pid, cid);
}
else
{
if (pid.Length > 0)
{
filter += string.Format("ProvinceId={0} ", pid);
}
if (cid.Length > 0)
{
filter += string.Format("CityId={0} ", cid);
}
}
DataRow[] schoolrow = schoolDt.Select(filter);
foreach (DataRow row in schoolrow)
{
DataRow newschoolrow = schoolInfo.NewRow();
newschoolrow["SchoolName"] = row["SchoolName"];
newschoolrow["Id"] = row["Id"];
newschoolrow["ProvinceId"] = row["ProvinceId"];
newschoolrow["CityId"] = row["CityId"];
schoolInfo.Rows.Add(newschoolrow);
}
return(this.schoolInfo);
}
}
public static string GetCityNameById(string cid)
{
string result = string.Empty;
DataTable dt = ProvinceCityFacade.GetInstance().GetCityInfo("");
DataRow[] dr = dt.Select("cityID=" + cid);
if (dr.Length > 0)
{
result = CommonMethodFacade.FinalString(dr[0]["city"]);
}
else
{
dr = dt.Select("father=" + cid);
if (dr.Length > 0)
{
result = CommonMethodFacade.FinalString(dr[0]["city"]);
}
}
return(result);
}
public DataTable GetAreaInfo(string cid)
{
cid = CommonMethodFacade.FinalString(cid);
if (cid.Length > 0)
{
this.areaInfo = areaDt.Clone();
DataRow[] arearow = areaDt.Select("father='" + cid + "'");
foreach (DataRow row in arearow)
{
DataRow newarearow = areaInfo.NewRow();
newarearow["area"] = row["area"];
newarearow["areaId"] = row["areaId"];
areaInfo.Rows.Add(newarearow);
}
return(areaInfo);
}
else
{
return(this.areaDt);
}
}
/// <summary>
/// 悄悄话是否可见
/// </summary>
/// <param name="fromid">留言人Id</param>
/// <param name="toid">留言对象Id</param>
/// <param name="uid">当前人Id</param>
/// <param name="issceret">是否悄悄话</param>
/// <returns>是否需要显示留言内容</returns>
public static bool IsSceretNoteShow(string fromid, string toid, string uid, string issceret)
{
fromid = CommonMethodFacade.FinalString(fromid);
toid = CommonMethodFacade.FinalString(toid);
issceret = CommonMethodFacade.FinalString(issceret);
if (issceret.Equals("1"))
{
if (uid.Equals("0"))
{
return(false);
}
else
{
return(uid == fromid || uid == toid);
}
}
else
{
return(true);
}
}
public DataTable GetCityInfo(string pid)
{
pid = CommonMethodFacade.FinalString(pid);
if (pid.Length > 0)
{
this.cityInfo = cityDt.Clone();
DataRow[] cityrow = cityDt.Select("father='" + pid + "'");
foreach (DataRow row in cityrow)
{
DataRow newcityrow = cityInfo.NewRow();
newcityrow["city"] = row["city"];
newcityrow["cityId"] = row["cityId"];
newcityrow["father"] = row["father"];
cityInfo.Rows.Add(newcityrow);
}
return(cityInfo);
}
else
{
return(this.cityDt);
}
}
public int RegisterAddScore()
{
DataRow[] dr = dt.Select("ConfigKey='RegisterAddScore'");
return(dr.Length > 0 ? CommonMethodFacade.ConvertToInt(dr[0]["ConfigValue"], 0) : 0);
}
public int TuiJianAddHuanBi()
{
DataRow[] dr = dt.Select("ConfigKey='TuiJianAddHuanBi'");
return(dr.Length > 0 ? CommonMethodFacade.ConvertToInt(dr[0]["ConfigValue"], 0) : 0);
}
public string RegMesContent()
{
DataRow[] dr = dt.Select("ConfigKey='RegisterMessageContent'");
return(dr.Length > 0 ? CommonMethodFacade.FinalString(dr[0]["ConfigValue"]) : string.Empty);
}
public int AddHBByAddGoods()
{
DataRow[] dr = dt.Select("ConfigKey='AddGoodsHuanBi'");
return(dr.Length > 0 ? CommonMethodFacade.ConvertToInt(dr[0]["ConfigValue"], 0) : 0);
}
