private void QQMain_Load(object sender, EventArgs e) { //本函数用于加载数据库, 加载好友列表 //加载数据库, 查找所有我的好友 TFriend_DAL.TFriend manage = new TFriend_DAL.TFriend(); DataSet DataSet = manage.GetList(" QQID= " + Data.QQId + " "); //遍历表的每一行 foreach (DataRow row in DataSet.Tables[0].Rows) { if (ChatListItem_Exist(row["FriendGroup"].ToString()) == false) { ChatListItem_Add_Item(row["FriendGroup"].ToString()); } TFriend_Model.TFriend_data data = new TFriend_Model.TFriend_data(); data.QQId = this.Data.QQId; data.QQFriendID = row["QQFriendID"].ToString(); data.MakeFriendDate = System.DateTime.Now; data.FriendName = row["FriendName"].ToString(); data.FriendGroup = row["FriendGroup"].ToString(); data.FriendSign = row["FriendSign"].ToString(); //MessageBox.Show(row["QQID"] + " " + row["QQFriendID"] + " " + row["FriendGroup"] + "\n" ); ChatListItem_Add_Friend(GetGroup(row["FriendGroup"].ToString()), data); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(RC403ZhangChenYang.TFriend_Model.TFriend_data model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TFriend("); strSql.Append("QQId,FriendName,QQFriendID,FriendGroup,MakeFriendDate,FriendSign)"); strSql.Append(" values ("); strSql.Append("@QQId,@FriendName,@QQFriendID,@FriendGroup,@MakeFriendDate,@FriendSign)"); SqlParameter[] parameters = { new SqlParameter("@QQId", SqlDbType.NVarChar, 16), new SqlParameter("@FriendName", SqlDbType.NVarChar, 16), new SqlParameter("@QQFriendID", SqlDbType.NVarChar, 16), new SqlParameter("@FriendGroup", SqlDbType.NChar, 20), new SqlParameter("@MakeFriendDate", SqlDbType.DateTime), new SqlParameter("@FriendSign", SqlDbType.NVarChar, 100) }; parameters[0].Value = model.QQId; parameters[1].Value = model.FriendName; parameters[2].Value = model.QQFriendID; parameters[3].Value = model.FriendGroup; parameters[4].Value = model.MakeFriendDate; parameters[5].Value = model.FriendSign; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public RC403ZhangChenYang.TFriend_Model.TFriend_data GetModel(string QQID, string QQFriendID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 QQId,FriendName,QQFriendID,FriendGroup,MakeFriendDate,FriendSign from TFriend "); strSql.Append(" where QQID=@QQID and QQFriendID=@QQFriendID "); SqlParameter[] parameters = { new SqlParameter("@QQID", SqlDbType.NVarChar, 16), new SqlParameter("@QQFriendID", SqlDbType.NVarChar, 16), }; parameters[0].Value = QQID; parameters[1].Value = QQFriendID; RC403ZhangChenYang.TFriend_Model.TFriend_data model = new RC403ZhangChenYang.TFriend_Model.TFriend_data(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["QQId"] != null && ds.Tables[0].Rows[0]["QQId"].ToString() != "") { model.QQId = ds.Tables[0].Rows[0]["QQId"].ToString(); } if (ds.Tables[0].Rows[0]["FriendName"] != null && ds.Tables[0].Rows[0]["FriendName"].ToString() != "") { model.FriendName = ds.Tables[0].Rows[0]["FriendName"].ToString(); } if (ds.Tables[0].Rows[0]["QQFriendID"] != null && ds.Tables[0].Rows[0]["QQFriendID"].ToString() != "") { model.QQFriendID = ds.Tables[0].Rows[0]["QQFriendID"].ToString(); } if (ds.Tables[0].Rows[0]["FriendGroup"] != null && ds.Tables[0].Rows[0]["FriendGroup"].ToString() != "") { model.FriendGroup = ds.Tables[0].Rows[0]["FriendGroup"].ToString(); } if (ds.Tables[0].Rows[0]["MakeFriendDate"] != null && ds.Tables[0].Rows[0]["MakeFriendDate"].ToString() != "") { model.MakeFriendDate = DateTime.Parse(ds.Tables[0].Rows[0]["MakeFriendDate"].ToString()); } if (ds.Tables[0].Rows[0]["FriendSign"] != null && ds.Tables[0].Rows[0]["FriendSign"].ToString() != "") { model.FriendSign = ds.Tables[0].Rows[0]["FriendSign"].ToString(); } return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(RC403ZhangChenYang.TFriend_Model.TFriend_data model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update TFriend set "); strSql.Append("FriendName=@FriendName,"); strSql.Append("QQFriendID=@QQFriendID,"); strSql.Append("FriendGroup=@FriendGroup,"); strSql.Append("MakeFriendDate=@MakeFriendDate,"); strSql.Append("FriendSign=@FriendSign"); strSql.Append(" where QQId=@QQId "); SqlParameter[] parameters = { new SqlParameter("@FriendName", SqlDbType.NVarChar, 16), new SqlParameter("@QQFriendID", SqlDbType.NVarChar, 16), new SqlParameter("@FriendGroup", SqlDbType.NChar, 20), new SqlParameter("@MakeFriendDate", SqlDbType.DateTime), new SqlParameter("@FriendSign", SqlDbType.NVarChar, 100), new SqlParameter("@QQId", SqlDbType.NVarChar, 16) }; parameters[0].Value = model.FriendName; parameters[1].Value = model.QQFriendID; parameters[2].Value = model.FriendGroup; parameters[3].Value = model.MakeFriendDate; parameters[4].Value = model.FriendSign; parameters[5].Value = model.QQId; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加结点sub_ttem到parent_item中 /// </summary> /// <param name="parent_item"></param> /// <param name="sub_item_id"></param> private void ChatListItem_Add_Friend(CCWin.SkinControl.ChatListItem parent_item, TFriend_Model.TFriend_data sub_item_data) { CCWin.SkinControl.ChatListSubItem chatListSubItem = new CCWin.SkinControl.ChatListSubItem(); chatListSubItem.DisplayName = sub_item_data.FriendName;//"displayName"; chatListSubItem.ID = int.Parse(sub_item_data.QQFriendID); chatListSubItem.NicName = "ID : " + sub_item_data.QQFriendID; chatListSubItem.PersonalMsg = sub_item_data.FriendSign; //设置一些默认值 chatListSubItem.Bounds = new System.Drawing.Rectangle(0, 0, 0, 0); chatListSubItem.HeadImage = null; chatListSubItem.HeadRect = new System.Drawing.Rectangle(0, 0, 0, 0); chatListSubItem.IpAddress = null; chatListSubItem.IsTwinkle = false; chatListSubItem.IsTwinkleHide = false; chatListSubItem.OwnerListItem = parent_item; chatListSubItem.Status = CCWin.SkinControl.ChatListSubItem.UserStatus.Online; chatListSubItem.Tag = null; chatListSubItem.TcpPort = 0; chatListSubItem.UpdPort = 0; parent_item.SubItems.AddRange(new CCWin.SkinControl.ChatListSubItem[] { chatListSubItem }); }