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); }