/// <summary>
/// 公司页面，添加或选择公司
/// </summary>
/// <param name="session">用户session</param>
/// <param name="companyName">公司全名称</param>
/// <returns></returns>
public string AddOrSelectCompany_EditCompany(string session, string companyName)
{
string resultStr = "";
Common.Logger.Error("AddOrSelectCompany_EditCompany方法获取到的参数session：" + session + "---companyName:" + companyName);
//公司表查看数据库是否有此公司，1有的话就给session用户绑定上此公司，2没有的话就先给公司表添加公司再给session用户绑定公司
//获取公司ID (调用AddOrSelectCompany方法即可)
string companyID = AddOrSelectCompany(companyName);
Common.Logger.Error("AddOrSelectCompany_EditCompany方法获取公司ID为：" + companyID);
//通过session修改个人绑定的公司ID
SB_UserEL userEL = new SB_UserEL();
userEL.CompanyID = long.Parse(companyID);
userEL.Session_True = session;
int ra;
long excuteUpdate = userEL.ExecNonQuery(26, out ra);
Common.Logger.Error("AddOrSelectCompany_EditCompany方法用户绑定公司结果为（大于0成功）：" + excuteUpdate);
if (ra > 0)
{
resultStr = "success";
}
else
{
resultStr = "error";
}
return(resultStr);
}
/// <summary>
/// 获取本人公司信息
/// </summary>
/// <param name="session">用户session</param>
/// <returns></returns>
public string GetMyCompanyInfo(string session)
{
HF.Cloud.BLL.Common.Logger.Error("GetMyCompanyInfo方法接受的参数session：" + session);
JavaScriptSerializer js = new JavaScriptSerializer();
Dictionary <string, object> dic = new Dictionary <string, object>();
//通过session获取CompanyID
SB_UserEL userEl = new SB_UserEL();
userEl.Session_True = session;
userEl.ExecuteEL(41);
HF.Cloud.BLL.Common.Logger.Error("GetMyCompanyInfo方法查询用户信息结果(大于0说明正确)：" + userEl.ID);
if (userEl.ID > 0)
{
long companyID = userEl.CompanyID;
//通过公司ID获取公司信息
CompanysEL companysEL = new CompanysEL();
companysEL.ID = companyID;
companysEL.ExecuteEL(2);
HF.Cloud.BLL.Common.Logger.Error("GetMyCompanyInfo方法查询公司信息结果公司名称：" + companysEL.CompanyName);
dic.Add("CompanyID", companyID);
dic.Add("CompanyName", companysEL.CompanyName);
dic.Add("CompanyIcon", companysEL.CompanyIcon);
dic.Add("Introduce", companysEL.Introduce);
//通过companyID获取公司关键字
string companyTags = GetCompanyTag_String(companyID.ToString());
dic.Add("Tags", companyTags);
}
string strJson = js.Serialize(dic);
HF.Cloud.BLL.Common.Logger.Error("GetMyCompanyInfo方法返回的用户信息json数据：" + strJson);
return(strJson);
}
/// <summary>
/// 获取个人小程序码图片
/// </summary>
/// <param name="path">小程序码跳转的路径</param>
/// <param name="session">用户session</param>
/// <returns></returns>
public string GetUserQRCode(string path, string session)
{
HF.Cloud.BLL.Common.Logger.Error("GetUserQRCode方法,参数path：" + path + "------session:" + session);
string imgPath = "";
//判断数据库中是否有值
SB_UserEL userEL = GetUserELBySession(session);
//如果QRCode有值，则返回数据库中QRCode的值
if (!string.IsNullOrEmpty(userEL.QRCode) && userEL.QRCode != "")
{
//获取图片名称
string qrCodeImageName = userEL.QRCode;
//获取图片路径
string qrCodeImagePath = System.Configuration.ConfigurationManager.AppSettings["QRCodeGet_User"];
imgPath = qrCodeImagePath + qrCodeImageName;
}
//数据库中QRCode没有数据，则需要获取小程序码图片保存图片，并把图片名称保存到数据库中
else
{
//获取token
WX_TokenBLL tokenBLL = new WX_TokenBLL();
string token = tokenBLL.GetToken();
//获取小程序码接口
string url = "https://api.weixin.qq.com/wxa/getwxacode?access_token=" + token;
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("path", path);
JavaScriptSerializer js = new JavaScriptSerializer();
js.MaxJsonLength = int.MaxValue;
string json = js.Serialize(dic);
HF.Cloud.BLL.Common.Logger.Error("GetUserQRCode方法,获取小程序码的json：" + json);
HF.Cloud.BLL.Common.Logger.Error("GetUserQRCode方法,url：" + url + "-----Path:" + path);
//post返回的小程序码流
Stream QRCodeStream = WeChatAppDecrypt.Post(url, json);
//将图片流转换成图片
Bitmap tp = new Bitmap(QRCodeStream);
string QRCodeSave_User = System.Configuration.ConfigurationManager.AppSettings["QRCodeSave_User"];
string image_userName = Guid.NewGuid().ToString();
string qrCodeImageName = image_userName + ".jpg";
HF.Cloud.BLL.Common.Logger.Error("GetUserQRCode方法,保存小程序图片路径名称：" + QRCodeSave_User + qrCodeImageName);
tp.Save(QRCodeSave_User + qrCodeImageName);
//把小程序码图片名称保存到数据库中
userEL.QRCode = qrCodeImageName;
int ra;
long returnValue = userEL.ExecNonQuery(27, out ra);
HF.Cloud.BLL.Common.Logger.Error("GetUserQRCode方法,保存小程序图片名称结果：" + ra);
if (ra > 0)
{
string QRCodeGet_User = System.Configuration.ConfigurationManager.AppSettings["QRCodeGet_User"];
imgPath = QRCodeGet_User + qrCodeImageName;
}
else
{
imgPath = "error";
}
}
HF.Cloud.BLL.Common.Logger.Error("GetUserQRCode方法,返回的结果：" + imgPath);
return(imgPath);
}
/// <summary>
/// 通过code获取session
/// </summary>
/// <param name="code">小程序login获取的Code</param>
/// <returns></returns>
public string GetSessionByCode(string code)
{
string strJson = "";
BLL.Common.Logger.Error("GetSessionByCode方法接受到的参数code：" + code);
JavaScriptSerializer js = new JavaScriptSerializer();
Dictionary <string, object> dic = new Dictionary <string, object>();
string str_OpenidAndSessinKey = "";
if (!string.IsNullOrEmpty(code))
{
//获取openid和Session_Key
WeChatAppDecrypt Wechat = new WeChatAppDecrypt();
str_OpenidAndSessinKey = Wechat.GetOpenIdAndSessionKeyString(code);
BLL.Common.Logger.Error("GetSessionByCode方法获取到openid和Sessionkey：" + str_OpenidAndSessinKey);
var openidAndSessionKey = js.Deserialize <Dictionary <string, object> >(str_OpenidAndSessinKey);
string strOpenID = openidAndSessionKey["openid"].ToString();
string strSession_Key = openidAndSessionKey["session_key"].ToString();
//通过openID获取用户记录
SB_UserEL userEL = new SB_UserEL();
userEL.OpenID = strOpenID;
DataTable dt = userEL.ExecDT(43);
string sessionResult = "";
string isHadRegister = "";
if (dt != null && dt.Rows.Count > 0)
{
sessionResult = dt.Rows[0]["Session_True"].ToString();
isHadRegister = "1";
}
else
{
//生成session
//生成6位随机数
string strRandom = new Random().Next(100000, 1000000).ToString();
//session_Key格式：q/jk63En5ojUGqgi6vLHmA==（24个字符）
//openID格式：oFQX10O9zkRnsNYefrc48KfQWi9o（28个字符）
//strSession_true=strSession_Key+strOpenID+strRandom
//session等于sesion_key去掉后两位的“=”号(22位),加openid(28位)，加六位随机数(6位)
//sessionResult=q/jk63En5ojUGqgi6vLHmAoFQX10O9zkRnsNYefrc48KfQWi9o654321
string strSession_true = strSession_Key.Substring(0, strSession_Key.Length - 2) + strOpenID + strRandom;
sessionResult = strSession_true;
isHadRegister = "0";
}
dic.Add("Session", sessionResult);
dic.Add("IsHadRegister", isHadRegister);
strJson = js.Serialize(dic);
HF.Cloud.BLL.Common.Logger.Error("GetSessionByCode方法返回的数据为：" + strJson);
}
else
{
strJson = "error";
}
return(strJson);
}
/// <summary>
/// 搜索好友
/// </summary>
/// <param name="friendName">好友名称</param>
/// <returns></returns>
public string SearchFriend(string session, string friendName)
{
HF.Cloud.BLL.Common.Logger.Error("SearchFriend方法获取的参数session:" + session + "---friendName:" + friendName);
JavaScriptSerializer js = new JavaScriptSerializer();
List <Dictionary <string, object> > list = new List <Dictionary <string, object> >();
UserBLL userBLL = new UserBLL();
long userID = userBLL.GetUserIDBySession(session);
FriendsEL friendEL = new FriendsEL();
DataTable dt = friendEL.ExecuteSqlString("select * from ViewFriends where UserID=" + userID + " and UserName like '%" + friendName + "%' and Friend_Valid=1");
SB_UserEL userEL = new SB_UserEL();
//userEL.UserName = friendName;
//DataTable dt= userEL.ExecDT(45);
HF.Cloud.BLL.Common.Logger.Error("SearchFriend方法获取的好友个数为:" + dt.Rows.Count);
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
//这里都是用的视图ViewFriends里的字段
long userid = long.Parse(dr["SB_User_ID"].ToString());
//通过userid_Friend获取好友信息
userEL.ID = userid;
userEL.ExecuteEL(4);
string userName = userEL.UserName;
string userTel = userEL.UserTel;
string duty = userEL.Duty;
string imgUrl = userEL.ImgUrl;
string session_Friend = userEL.Session_True;
long companyID = userEL.CompanyID;
//通过companyID获取公司名称
CompanysEL compaEL = new CompanysEL();
compaEL.ID = companyID;
compaEL.ExecuteEL(2);
string companyName = compaEL.CompanyName;
HF.Cloud.BLL.Common.Logger.Error("SearchFriend方法好友名称：" + userEL.UserName + "公司名称：" + companyName);
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("UserName", userName);
dic.Add("UserTel", userTel);
dic.Add("Duty", duty);
dic.Add("ImgUrl", imgUrl);
dic.Add("Session", session_Friend);
dic.Add("CompanyName", companyName);
list.Add(dic);
}
}
string strJson = js.Serialize(list);
HF.Cloud.BLL.Common.Logger.Error("SearchFriend方法返回的好友列表json数据：" + strJson);
return(strJson);
}
/// <summary>
/// 好友列表
/// </summary>
/// <param name="session">本人session</param>
/// <returns></returns>
public string GetFriendList(string session)
{
HF.Cloud.BLL.Common.Logger.Error("FriendList获取到的session为" + session);
JavaScriptSerializer js = new JavaScriptSerializer();
List <Dictionary <string, object> > list = new List <Dictionary <string, object> >();
//session获取用户UserID
SB_UserEL userEL = new SB_UserEL();
userEL.Session_True = session;
userEL.ExecuteEL(41);
HF.Cloud.BLL.Common.Logger.Error("userEL.ID：" + userEL.ID);
if (userEL.ID > 0)
{
long userID = userEL.ID;
//通过userID在好友表中查询好友列表
FriendsEL frenEL = new FriendsEL();
frenEL.UserID = userID;
DataTable dt = frenEL.ExecDT(31);
HF.Cloud.BLL.Common.Logger.Error("获取到好友列表，好友个数为：" + dt.Rows.Count);
foreach (DataRow dr in dt.Rows)
{
long userid_Friend = long.Parse(dr["UserID_Friend"].ToString());
//通过userid_Friend获取好友信息
userEL.ID = userid_Friend;
userEL.ExecuteEL(4);
string userName = userEL.UserName;
string userTel = userEL.UserTel;
string duty = userEL.Duty;
string imgUrl = userEL.ImgUrl;
string session_Friend = userEL.Session_True;
long companyID = userEL.CompanyID;
//通过companyID获取公司名称
CompanysEL compaEL = new CompanysEL();
compaEL.ID = companyID;
compaEL.ExecuteEL(2);
string companyName = compaEL.CompanyName;
HF.Cloud.BLL.Common.Logger.Error("好友名称：" + userEL.UserName + "公司名称：" + companyName);
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("UserName", userName);
dic.Add("UserTel", userTel);
dic.Add("Duty", duty);
dic.Add("ImgUrl", imgUrl);
dic.Add("Session", session_Friend);
dic.Add("CompanyName", companyName);
list.Add(dic);
}
}
string strJson = js.Serialize(list);
HF.Cloud.BLL.Common.Logger.Error("返回的好友列表json数据：" + strJson);
return(strJson);
}
/// <summary>
/// 通过session换取UserID主键
/// </summary>
/// <param name="session"></param>
/// <returns></returns>
public long GetUserIDBySession(string session)
{
long userID = 0;
SB_UserEL userel = new SB_UserEL();
userel.Session_True = session;
userel.ExecuteEL(41);
if (userel.ID > 0)
{
userID = userel.ID;
}
return(userID);
}
/// <summary>
/// 通过session获取SB_UserEL实体
/// </summary>
/// <param name="session">session</param>
/// <returns></returns>
public SB_UserEL GetUserELBySession(string session)
{
SB_UserEL userEL_Return = new SB_UserEL();
SB_UserEL userEL = new SB_UserEL();
userEL.Session_True = session;
userEL.ExecuteEL(41);
if (userEL.ID > 0)
{
userEL_Return = userEL;
}
return(userEL_Return);
}
protected void LnkBtnDelete_Command(object sender, CommandEventArgs e)
{
string cn = e.CommandName;
string cnArgs = e.CommandArgument.ToString();
SB_UserMEL userM = new SB_UserMEL();
int flag;
using (TransactionScope scope = new TransactionScope())
{
switch (cn)
{
case "Stop":
userM.ID = long.Parse(cnArgs);
userM.ExecNonQuery(3, out flag);
SB_UserEL user = new SB_UserEL()
{
Valid = 0,
MainID = userM.ID
};
user.ExecNonQuery(25, out flag);
BindDataList();
break;
case "Enable":
userM.ID = long.Parse(cnArgs);
userM.ExecNonQuery(31, out flag);
SB_UserEL userE = new SB_UserEL()
{
Valid = 1,
MainID = userM.ID
};
userE.ExecNonQuery(25, out flag);
BindDataList();
break;
}
scope.Complete();
}
}
/// <summary>
/// 获取用户信息
/// </summary>
/// <param name="userID">用户userID</param>
/// <returns></returns>
public string GetUserInfoByUserID(string userID)
{
HF.Cloud.BLL.Common.Logger.Error("GetUserInfoByUserID方法接受到的参数userID：" + userID);
//通过session获取用户
SB_UserEL userel = new SB_UserEL();
userel.ID = long.Parse(userID);
userel.ExecuteEL(4);
HF.Cloud.BLL.Common.Logger.Error("GetUserInfoByUserID方法获取用户姓名：" + userel.UserName);
JavaScriptSerializer js = new JavaScriptSerializer();
Dictionary <string, object> dic = new Dictionary <string, object>();
if (!string.IsNullOrEmpty(userel.UserName))
{
dic.Add("UserID", userID);
dic.Add("UserName", userel.UserName);
dic.Add("UserTel", userel.UserTel);
dic.Add("Duty", userel.Duty);
dic.Add("UserEmail", userel.UserEmail);
dic.Add("Detail", userel.Detail);
dic.Add("ImgUrl", userel.ImgUrl);
dic.Add("Session", userel.Session_True);
string companyName = "";
string companyIcon = "";
string companyID = "";
//通过公司ID查询公司名称
CompanysEL compEL = new CompanysEL();
compEL.ID = userel.CompanyID;
compEL.ExecuteEL(2);
HF.Cloud.BLL.Common.Logger.Error("GetUserInfoByUserID方法查询公司名称结果公司名称：" + compEL.CompanyName);
if (!string.IsNullOrEmpty(compEL.CompanyName))
{
companyName = compEL.CompanyName;
companyIcon = compEL.CompanyIcon;
companyID = compEL.ID.ToString();
}
dic.Add("CompanyName", companyName);
dic.Add("CompanyIcon", companyIcon);
dic.Add("CompanyID", companyID);
}
string strJson = js.Serialize(dic);
HF.Cloud.BLL.Common.Logger.Error("GetUserInfoByUserID方法返回的数据为：" + strJson);
return(strJson);
}
/// <summary>
/// 保存
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void lnkBtnSearch_Click(object sender, EventArgs e)
{
string tips = ValidateInput();
using (TransactionScope scope = new TransactionScope())
{
try
{
if (tips == string.Empty)
{
SysBL bl = new SysBL();
SB_UserEL el = new SB_UserEL();
BLL.Common.Symmetric sm = new BLL.Common.Symmetric();
el = bl.InsertUser(this.txtUserCode.Text.Trim(), sm.Encrypto("123456"), this.txtUserCode.Text.Trim(), this.txtSBName.Text.Trim(), txtUserName.Text.Trim());
bl.addQBCodeModel(el.MainID); //给服务商添加一个默认模板
//给服务商添加一个支付账号，开通账户
string Cname = this.txtSBName.Text.Trim(); //企业名称
bl.addMainAccount(el.MainID, Cname);
//给服务商添加短信模板
bl.addMessageSet(el.MainID);
if (el != null && el.ID > 0)
{
MessageBox.ShowAndRedirect(this, "服务商保存成功，默认密码为：123456", "/ServiceProvider/index.aspx");
scope.Complete();
}
else
{
MessageBox.Show(this, "增加用户账户时失败！");
}
}
else
{
MessageBox.Show(this, tips);
}
}
catch (Exception er)
{
MessageBox.Show(this, "保存失败，" + er.Message + "！");
}
}
}
/// <summary>
/// 给公司递名片
/// </summary>
/// <param name="session">session</param>
/// <param name="companyID">公司ID</param>
/// <returns></returns>
public string SendCard(string session, string companyID)
{
string resStr = "";
HF.Cloud.BLL.Common.Logger.Error("SendCard方法接受的参数session：" + session + "---companyID:" + companyID);
//通过session获取UserID
UserBLL userBLL = new UserBLL();
long userID = userBLL.GetUserIDBySession(session);
//通过companyID查询企业的所有员工
SB_UserEL userEL = new SB_UserEL();
userEL.CompanyID = long.Parse(companyID);
DataTable dt = userEL.ExecDT(44);
HF.Cloud.BLL.Common.Logger.Error("SendCard方法获取到企业员工数为：" + dt.Rows.Count);
NoticeEL noticeEL = new NoticeEL();
int i = 0;
foreach (DataRow dr in dt.Rows)
{
noticeEL.UserID = (long)dr["ID"]; //接受通知用户的userID
noticeEL.UserID_Friend = userID; //
noticeEL.NoticeType = 1;
noticeEL.NoticeState = 0;
noticeEL.IsLook = 0;
noticeEL.CreateTime = DateTime.Now.ToString();
noticeEL.Valid = 1;
int ra;
long notiExec = noticeEL.ExecNonQuery(1, out ra);
if (notiExec > 0)
{
i = i + 1;
}
}
if (dt.Rows.Count == i)
{
resStr = "seccess";
}
else
{
resStr = "error";
}
return(resStr);
}
/// <summary>
/// 红包开关
/// </summary>
/// <param name="companyId">公司ID</param>
/// <returns></returns>
public string OpenRedBag(string companyID)
{
HF.Cloud.BLL.Common.Logger.Error("OpenRedBag 获取到的参数CompanyID：" + companyID);
//查看时间，过期则不可打开
//if(DateTime.Now.ToString()<"2018-02-16 23:12:12:123")
//{
//}
string resultStr = "";
long companyIdLong = 0;//公司ID
if (long.TryParse(companyID, out companyIdLong))
{
//1通过公司id在用户表中看当前公司够5个人不够
SB_UserEL userEL = new SB_UserEL();
userEL.CompanyID = companyIdLong;
DataTable dt_User = userEL.ExecDT(44);
//1.1够5个人则开始在红包表里面添加红包数据
if (dt_User != null && dt_User.Rows.Count >= 5)
{
//2 查看已经发了多少钱，发过的总数大于1000停止发送
DataTable dt_HongBalAllVa = DbHelperSQL.Query("select sum(HongBaoValue) as AllValue from T_HongBao where Valid=1").Tables[0];
string allValueStr = dt_HongBalAllVa.Rows[0][0].ToString();
//2.1已经发送的总金额小于900的话继续发
if (string.IsNullOrEmpty(allValueStr) || double.Parse(allValueStr) < 850)
{
T_HongBaoEL hongBaoEl = new T_HongBaoEL();
//查看红包表是否已经存在记录，存在则不添加红包记录
hongBaoEl.CompanyID = companyIdLong;
DataTable dt_HongBao = hongBaoEl.ExecDT(33);
if (dt_HongBao == null || dt_HongBao.Rows.Count < 1)
{
//3发红包表添加记录
//3.1生成公司红包金额10-100随机数，红包个数是金额的0.5-1倍
Random ran = new Random();
//3.1.1红包金额,取下不取上
int comAllValue = ran.Next(10, 100);
//3.1.2人数
int comNumber = (int)Math.Floor(ran.Next(5, 10) * 0.1 * comAllValue);
HF.Cloud.BLL.Common.Logger.Error("OpenRedBag方法红包总金额是：" + comAllValue + "---总人数：" + comNumber);
//3.2通过总金额和人数获取评分后的红包值
List <Double> listHongV = HongBao.GetRedBagList(double.Parse(comAllValue.ToString()), comNumber, 1.00);
//3.3通过获取到的红包值列表，给红包表添加记录
for (int i = 0; i < listHongV.Count; i++)
{
//ID,CompanyID,HongBaoValue,GetUserID,IsGet,
//CreateTime,GiveOutTime,Valid
//HF.Cloud.BLL.Common.Logger.Error("OpenRedBag方法获得的红包值listHongV是：" + listHongV[i]);
hongBaoEl.CompanyID = companyIdLong;
//hongBaoEl.HongBaoValue = decimal.Round((decimal)listHongV[i],2);
hongBaoEl.HongBaoValue = decimal.Parse(listHongV[i].ToString());
hongBaoEl.IsGet = 1;
hongBaoEl.CreateTime = DateTime.Now.ToString();
hongBaoEl.GiveOutTime = "";
hongBaoEl.Valid = 1;
int ra;
hongBaoEl.ExecNonQuery(1, out ra);
}
HF.Cloud.BLL.Common.Logger.Error("OpenRedBag方法生成的红包个数：" + listHongV.Count);
resultStr = "success";
}
else //已经激活不能再次激活
{
resultStr = "actived";
}
}
else //2.2红包奖金池已经用完额度
{
resultStr = "empty";
}
}
else//1.2不够5个人则提示人数不够
{
resultStr = "notenough";
}
}
else
{
resultStr = "error";
}
HF.Cloud.BLL.Common.Logger.Error("OpenRedBag 结果：" + resultStr);
return(resultStr);
}
/// <summary>
/// 获取好友公司信息
/// </summary>
/// <param name="companyID">companyID</param>
/// <returns></returns>
public string GetFriendCompanyInfo(string session, string companyID)
{
string strJson = "";
HF.Cloud.BLL.Common.Logger.Error("GetFriendCompanyInfo方法接受的参数session:" + session + "---companyID：" + companyID);
if (!string.IsNullOrEmpty(session) && !string.IsNullOrEmpty(companyID))
{
JavaScriptSerializer js = new JavaScriptSerializer();
Dictionary <string, object> dic = new Dictionary <string, object>();
SB_UserEL userEL = new SB_UserEL();
userEL.Session_True = session;
userEL.ExecuteEL(41);
string isMyCompany = "";//是否是自己公司
if (userEL.CompanyID.ToString() == companyID)
{
isMyCompany = "1";
}
else
{
isMyCompany = "0";
}
long _companyID = long.Parse(companyID);
//通过公司ID获取公司信息
CompanysEL companysEL = new CompanysEL();
companysEL.ID = _companyID;
companysEL.ExecuteEL(2);
HF.Cloud.BLL.Common.Logger.Error("GetFriendCompanyInfo方法查询公司信息结果公司名称：" + companysEL.CompanyName);
dic.Add("CompanyID", companyID);
dic.Add("CompanyName", companysEL.CompanyName);
dic.Add("CompanyIcon", companysEL.CompanyIcon);
dic.Add("Introduce", companysEL.Introduce);
dic.Add("IsMyCompany", isMyCompany);
//通过companyID获取公司关键字
string companyTags = GetCompanyTag_String(companyID.ToString());
dic.Add("Tags", companyTags);
//3判断是否给此公司递过名片
string userid = userEL.ID.ToString();
//3.1查找第一个加入当前公司的用户ID
string userid_Company = "";
userEL.CompanyID = _companyID;
DataTable dt_company = userEL.ExecDT(44);
if (dt_company != null && dt_company.Rows.Count > 0)
{
userid_Company = dt_company.Rows[0]["ID"].ToString();
}
//3.2Notice表中查找此人是否给公司提交过名片的记录
NoticeEL noticeEL = new NoticeEL();
noticeEL.UserID = long.Parse(userid_Company); //第一个加入公司的人
noticeEL.UserID_Friend = long.Parse(userid); //自己
noticeEL.NoticeType = 1;
DataTable dt_Notice = noticeEL.ExecDT(23);
string isSend = "";//是否递过，0没递过，1递过
if (dt_Notice != null && dt_Notice.Rows.Count > 0)
{
isSend = "1";
}
else
{
isSend = "0";
}
dic.Add("IsSend", isSend);
strJson = js.Serialize(dic);
}
else
{
strJson = "error";
}
HF.Cloud.BLL.Common.Logger.Error("GetFriendCompanyInfo方法返回的用户信息json数据：" + strJson);
return(strJson);
}
/// <summary>
/// 搜索群
/// </summary>
/// <param name="session">用户session</param>
/// <param name="groupName">群名称</param>
/// <returns></returns>
public string SearchGroup(string session, string groupName)
{
HF.Cloud.BLL.Common.Logger.Error("SearchFriend方法获取的参数session:" + session + "---groupName:" + groupName);
JavaScriptSerializer js = new JavaScriptSerializer();
List <Dictionary <string, object> > list = new List <Dictionary <string, object> >();
//通过Session获取UerID
UserBLL userBLL = new UserBLL();
long userID = userBLL.GetUserIDBySession(session);
HF.Cloud.BLL.Common.Logger.Error("SearchFriend方法获取到的UserID:" + userID);
GroupEL groupEL = new GroupEL();
//获取到userID用户所有群中包含groupName名字的群组
DataTable dt = groupEL.ExecuteSqlString("select * from ViewGroupUnite where UserID=" + userID + " and GroupName like '%" + groupName + "%' and Group_Valid=1 and Unite_Valid=1");
UserUniteGroupEL userGroupEL = new UserUniteGroupEL();
SB_UserEL userEL = new SB_UserEL();
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
////通过群ID获取群信息
//long groupID = (long)/*dr["GroupID"]*/;
//groupEL.ID = groupID;
//groupEL.ExecuteEL(3);
//HF.Cloud.BLL.Common.Logger.Error("SearchGroup方法获取到群组名称:" + groupEL.GroupName);
string groupName_true = dr["GroupName"].ToString();
long ownerUserID = (long)dr["OwnerUserID"];
string createTime = dr["Group_CreateTime"].ToString();
//if (!string.IsNullOrEmpty(groupEL.GroupName))
//{
// groupName_true = groupEL.GroupName;
// ownerUserID = groupEL.OwnerUserID;
// createTime = groupEL.CreateTime;
//}
//通过ownerUserID获取群主Name
userEL.ID = ownerUserID;
userEL.ExecuteEL(4);
HF.Cloud.BLL.Common.Logger.Error("SearchGroup方法获取到群主姓名:" + userEL.UserName);
string ownerUserName = "";
if (!string.IsNullOrEmpty(userEL.UserName))
{
ownerUserName = userEL.UserName;
}
//通过群ID获取群有多少人
userGroupEL.GroupID = (long)dr["Group_ID"];
DataTable dt_Count = userGroupEL.ExecDT(31);
HF.Cloud.BLL.Common.Logger.Error("SearchGroup方法获取到本群人数:" + dt_Count.Rows.Count);
int groupCount = dt_Count.Rows.Count;
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("GroupName", groupName_true);
dic.Add("GroupOwnerName", ownerUserName);
dic.Add("CreateTime", createTime);
dic.Add("GroupCount", groupCount.ToString());
dic.Add("GroupID", dr["Group_ID"].ToString());
list.Add(dic);
}
}
string strJson = js.Serialize(list);
HF.Cloud.BLL.Common.Logger.Error("SearchGroup方法返回的json数据：" + strJson);
return(strJson);
}
/// <summary>
/// 群组人员置顶 取消置顶 删除
/// </summary>
/// <param name="userID">人员ID</param>
/// <param name="groupID">群组ID</param>
/// <param name="cookie">操作的功能（top置顶distop取消置顶delete删除）</param>
/// <returns></returns>
public string EditUser(string session, string userID, string groupID, string cookie)
{
string retunStr = "";
HF.Cloud.BLL.Common.Logger.Error("EditUser编辑群组人员方法,获取的参数userID：" + userID + "------groupID:" + groupID + "------cookie:" + cookie);
UserUniteGroupEL userGroupEL = new UserUniteGroupEL();
if (!string.IsNullOrEmpty(userID) && !string.IsNullOrEmpty(groupID) && !string.IsNullOrEmpty(cookie))
{
userGroupEL.UserID = long.Parse(userID);
userGroupEL.GroupID = long.Parse(groupID);
if (cookie == "top")//置顶
{
//获取当前置顶的istop最大值
int maxIsTop = 0;
DataTable dtUserGroup = userGroupEL.ExecDT(35);
if (dtUserGroup != null && dtUserGroup.Rows.Count > 0)
{
maxIsTop = Int32.Parse(dtUserGroup.Rows[0]["IsTop"].ToString());
}
userGroupEL.IsTop = maxIsTop + 1;
int ra;
long returnVel = userGroupEL.ExecNonQuery(22, out ra);
if (ra > 0)
{
retunStr = GetGroupFriendList(session, groupID);
}
else
{
retunStr = "error";
}
}
if (cookie == "distop")//取消置顶
{
userGroupEL.IsTop = 0;
int ra;
long returnVel = userGroupEL.ExecNonQuery(23, out ra);
if (ra > 0)
{
retunStr = GetGroupFriendList(session, groupID);
}
else
{
retunStr = "error";
}
}
if (cookie == "del")//删除
{
//不可删自己
//通过groupID获取群信息
GroupEL groupEL = new GroupEL();
long groupID_long = long.Parse(groupID);
groupEL.ID = groupID_long;
groupEL.ExecuteEL(3);
//群主ID
string userID_Group = groupEL.OwnerUserID.ToString();
//通过sesison 获取userID
SB_UserEL userEL = new SB_UserEL();
userEL.Session_True = session;
DataTable dtUserEl = userEL.ExecDT(41);
string userID_User = "";
if (dtUserEl != null && dtUserEl.Rows.Count > 0)
{
userID_User = dtUserEl.Rows[0]["ID"].ToString();
}
//如果不是群主
if (userID_Group != userID_User)
{
int ra;
long returnVel = userGroupEL.ExecNonQuery(2, out ra);
if (ra < 0)
{
retunStr = "error";
}
}
retunStr = GetGroupFriendList(session, groupID);
}
}
return(retunStr);
}
/// <summary>
/// 添加用户
/// </summary>
/// <param name="strAddUser"></param>
/// <returns></returns>
public string InsertUser(string strAddUser)
{
BLL.Common.Logger.Error("InsertUser方法新增加用户接受到的参数string：" + strAddUser);
string InsertUserRes = "";//返回的数据
JavaScriptSerializer js = new JavaScriptSerializer();
var info = js.Deserialize <Dictionary <string, object> >(strAddUser);
SB_UserEL SB_User_el = new SB_UserEL();
SB_User_el.UserName = info["UserName"].ToString();
SB_User_el.UserTel = info["UserTel"].ToString();
SB_User_el.Duty = info["Duty"].ToString();
SB_User_el.UserEmail = info["UserEmail"].ToString();
SB_User_el.Detail = info["Detail"].ToString();
SB_User_el.ImgUrl = info["ImgUrl"].ToString();
SB_User_el.CompanyID = long.Parse(info["CompanyID"].ToString());
SB_User_el.Popularity = 0;
SB_User_el.Thumbs = 0;
SB_User_el.CreateTime = DateTime.Now.ToString();
SB_User_el.Valid = 1;
SB_User_el.UnionID = "";
//string strOpneID = info["OpenID"].ToString();
//SB_User_el.OpenID = strOpneID;
//string strSession_Key= info["Session_Key"].ToString();
//SB_User_el.Session_Key = strSession_Key;
//SB_User_el.UnionID = "";
//string strSession_true = "";
//string strRandom = new Random().Next(100000, 1000000).ToString();
//strSession_true = strSession_Key.Substring(0, strSession_Key.Length - 2) + strOpneID + strRandom;
//SB_User_el.Session_True = strSession_true;
//----------------------------------------------------------------------------------
//string code = info["Code"].ToString();
//string strSession_true = "";
//string strOpneID = "";
//if (!string.IsNullOrEmpty(code))
//{
// //获取openid和Session_Key
// WeChatAppDecrypt Wechat = new WeChatAppDecrypt();
// string str_res = Wechat.GetOpenIdAndSessionKeyString(code);
// BLL.Common.Logger.Error("新增加用户获取到openid和Sessionkey：" + str_res);
// var openidAndSessionKey = js.Deserialize<Dictionary<string, object>>(str_res);
// strOpneID = openidAndSessionKey["openid"].ToString();
// SB_User_el.OpenID = strOpneID;
// SB_User_el.Session_Key = openidAndSessionKey["session_key"].ToString();
// SB_User_el.UnionID = "";
// string strRandom = new Random().Next(100000, 1000000).ToString();
// strSession_true = openidAndSessionKey["session_key"].ToString() + strRandom;
// SB_User_el.Session_True = strSession_true;
//}
//string strOpneID = "";
//string strSession_key = "";
////如果传过来OpenID和Session_Key（小程序获取手机号从而得到OpenID和Session_key）
//if (!string.IsNullOrEmpty(info["OpenID"].ToString()) && !string.IsNullOrEmpty(info["Session_Key"].ToString()))
//{
// strOpneID = info["OpenID"].ToString();
// strSession_key = info["Session_Key"].ToString();
//}
////如果没有openID和Session_Key的话就用Code去换取（小程序中直接填写的手机号，没有获取）
//else if (!string.IsNullOrEmpty(info["Code"].ToString()))
//{
// //获取openid和Session_Key
// WeChatAppDecrypt Wechat = new WeChatAppDecrypt();
// string str_res = Wechat.GetOpenIdAndSessionKeyString(info["Code"].ToString());
// BLL.Common.Logger.Error("InsertUser方法新增加用户获取到openid和Sessionkey：" + str_res);
// var openidAndSessionKey = js.Deserialize<Dictionary<string, object>>(str_res);
// strOpneID = openidAndSessionKey["openid"].ToString();
// strSession_key = openidAndSessionKey["session_key"].ToString();
//}
//SB_User_el.OpenID = strOpneID;
//SB_User_el.Session_Key = strSession_key;
string session_True = info["Session_True"].ToString();
//判断Session_True是否为空
if (!string.IsNullOrEmpty(session_True) && session_True != "")
{
//User表中判断Session_True，看是否有Session_True，有的话就是修改，没有的话就是添加
SB_UserEL SB_User_el_IsHadSession = new SB_UserEL();
SB_User_el_IsHadSession.Session_True = session_True;
DataTable dt = SB_User_el_IsHadSession.ExecDT(45);
BLL.Common.Logger.Error("InsertUser方法用户表中查询用户个数为：" + dt.Rows.Count);
if (dt != null && dt.Rows.Count > 0)
{
//修改用户记录
SB_User_el.Session_True = session_True;
int aff;
long executeResul = SB_User_el.ExecNonQuery(24, out aff);
BLL.Common.Logger.Error("InsertUser方法修改用户信息结果为：" + aff);
if (aff > 0)
{
//返回数据库中的Session_True
InsertUserRes = session_True;
BLL.Common.Logger.Error("InsertUser方法这里是修改用户信息成功,返回的session为：" + InsertUserRes);
}
else
{
InsertUserRes = "error";
}
}
else//添加用户
{
SB_User_el.Session_True = session_True;
//拆分sesison_True，获取openid和sesison_key
string str_session_key = session_True.Substring(0, 22) + "==";
string str_openid = session_True.Substring(22, 28);
SB_User_el.Session_Key = str_session_key;
SB_User_el.OpenID = str_openid;
//添加
int aff;
long executeResul = SB_User_el.ExecNonQuery(1, out aff);
BLL.Common.Logger.Error("InsertUser方法添加用户信息结果为：" + executeResul);
if (executeResul > 0)
{
InsertUserRes = session_True;
BLL.Common.Logger.Error("InsertUser方法添加用户信息成功！返回的session为：" + InsertUserRes);
}
else
{
InsertUserRes = "error";
}
}
}
////User表中判断openid，看是否有openid，有的话就是修改，没有的话就是添加
//SB_UserEL SB_User_el_IsHaveOpenID = new SB_UserEL();
//SB_User_el_IsHaveOpenID.OpenID = strOpneID;
//SB_User_el_IsHaveOpenID.ExecuteEL(43);
//if (SB_User_el_IsHaveOpenID.ID > 0)
//{
// //修改用户记录
// int aff;
// long executeResul = SB_User_el.ExecNonQuery(24, out aff);
// if (aff > 0)
// {
// //返回数据库中的Session_True
// InsertUserRes = SB_User_el_IsHaveOpenID.Session_True;
// BLL.Common.Logger.Error("InsertUser方法这里是修改用户信息成功,返回的session为：" + InsertUserRes);
// }
// else
// {
// InsertUserRes = "";
// }
//}
//else
//{
// //添加用户记录
// //生成session
// string strSession_true = "";
// string strRandom = new Random().Next(100000, 1000000).ToString();
// strSession_true = strSession_key.Substring(0, strSession_key.Length - 2) + strOpneID + strRandom;
// SB_User_el.Session_True = strSession_true;
// //添加
// int aff;
// long executeResul = SB_User_el.ExecNonQuery(1, out aff);
// if (executeResul > 0)
// {
// InsertUserRes = strSession_true;
// BLL.Common.Logger.Error("InsertUser方法添加用户信息成功！返回的session为：" + InsertUserRes);
// }
// else
// {
// InsertUserRes = "";
// }
//}
return(InsertUserRes);
}
/// <summary>
/// 获取通知列表
/// </summary>
/// <param name="session">用户session</param>
/// <param name="noticeType">标志要请求的通知类型，0全部通知，1个人通知，2系统通知</param>
/// <returns></returns>
public string GetNotice(string session, string noticeType)
{
HF.Cloud.BLL.Common.Logger.Error("GetNotice方法获取到参数session:" + session);
JavaScriptSerializer js = new JavaScriptSerializer();
List <Dictionary <string, object> > list = new List <Dictionary <string, object> >();
//通过session获取用户ID
UserBLL userBLL = new UserBLL();
long userID = userBLL.GetUserIDBySession(session);
HF.Cloud.BLL.Common.Logger.Error("GetNotice方法获取到userID:" + userID);
NoticeEL noticeEL = new NoticeEL();
noticeEL.UserID = userID;
DataTable dt = new DataTable();
if (noticeType == "0")//全部通知
{
string sqlString = "select* from (" +
"select N.ID as NID, S.ID as SID, N.UserID_Friend,N.GroupID," +
"ISNULL(N.UserID, S.UserID) as UserID," +
"ISNULL(N.NoticeType, S.NoticeType) as NoticeType," +
"N.NoticeState, S.NoticeTitle, S.NoticeContent, s.AddressUrl," +
"ISNULL(N.IsLook, S.IsLook) as IsLook," +
"ISNULL(N.CreateTime, S.CreateTime) as CreateTime," +
"ISNULL(N.Valid, S.Valid) as Valid " +
"from Notice as N full join Notice_System as S on N.CreateTime = S.CreateTime) as T " +
"WHERE[UserID] = " + userID +
" and[Valid] = 1 order by CreateTime desc";
HF.Cloud.BLL.Common.Logger.Error("GetNotice方法联表查询语句:" + sqlString);
dt = noticeEL.ExecuteSqlString(sqlString);
}
if (noticeType == "1")//个人通知
{
dt = noticeEL.ExecDT(21);
}
if (noticeType == "2")//系统通知
{
Notice_SystemEL nsEL = new Notice_SystemEL();
nsEL.UserID = userID;
dt = nsEL.ExecDT(21);
}
HF.Cloud.BLL.Common.Logger.Error("GetNotice方法获取到通知个数:" + dt.Rows.Count);
SB_UserEL userEL = new SB_UserEL();
CompanysEL companyEL = new CompanysEL();
GroupEL groupEL = new GroupEL();
foreach (DataRow dr in dt.Rows)
{
Dictionary <string, object> dic = new Dictionary <string, object>();
if (noticeType == "0")
{
if (dr["NoticeType"].ToString() == "2") //如果是系统通知
{
dic.Add("NoticeID", dr["SID"].ToString()); //联合表里系统通知表的通知ID
string noticeTitleStr = dr["NoticeTitle"].ToString();
string noticeTitle = noticeTitleStr.Length > 10 ? noticeTitleStr.Substring(0, 10) + "..." : noticeTitleStr;
dic.Add("NoticeTitle", noticeTitle);
string noticeContentStr = dr["NoticeContent"].ToString();
string noticeContent = noticeContentStr.Length > 20 ? noticeContentStr.Substring(0, 20) + "..." : noticeContentStr;
dic.Add("NoticeContent", noticeContent);
dic.Add("AddressUrl", dr["AddressUrl"].ToString());
dic.Add("NoticeType", "2");
dic.Add("IsLook", dr["IsLook"].ToString());
dic.Add("CreateTime", dr["CreateTime"].ToString());
}
else
{
long userID_Friend = long.Parse(dr["UserID_Friend"].ToString());
//通过UserID_Friend获取用户头像名字公司ID
userEL.ID = userID_Friend;
userEL.ExecuteEL(4);
HF.Cloud.BLL.Common.Logger.Error("GetNotice方法获取到好友名字:" + userEL.UserName);
string friend_Img = userEL.ImgUrl;
string friend_Name = userEL.UserName;
string friend_Session = userEL.Session_True;
long friend_CompanyID = userEL.CompanyID;
companyEL.ID = friend_CompanyID;
companyEL.ExecuteEL(2);
HF.Cloud.BLL.Common.Logger.Error("GetNotice方法获取到好友公司名字:" + companyEL.CompanyName);
string friend_CompanyName = companyEL.CompanyName;
//获取群组相关
if (dr["NoticeType"].ToString() == "3")//3为群组审核通知
{
long groupID = long.Parse(dr["GroupID"].ToString());
groupEL.ID = groupID;
groupEL.ExecuteEL(3);
HF.Cloud.BLL.Common.Logger.Error("GetNotice方法获取到群组名称:" + groupEL.GroupName + "---群组ID:" + groupID);
dic.Add("GroupID", groupID.ToString()); //群组ID，入群审核用
dic.Add("GroupName", groupEL.GroupName); //群组名称，入群审核用
}
dic.Add("UserName", friend_Name);
dic.Add("Session", friend_Session);
dic.Add("ImgUrl", friend_Img);
dic.Add("CompanyName", friend_CompanyName);
dic.Add("NoticeID", dr["NID"].ToString());//NID这里是用的联表查询里的个人通知的ID
dic.Add("CreateTime", dr["CreateTime"].ToString());
dic.Add("NoticeType", dr["NoticeType"].ToString());
dic.Add("NoticeState", dr["NoticeState"].ToString());
dic.Add("IsLook", dr["IsLook"].ToString());
}
}
if (noticeType == "1")//个人通知
{
long userID_Friend = long.Parse(dr["UserID_Friend"].ToString());
//通过UserID_Friend获取用户头像名字公司ID
userEL.ID = userID_Friend;
userEL.ExecuteEL(4);
HF.Cloud.BLL.Common.Logger.Error("GetNotice方法获取到好友名字:" + userEL.UserName);
string friend_Img = userEL.ImgUrl;
string friend_Name = userEL.UserName;
string friend_Session = userEL.Session_True;
long friend_CompanyID = userEL.CompanyID;
companyEL.ID = friend_CompanyID;
companyEL.ExecuteEL(2);
HF.Cloud.BLL.Common.Logger.Error("GetNotice方法获取到好友公司名字:" + companyEL.CompanyName);
string friend_CompanyName = companyEL.CompanyName;
//获取群组相关
if (dr["NoticeType"].ToString() == "3")//3为群组审核通知
{
long groupID = long.Parse(dr["GroupID"].ToString());
groupEL.ID = groupID;
groupEL.ExecuteEL(3);
HF.Cloud.BLL.Common.Logger.Error("GetNotice方法获取到群组名称:" + groupEL.GroupName + "---群组ID:" + groupID);
dic.Add("GroupID", groupID.ToString()); //群组ID，入群审核用
dic.Add("GroupName", groupEL.GroupName); //群组名称，入群审核用
}
dic.Add("UserName", friend_Name);
dic.Add("Session", friend_Session);
dic.Add("ImgUrl", friend_Img);
dic.Add("CompanyName", friend_CompanyName);
dic.Add("NoticeID", dr["ID"].ToString());//ID:这里是单个Notice表里的ID
dic.Add("CreateTime", dr["CreateTime"].ToString());
dic.Add("NoticeType", dr["NoticeType"].ToString());
dic.Add("NoticeState", dr["NoticeState"].ToString());
dic.Add("IsLook", dr["IsLook"].ToString());
}
if (noticeType == "2") //系统通知
{
dic.Add("NoticeID", dr["ID"].ToString()); //系统通知表的通知ID
string noticeTitleStr = dr["NoticeTitle"].ToString();
string noticeTitle = noticeTitleStr.Length > 10 ? noticeTitleStr.Substring(0, 10) + "..." : noticeTitleStr;
dic.Add("NoticeTitle", noticeTitle);
string noticeContentStr = dr["NoticeContent"].ToString();
string noticeContent = noticeContentStr.Length > 20 ? noticeContentStr.Substring(0, 20) + "..." : noticeContentStr;
dic.Add("NoticeContent", noticeContent);
dic.Add("AddressUrl", dr["AddressUrl"].ToString());
dic.Add("NoticeType", "2");
dic.Add("IsLook", dr["IsLook"].ToString());
dic.Add("CreateTime", dr["CreateTime"].ToString());
}
list.Add(dic);
}
////调用此接口后默认都查看通知了，把通知都变为已经查看
//noticeEL.IsLook = 1;
//int ra;
//long noticQue = noticeEL.ExecNonQuery(3, out ra);
//HF.Cloud.BLL.Common.Logger.Error("GetNotice方法更改为已经查看的记录数为:" + ra.ToString());
string strJson = js.Serialize(list);
HF.Cloud.BLL.Common.Logger.Error("GetNotice方法返回json数据：" + strJson);
return(strJson);
}
/// <summary>
/// 群组人员列表
/// </summary>
/// <param name="groupID">群组ID</param>
/// <returns></returns>
public string GetGroupFriendList(string session, string groupID)
{
HF.Cloud.BLL.Common.Logger.Error("GetGroupFriendList方法获取到的参数groupID:" + groupID);
JavaScriptSerializer js = new JavaScriptSerializer();
Dictionary <string, object> dic = new Dictionary <string, object>();
List <Dictionary <string, object> > list = new List <Dictionary <string, object> >();
//通过groupID获取群信息
GroupEL groupEL = new GroupEL();
SB_UserEL userEL = new SB_UserEL();
UserUniteGroupEL userGroupEL = new UserUniteGroupEL();
long groupID_long = long.Parse(groupID);
groupEL.ID = groupID_long;
groupEL.ExecuteEL(3);
HF.Cloud.BLL.Common.Logger.Error("GetGroupFriendList方法获取到群组名称:" + groupEL.GroupName);
string groupName = ""; //群名称
long ownerUserID = 0; //群主userID
string introduce = ""; //群简介
string isOpen = ""; //1公开或0私密
if (!string.IsNullOrEmpty(groupEL.GroupName))
{
groupName = groupEL.GroupName;
ownerUserID = groupEL.OwnerUserID;
introduce = groupEL.Introduce;
isOpen = groupEL.IsOpen.ToString();
}
//通过ownerUserID获取群主Name
userEL.ID = ownerUserID;
userEL.ExecuteEL(4);
HF.Cloud.BLL.Common.Logger.Error("GetGroupFriendList方法获取到群主姓名:" + userEL.UserName);
string ownerUserName = "";
if (!string.IsNullOrEmpty(userEL.UserName))
{
ownerUserName = userEL.UserName;
}
string userSession = userEL.Session_True;
//通过群ID获取群有多少人
userGroupEL.GroupID = groupID_long;
DataTable dt_Count = userGroupEL.ExecDT(31);
HF.Cloud.BLL.Common.Logger.Error("GetGroupFriendList方法获取到本群人数:" + dt_Count.Rows.Count);
int groupCount = dt_Count.Rows.Count;
foreach (DataRow dr in dt_Count.Rows)
{
//获取到userID
string userID = dr["UserID"].ToString();
UserBLL userBLL = new UserBLL();
string userInfo = userBLL.GetUserInfoByUserID(userID);
//把userInfo反序列化出来
Dictionary <string, object> json_userInfo = new Dictionary <string, object>();
json_userInfo = js.Deserialize <Dictionary <string, object> >(userInfo);
//加上置顶字段 IsTop 2018-1-15
json_userInfo.Add("IsTop", dr["IsTop"].ToString());
list.Add(json_userInfo);
}
dic.Add("GroupName", groupName);
dic.Add("GroupOwnerName", ownerUserName);
dic.Add("Introduce", introduce);
dic.Add("IsOpen", isOpen);
dic.Add("GroupCount", groupCount.ToString());
dic.Add("GroupID", groupID.ToString());
dic.Add("IsGroupOwner", session == userSession?"1":"0");
dic.Add("User", list);
string strJson = js.Serialize(dic);
HF.Cloud.BLL.Common.Logger.Error("GetGroupFriendList方法返回的json数据：" + strJson);
return(strJson);
}
/// <summary>
/// 获取用户综合信息
/// </summary>
/// <param name="session">本人session</param>
/// <param name="sessionFriend">需要获取信息的用户session</param>
/// <returns></returns>
public string GetUserInfoBySessionAndSessionFriend(string session, string sessionFriend)
{
HF.Cloud.BLL.Common.Logger.Error("GetUserInfoBySessionAndSessionFriend获取用户信息方法获取到参数session：" + session + "-----sessionFriend:" + sessionFriend);
JavaScriptSerializer js = new JavaScriptSerializer();
Dictionary <string, object> dic = new Dictionary <string, object>();
//通过sessionFriend获取用户
SB_UserEL userel = new SB_UserEL();
userel.Session_True = sessionFriend;
userel.ExecuteEL(41);
HF.Cloud.BLL.Common.Logger.Error("GetUserInfoBySessionAndSessionFriend获取用户信息结果（大于0说明成功）：" + userel.ID);
if (userel.ID > 0)
{
dic.Add("UserName", userel.UserName);
dic.Add("UserTel", userel.UserTel);
dic.Add("Duty", userel.Duty);
dic.Add("UserEmail", userel.UserEmail);
dic.Add("Detail", userel.Detail);
dic.Add("ImgUrl", userel.ImgUrl);
dic.Add("Session", userel.Session_True);
#region 人气值
//组合人气值，人气值=好友查看的次数（好友第一次查看有效，一次以上的不记录）+所有群组群友人数和
int popularityInt = 0; //人气值
//用户查看人气值
PopularityBLL popularityBLL = new PopularityBLL();
//通过Session换取UserID
UserBLL userBLL = new UserBLL();
long userID = userBLL.GetUserIDBySession(session);
long userID_Friend = userBLL.GetUserIDBySession(sessionFriend);
HF.Cloud.BLL.Common.Logger.Error("GetUserInfoBySessionAndSessionFriend方法获取到的用户ID userID：" + userID + "---userID_Friend:" + userID_Friend);
int friendLookInt = popularityBLL.GetPopularityNumber(userID);
HF.Cloud.BLL.Common.Logger.Error("GetUserInfoBySessionAndSessionFriend方法用户查看人气值为：" + friendLookInt);
popularityInt += friendLookInt;
//群组群友人数和
GroupBLL groupBLL = new GroupBLL();
int groupNumber = groupBLL.GetGroupPopularityNumber(userID);
HF.Cloud.BLL.Common.Logger.Error("GetUserInfoBySessionAndSessionFriend方法群组人气值为：" + groupNumber);
popularityInt += groupNumber;
dic.Add("Popularity", popularityInt);//人气
#endregion
string companyName = "";
//通过公司ID查询公司名称
CompanysEL compEL = new CompanysEL();
compEL.ID = userel.CompanyID;
compEL.ExecuteEL(2);
HF.Cloud.BLL.Common.Logger.Error("GetUserInfoBySessionAndSessionFriend获取公司信息结果（公司名称为）：" + compEL.CompanyName);
if (!string.IsNullOrEmpty(compEL.CompanyName))
{
companyName = compEL.CompanyName;
}
dic.Add("CompanyName", companyName);
dic.Add("CompanyIcon", compEL.CompanyIcon);
dic.Add("CompanyID", compEL.ID);
///公司简介
string companyIntroduceStr = compEL.Introduce;
string introduceStr = companyIntroduceStr.Length < 50 ? companyIntroduceStr : companyIntroduceStr.Substring(0, 50).ToString() + "...";
dic.Add("CompanyIntroduce", introduceStr);
//查看是否有查看sessionFriend用户的记录，有就不用管，没有的话就在SB_Popularity添加一个记录
bool isLook = popularityBLL.IsLooked(userID, userID_Friend);
HF.Cloud.BLL.Common.Logger.Error("GetUserInfoBySessionAndSessionFriend方法，此用户是否被查看过：" + isLook);
if (!isLook) //如果没有记录就添加一个
{
long insertPopularity = popularityBLL.InsertPopularity(userID, userID_Friend);
HF.Cloud.BLL.Common.Logger.Error("GetUserInfoBySessionAndSessionFriend人气值增加结果：" + insertPopularity);
}
}
//获取公司关键字
CompanysBLL companyBLL = new CompanysBLL();
string tags = companyBLL.GetCompanyTag_String(userel.CompanyID.ToString());
dic.Add("Tags", tags);
HF.Cloud.BLL.Common.Logger.Error("GetUserInfoBySessionAndSessionFriend获取公司关键字：" + tags);
//获取点赞个数
ThumbsBLL thumbsBLL = new ThumbsBLL();
string thumbs = thumbsBLL.GetThumbs(sessionFriend);
HF.Cloud.BLL.Common.Logger.Error("GetUserInfoBySessionAndSessionFriend获取点赞个数：" + thumbs);
dic.Add("Thumb", thumbs.ToString());//点赞个数
//这里要注意，第一个参数是好友的sesison，第二个参数是自己的session
string isHadThumb = thumbsBLL.IsHadThumb(sessionFriend, session);
dic.Add("IsHadThumb", isHadThumb);//是否被点赞
//获取保存数
FriendsBLL friendsBLL = new FriendsBLL();
int saves = friendsBLL.GetSaveNumber(sessionFriend);
HF.Cloud.BLL.Common.Logger.Error("GetUserInfoBySessionAndSessionFriend获取保存个数：" + saves);
dic.Add("Save", saves.ToString());//保存个数
//如果session==sessionFriend，说明是自己看自己
if (session == sessionFriend)
{
dic.Add("Who", "0");
}
else
{
//查看sessionFriend是否是session的好友
bool isFriend = friendsBLL.IsFriend(session, sessionFriend);
if (isFriend)
{
//说明是好友
dic.Add("Who", "1");
}
else
{
//说明不是好友
dic.Add("Who", "2");
}
}
//小程序的token
WX_TokenBLL tokenBLL = new WX_TokenBLL();
string token = tokenBLL.GetToken();
dic.Add("Token", token);
string strJson = js.Serialize(dic);
HF.Cloud.BLL.Common.Logger.Error("GetUserInfoBySessionAndSessionFriend返回的数据为：" + strJson);
return(strJson);
}
protected string ValidateInput()
{
string tips = string.Empty;
if (this.txtSBName.Text.Trim() == string.Empty)
{
tips += "企业名称不能为空！\\n";
}
else
{
//SB_UserMEL userM = new SB_UserMEL()
//{
// SBName = this.txtSBName.Text.Trim()
//};
//userM.ExecuteEL(43);
//if (!string.IsNullOrEmpty(userM.ApplyIP))
//{
// tips += "企业名称已经注册，不能重复注册！\\n";
//}
}
if (this.txtUserCode.Text.Trim() != string.Empty)
{
if (PageValidate.IsPhone(this.txtUserCode.Text.Trim()))
{
SB_UserMEL userM = new SB_UserMEL()
{
SBMobile = this.txtUserCode.Text.Trim()
};
userM.ExecuteEL(44);
if (!string.IsNullOrEmpty(userM.ApplyIP))
{
tips += "手机号已在服务商注册，不能重复注册！\\n";
}
SB_UserEL user = new SB_UserEL()
{
UserCode = this.txtUserCode.Text.Trim()
};
user.ExecuteEL(41);
if (!string.IsNullOrEmpty(user.UserName))
{
tips += "手机号已作为账户被注册过，不能重复注册！\\n";
}
}
else
{
tips += "手机号格式输入不正确，请重新输入！\\n";
}
}
else
{
tips += "手机号不能为空！\\n";
}
if (this.txtUserName.Text.Trim() == string.Empty)
{
tips += "管理员姓名不能为空！";
}
return(tips);
}
/// <summary>
/// 我的群组列表
/// </summary>
/// <param name="session">session</param>
/// <returns></returns>
public string GetMyGroups(string session)
{
HF.Cloud.BLL.Common.Logger.Error("GetMyGroups方法获取到的参数session:" + session);
JavaScriptSerializer js = new JavaScriptSerializer();
List <Dictionary <string, object> > list = new List <Dictionary <string, object> >();
//通过Session获取UerID
UserBLL userBLL = new UserBLL();
long userID = userBLL.GetUserIDBySession(session);
HF.Cloud.BLL.Common.Logger.Error("GetMyGroups方法获取到的UserID:" + userID);
//通过userID获取GroupID
UserUniteGroupEL userGroupEL = new UserUniteGroupEL();
userGroupEL.UserID = userID;
DataTable dt = userGroupEL.ExecDT(3);
HF.Cloud.BLL.Common.Logger.Error("GetMyGroups方法获取到群组个数为:" + dt.Rows.Count);
GroupEL groupEL = new GroupEL();
SB_UserEL userEL = new SB_UserEL();
foreach (DataRow dr in dt.Rows)
{
//通过群ID获取群信息
long groupID = (long)dr["GroupID"];
groupEL.ID = groupID;
groupEL.ExecuteEL(3);
HF.Cloud.BLL.Common.Logger.Error("GetMyGroups方法获取到群组名称:" + groupEL.GroupName);
string groupName = "";
long ownerUserID = 0;
string createTime = "";
if (!string.IsNullOrEmpty(groupEL.GroupName))
{
groupName = groupEL.GroupName;
ownerUserID = groupEL.OwnerUserID;
createTime = groupEL.CreateTime;
}
//通过ownerUserID获取群主Name
userEL.ID = ownerUserID;
userEL.ExecuteEL(4);
HF.Cloud.BLL.Common.Logger.Error("GetMyGroups方法获取到群主姓名:" + userEL.UserName);
string ownerUserName = "";
if (!string.IsNullOrEmpty(userEL.UserName))
{
ownerUserName = userEL.UserName;
}
//通过群ID获取群有多少人
userGroupEL.GroupID = groupID;
DataTable dt_Count = userGroupEL.ExecDT(31);
HF.Cloud.BLL.Common.Logger.Error("GetMyGroups方法获取到本群人数:" + dt_Count.Rows.Count);
int groupCount = dt_Count.Rows.Count;
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("GroupName", groupName);
dic.Add("GroupOwnerName", ownerUserName);
dic.Add("CreateTime", createTime);
dic.Add("GroupCount", groupCount.ToString());
dic.Add("GroupID", groupID.ToString());
list.Add(dic);
}
string strJson = js.Serialize(list);
HF.Cloud.BLL.Common.Logger.Error("GetMyGroups方法返回的json数据：" + strJson);
return(strJson);
}
