/// <summary> /// 更新一条数据 /// <param name="model">实体</param> /// </summary> public bool Update(IM_GroupMemberInfo model) { StringBuilder strSql = new StringBuilder(); int n = 0; strSql.Append("update IM_GroupMember set "); strSql.Append("GroupID=@GroupID,"); strSql.Append("UserID=@UserID,"); strSql.Append("OrderIndex=@OrderIndex"); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@GroupID", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@UserID", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@OrderIndex", SqlDbType.Int, 4), new SqlParameter("@ID", SqlDbType.UniqueIdentifier, 16) }; parameters[n++].Value = model.GroupID; parameters[n++].Value = model.UserID; parameters[n++].Value = model.OrderIndex; parameters[n++].Value = model.ID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public IM_GroupMemberInfo DataRowToModel(DataRow row) { IM_GroupMemberInfo model = new IM_GroupMemberInfo(); if (row != null) { if (row["ID"] != null && row["ID"].ToString() != "") { model.ID = new Guid(row["ID"].ToString()); } if (row["GroupID"] != null && row["GroupID"].ToString() != "") { model.GroupID = new Guid(row["GroupID"].ToString()); } if (row["UserID"] != null && row["UserID"].ToString() != "") { model.UserID = new Guid(row["UserID"].ToString()); } if (row["OrderIndex"] != null && row["OrderIndex"].ToString() != "") { model.OrderIndex = int.Parse(row["OrderIndex"].ToString()); } } return(model); }
/// <summary> /// 获取群内成员 /// <param name="userID"></param> /// <param name="groupID"></param> /// </summary> public List <IM_GroupMemberInfo> GetListForMenber(Guid userID, Guid groupID) { StringBuilder strSql = new StringBuilder(); strSql.Append(@" select [IM_GroupMember].*,UserName,Pic from [IM_GroupMember] inner join (select * from [IM_GroupMember] where UserID=@UserID and GroupID=@GroupID)a on [IM_GroupMember].GroupID=a.GroupID inner join [dbo].[IM_User] on [IM_GroupMember].UserID=[IM_User].ID "); SqlParameter[] parameters = { new SqlParameter("@UserID", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@GroupID", SqlDbType.UniqueIdentifier, 16) }; parameters[0].Value = userID; parameters[1].Value = groupID; DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); List <IM_GroupMemberInfo> list = new List <IM_GroupMemberInfo>(); foreach (DataRow row in ds.Tables[0].Rows) { IM_GroupMemberInfo model = new IM_GroupMemberInfo(); if (row != null) { if (row["ID"] != null && row["ID"].ToString() != "") { model.ID = new Guid(row["ID"].ToString()); } if (row["GroupID"] != null && row["GroupID"].ToString() != "") { model.GroupID = new Guid(row["GroupID"].ToString()); } if (row["UserID"] != null && row["UserID"].ToString() != "") { model.UserID = new Guid(row["UserID"].ToString()); } if (row["OrderIndex"] != null && row["OrderIndex"].ToString() != "") { model.OrderIndex = int.Parse(row["OrderIndex"].ToString()); } if (row["UserName"] != null && row["UserName"].ToString() != "") { model.UserName = row["UserName"].ToString(); } if (row["Pic"] != null && row["Pic"].ToString() != "") { model.Pic = row["Pic"].ToString(); } } list.Add(model); } return(list); }
protected void btnAdd_Click(object sender, EventArgs e) { IM_GroupInfo groupModel = new IM_GroupInfo(); groupModel.ID = Guid.NewGuid(); groupModel.GroupName = txtGroupName.Text; groupModel.UserID = userInfo.UserID; new IM_GroupBLL().Add(groupModel); IM_GroupMemberInfo groupMemberModel = new IM_GroupMemberInfo(); groupMemberModel.ID = Guid.NewGuid(); groupMemberModel.GroupID = groupModel.ID; groupMemberModel.UserID = groupModel.UserID; new IM_GroupMemberBLL().Add(groupMemberModel); txtGroupName.Text = string.Empty; lbError.Text = "完成添加"; ClientScript.RegisterStartupScript(this.GetType(), "JS", "<script>window.onload = function () {window.parent.window.addGroup('" + groupModel.ID + "','" + groupModel.GroupName + "');};</script>"); }
/// <summary> /// 增加一条数据 /// <param name="model">实体</param> /// </summary> public bool Add(IM_GroupMemberInfo model) { StringBuilder strSql = new StringBuilder(); int n = 0; strSql.Append(@"if exists(select 1 from IM_GroupMember where UserID=@UserID and GroupID=@GroupID) begin select -1 as ifCanDo return end "); strSql.Append("insert into IM_GroupMember("); strSql.Append("ID,GroupID,UserID,OrderIndex)"); strSql.Append(" values ("); strSql.Append("@ID,@GroupID,@UserID,@OrderIndex)"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@GroupID", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@UserID", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@OrderIndex", SqlDbType.Int, 4) }; parameters[n++].Value = model.ID; parameters[n++].Value = model.GroupID; parameters[n++].Value = model.UserID; parameters[n++].Value = model.OrderIndex; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
protected void btnOK_Click(object sender, EventArgs e) { string id = Request["ID"]; new IM_NewsBLL().UpdateForState(new Guid(id), 4); IM_NewsInfo newModel = new IM_NewsBLL().GetModel(new Guid(id)); IM_GroupMemberBLL groupMemberBLL = new IM_GroupMemberBLL(); //当前用户添加对方 IM_GroupMemberInfo groupMemberModel = new IM_GroupMemberInfo(); groupMemberModel.ID = Guid.NewGuid(); groupMemberModel.GroupID = new Guid(newModel.BusinessID); groupMemberModel.UserID = newModel.BusinessType == 3 ? newModel.SendUserID : newModel.ReceiveUserID;//3为申请加入,所以添加发送方 groupMemberBLL.Add(groupMemberModel); btnOK.Enabled = btnReject.Enabled = false; IM_GroupInfo groupModel = new IM_GroupBLL().GetModel(groupMemberModel.GroupID); ClientScript.RegisterStartupScript(this.GetType(), "JS", "<script>window.onload = function () {window.parent.window.addGroup('" + groupMemberModel.GroupID + "','" + groupModel.GroupName + "');};</script>"); }
/// <summary> /// 得到一个对象实体 /// <param name="ID">ID</param> /// </summary> public IM_GroupMemberInfo GetModel(Guid ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,GroupID,UserID,OrderIndex from IM_GroupMember "); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.UniqueIdentifier, 16) }; parameters[0].Value = ID; IM_GroupMemberInfo model = new IM_GroupMemberInfo(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(IM_GroupMemberInfo model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// <param name="model">实体</param> /// </summary> public bool Add(IM_GroupMemberInfo model) { return(dal.Add(model)); }