/// <summary> /// 得到一个对象实体 /// </summary> public Model.userInfo GetModel(int customerID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 "); strSql.Append(" customerID,customerName,pID,telephone,address "); strSql.Append(" from userInfo "); strSql.Append(" where customerID=" + customerID + ""); Model.userInfo model = new Model.userInfo(); DataSet ds = DbHelperSQL.Query(strSql.ToString()); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
private void getrecentfriend() { FileStream fs = new FileStream(Application.StartupPath + "\\" + "friend.txt", FileMode.Open, FileAccess.Read); StreamReader sr = new StreamReader(fs); int index = 0; while (sr.Peek() > -1) { string tmp = sr.ReadLine(); string[] res = tmp.Split(' '); foreach (Model.friendInfo fri in myFriends) { if (this._user.userID == Convert.ToInt32(res[0]) && res[1] == fri.friendID.ToString()) { BLL.friendInfo bllfrq = new BLL.friendInfo(); List <Model.friendInfo> bllfq = bllfrq.GetModelList("userid=" + _user.userID + "and friendid=" + Convert.ToInt32(res[1]) + ""); UCFriendInfo ucRecentfriend = new UCFriendInfo(_user, this); BLL.userInfo frueser = new BLL.userInfo(); Model.userInfo u = frueser.GetModel(bllfq[0].friendID); ucRecentfriend.Top = ucRecentfriend.Height * index; ucRecentfriend.UserName = bllfq[0].friendName; ucRecentfriend.NickName = bllfq[0].friendName; ucRecentfriend.UserShuoshuo = u.userShuoshuo; ucRecentfriend.FriendInfo = u; ucRecentfriend.HeadImage = this.imageList1.Images[Convert.ToInt32(u.userHeadImage)]; this.pnrecentfriend.Controls.Add(ucRecentfriend); ucRecentfriend.MouseClick += new MouseEventHandler(ucf_MouseClick); //ucRecentfriend.MouseLeave += new EventHandler(ucf_MouseLeave); //ucRecentfriend.myDBClick += new UCFriendInfo.delDBClick(ucf_myDBClick); //ucRecentfriend.MouseEnter += new EventHandler(ucf_MouseEnter); index++; } } } sr.Close(); fs.Close(); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.userInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update userInfo set "); if (model.customerName != null) { strSql.Append("customerName='" + model.customerName + "',"); } if (model.pID != null) { strSql.Append("pID='" + model.pID + "',"); } if (model.telephone != null) { strSql.Append("telephone='" + model.telephone + "',"); } if (model.address != null) { strSql.Append("address='" + model.address + "',"); } else { strSql.Append("address= null ,"); } int n = strSql.ToString().LastIndexOf(","); strSql.Remove(n, 1); strSql.Append(" where customerID=" + model.customerID + ""); int rowsAffected = DbHelperSQL.ExecuteSql(strSql.ToString()); if (rowsAffected > 0) { return(true); } else { return(false); } }
private void FrmGroupTalk_Load(object sender, EventArgs e) { this.textBox2.Text = this._uc.Groupannouncement; FrmMain frm = new FrmMain(); BLL.groupu bll = new BLL.groupu(); List <Model.groupu> mylist = bll.GetModelList("groupID=" + this._uc.GroupID); int index = 0; foreach (Model.groupu mg in mylist) { BLL.userInfo bu = new BLL.userInfo(); Model.userInfo mu = bu.GetModel(mg.groupfriendID); UCGroup ucg1 = new UCGroup(); ucg1.Top = ucg1.Height * index; ucg1.Id1 = mg.groupfriendID; ucg1.HeadImage = frm.imageList1.Images[Convert.ToInt32(mu.userHeadImage)]; ucg1.Username = mu.userName; luc.Add(ucg1); this.panel1.Controls.Add(ucg1); index++; } }
private void LoginToMain() { string userID = this.cmbUser.Text; string userPWD = this.textBox1.Text; if (userID == "" || userPWD == "") { return; } BLL.userInfo bllUserInfo = new BLL.userInfo(); Model.userInfo user = bllUserInfo.GetModel(Convert.ToInt32(userID)); if (userPWD != user.userPWD) { return; } user.userID = Convert.ToInt32(userID); user.userState = temp; bllUserInfo.Update(user); FrmMain frm = new FrmMain(user, this); frm.Show(); this.Hide(); }
private void button1_Click(object sender, EventArgs e) { label8.Text = ""; textBox2.Text = ""; textBox3.Text = ""; textBox4.Text = ""; string pid = textBox1.Text; BLL.userInfo bll = new BLL.userInfo(); Model.userInfo model = bll.GetModel(pid); if (model != null) { textBox2.Text = model.customerName; textBox3.Text = model.telephone; textBox4.Text = model.address; CustomerID = model.customerID; label8.Text = "老客户,基本信息不用重填"; } else { label8.Text = "新客户,请填基本信息"; } }
public FrmimmediatelyMsg(List <RelFriendToFrmTalk> ft, FrmMain frm, Model.userInfo me, Model.userInfo friend, string nickName) { InitializeComponent(); this._me = me; this._friend = friend; this._nickName = nickName; this._frm = frm; this._ft = ft; }
public FrmEditInfo(Model.userInfo user, FrmMain frm) { InitializeComponent(); this._user = user; this._frm = frm; }
private void timeSystemn_Tick(object sender, EventArgs e) { BLL.messsageInfo bmess = new BLL.messsageInfo(); List <Model.messsageInfo> mmess = bmess.GetModelList("receiverID= '" + this._user.userID + "'and messageState=20 "); foreach (Model.messsageInfo m in mmess) { BLL.messsageInfo BllMsgInfo = new BLL.messsageInfo(); Model.messsageInfo msg = new Model.messsageInfo(); msg.messageContent = m.messageContent; msg.senderID = m.senderID; msg.receiverID = m.receiverID; msg.messageState = 21; msg.sendTime = m.sendTime; msg.messageID = m.messageID; BllMsgInfo.Update(msg); BLL.userInfo bll2 = new BLL.userInfo(); Model.userInfo mfriend2 = bll2.GetModel(m.senderID); FrmimmediatelyMsg frm = new FrmimmediatelyMsg(tbFriendTalkInfo, this, this._user, mfriend2, mfriend2.userName); frm.Show(); } BLL.friendRequest bl = new BLL.friendRequest(); List <Model.friendRequest> mfrien = bl.GetModelList("senderID= '" + this._user.userID + "'and Station=2 "); foreach (Model.friendRequest m in mfrien) { FrmOkWarn sw = new FrmOkWarn(m, this); sw.Show(); Model.friendRequest mf = new Model.friendRequest(); mf.ID = m.ID; mf.NickName = m.NickName; mf.NumOfSameFriend = m.NumOfSameFriend; mf.receiveID = m.receiveID; mf.senderID = m.senderID; mf.ValidationInfo = m.ValidationInfo; mf.ValidationTime = m.ValidationTime; mf.Station = 5; bl.Update(mf); } BLL.friendRequest bll = new BLL.friendRequest(); List <Model.friendRequest> mfriend = bll.GetModelList("receiveID= '" + this._user.userID + "'and Station=1 "); foreach (Model.friendRequest m in mfriend) { SystemWarn sw = new SystemWarn(m, this); sw.Show(); Model.friendRequest mf = new Model.friendRequest(); mf.ID = m.ID; mf.NickName = m.NickName; mf.NumOfSameFriend = m.NumOfSameFriend; mf.receiveID = m.receiveID; mf.senderID = m.senderID; mf.ValidationInfo = m.ValidationInfo; mf.ValidationTime = m.ValidationTime; mf.Station = 5; bll.Update(mf); } BLL.groupu bllgroup = new BLL.groupu(); List <Model.groupu> mgroup = bllgroup.GetModelList("groupuserID=" + this._user.userID); if (mgroup.Count != 0) { int receiverID = mgroup[0].groupID; List <Model.friendRequest> mfriend2 = bll.GetModelList("receiveID= '" + receiverID + "'and Station=1 "); foreach (Model.friendRequest m in mfriend2) { FrmGroupWarn sw = new FrmGroupWarn(m, this); sw.Show(); Model.friendRequest mf = new Model.friendRequest(); mf.ID = m.ID; mf.NumOfSameFriend = m.NumOfSameFriend; mf.receiveID = m.receiveID; mf.senderID = m.senderID; mf.ValidationInfo = m.ValidationInfo; mf.ValidationTime = m.ValidationTime; mf.Station = 5; bll.Update(mf); } } }
public void getFriendList() { BLL.friendInfo bllFriend = new BLL.friendInfo(); myFriends = bllFriend.GetModelList("userID =" + this._user.userID.ToString()); int index = 0; ucflFriend.Clear(); foreach (Model.friendInfo f in myFriends) { UCFriendInfo ucF = new UCFriendInfo(); RelFriendToFrmTalk ft = new RelFriendToFrmTalk(); BLL.userInfo bllUserInfo = new BLL.userInfo(); Model.userInfo friend = bllUserInfo.GetModel(f.friendID); if (friend.userState != 2 && friend.userState != 3) { ucF.Top = ucF.Height * index; ucF.HeadImage = this.imageList1.Images[Convert.ToInt32(friend.userHeadImage)]; ucF.UserName = f.friendName; ucF.myDBClick += new UCFriendInfo.delDBClick(ucF_myDBClick); ucF.MouseClick += new MouseEventHandler(ucF_MouseClick); ucF.FriendInfo = friend; ucF.NickName = f.friendName; ucF.UserShuoshuo = friend.userShuoshuo; ucF.FID = f.ID; if (ucF.UserShuoshuo.Length >= 10) { ucF.UserShuoshuo = ucF.UserShuoshuo.Substring(0, 10) + "..."; } this.panel1.Controls.Add(ucF); index++; ft.FriendId = f.friendID; ft.IsOpenTalkForm = false; ft.Frm = null; tbFriendTalkInfo.Add(ft); ucF.UserID = f.friendID; ucflFriend.Add(ucF); } } foreach (Model.friendInfo f in myFriends) { UCFriendInfo ucF = new UCFriendInfo(); RelFriendToFrmTalk ft = new RelFriendToFrmTalk(); BLL.userInfo bllUserInfo = new BLL.userInfo(); Model.userInfo friend = bllUserInfo.GetModel(f.friendID); if (friend.userState == 2 || friend.userState == 3) { ucF.Top = ucF.Height * index; ucF.HeadImage = this.imageList1.Images[Convert.ToInt32(friend.userHeadImage) + 110]; ucF.UserName = f.friendName; ucF.myDBClick += new UCFriendInfo.delDBClick(ucF_myDBClick); ucF.MouseClick += new MouseEventHandler(ucF_MouseClick); ucF.FriendInfo = friend; ucF.NickName = f.friendName; ucF.UserShuoshuo = friend.userShuoshuo; ucF.FID = f.ID; if (ucF.UserShuoshuo.Length >= 10) { ucF.UserShuoshuo = ucF.UserShuoshuo.Substring(0, 10) + "..."; } this.panel1.Controls.Add(ucF); index++; ft.FriendId = f.friendID; ft.IsOpenTalkForm = false; ft.Frm = null; tbFriendTalkInfo.Add(ft); ucF.UserID = f.friendID; ucflFriend.Add(ucF); } } }
public int userLogin(Model.userInfo m_userInfo) //把model层的值传过来进行比对 { return(d_userAccess.userLogin(m_userInfo.username, m_userInfo.password)); //如果有返回值则登录成功 }
public FrmAddFrend(FrmMain frm, Model.userInfo user) { InitializeComponent(); this._frm = frm; this._user = user; }
public FrmDeleteMember(Model.userInfo user, FrmMain frm) { InitializeComponent(); this._user = user; this._frm = frm; }