/// <summary> /// 获取未添加用户 /// <param name="UserID"></param> /// <param name="GroupID"></param> /// </summary> public List <IM_UserInfo> GetListForNoAddGroup(Guid userID, Guid groupID) { StringBuilder strSql = new StringBuilder(); strSql.Append(@" select [IM_User].ID,[IM_User].UserName from [dbo].[IM_Team] inner join [dbo].[IM_TeamMember] on [IM_Team].ID=[IM_TeamMember].[TeamID] inner join [dbo].[IM_User] on [IM_TeamMember].[UserID]=[IM_User].ID where [IM_Team].UserID=@UserID and [IM_TeamMember].UserID not in (select [IM_GroupMember].UserID from [dbo].[IM_Group] left join [dbo].[IM_GroupMember] on [IM_Group].ID=[IM_GroupMember].[GroupID] where [IM_Group].[UserID]=@UserID and [IM_Group].ID=@GroupID) "); 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_UserInfo> list = new List <IM_UserInfo>(); foreach (DataRow row in ds.Tables[0].Rows) { IM_UserInfo model = new IM_UserInfo(); if (row != null) { if (row["ID"] != null && row["ID"].ToString() != "") { model.ID = new Guid(row["ID"].ToString()); } if (row["UserName"] != null) { model.UserName = row["UserName"].ToString(); } } list.Add(model); } return(list); }
/// <summary> /// 更新一条数据 /// <param name="model">实体</param> /// </summary> public bool Update(IM_UserInfo model) { StringBuilder strSql = new StringBuilder(); int n = 0; strSql.Append("update IM_User set "); strSql.Append("Sys_UserID=@Sys_UserID,"); strSql.Append("UserName=@UserName,"); strSql.Append("Pic=@Pic,"); strSql.Append("LoginDate=@LoginDate,"); strSql.Append("LastDate=@LastDate,"); strSql.Append("IsDelete=@IsDelete"); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@Sys_UserID", SqlDbType.VarChar, 50), new SqlParameter("@UserName", SqlDbType.NVarChar, 50), new SqlParameter("@Pic", SqlDbType.VarChar, 50), new SqlParameter("@LoginDate", SqlDbType.DateTime), new SqlParameter("@LastDate", SqlDbType.DateTime), new SqlParameter("@IsDelete", SqlDbType.Int, 4), new SqlParameter("@ID", SqlDbType.UniqueIdentifier, 16) }; parameters[n++].Value = model.Sys_UserID; parameters[n++].Value = model.UserName; parameters[n++].Value = model.Pic; parameters[n++].Value = model.LoginDate; parameters[n++].Value = model.LastDate; parameters[n++].Value = model.IsDelete; parameters[n++].Value = model.ID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
protected void txtInit_Click(object sender, EventArgs e) { IM_UserInfo userModel = new IM_UserInfo(); userModel.ID = Guid.NewGuid(); userModel.IsDelete = 0; userModel.UserName = txtUserName.Text; IM_TeamInfo teamModel = new IM_TeamInfo(); teamModel.ID = Guid.NewGuid(); teamModel.TeamName = "好友"; teamModel.UserID = userModel.ID; teamModel.CreateDate = DateTime.Now; new IM_UserBLL().Add(userModel); new IM_TeamBLL().Add(teamModel); lblResult.Text = "OK"; DataBind(); }
/// <summary> /// 增加一条数据 /// <param name="model">实体</param> /// </summary> public bool Add(IM_UserInfo model) { StringBuilder strSql = new StringBuilder(); int n = 0; strSql.Append("insert into IM_User("); strSql.Append("ID,Sys_UserID,UserName,Pic,LoginDate,LastDate,IsDelete)"); strSql.Append(" values ("); strSql.Append("@ID,@Sys_UserID,@UserName,@Pic,@LoginDate,@LastDate,@IsDelete)"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@Sys_UserID", SqlDbType.VarChar, 50), new SqlParameter("@UserName", SqlDbType.NVarChar, 50), new SqlParameter("@Pic", SqlDbType.VarChar, 50), new SqlParameter("@LoginDate", SqlDbType.DateTime), new SqlParameter("@LastDate", SqlDbType.DateTime), new SqlParameter("@IsDelete", SqlDbType.Int, 4) }; parameters[n++].Value = model.ID; parameters[n++].Value = model.Sys_UserID; parameters[n++].Value = model.UserName; parameters[n++].Value = model.Pic; parameters[n++].Value = model.LoginDate; parameters[n++].Value = model.LastDate; parameters[n++].Value = model.IsDelete; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public IM_UserInfo DataRowToModel(DataRow row) { IM_UserInfo model = new IM_UserInfo(); if (row != null) { if (row["ID"] != null && row["ID"].ToString() != "") { model.ID = new Guid(row["ID"].ToString()); } if (row["Sys_UserID"] != null) { model.Sys_UserID = row["Sys_UserID"].ToString(); } if (row["UserName"] != null) { model.UserName = row["UserName"].ToString(); } if (row["Pic"] != null) { model.Pic = row["Pic"].ToString(); } if (row["LoginDate"] != null && row["LoginDate"].ToString() != "") { model.LoginDate = DateTime.Parse(row["LoginDate"].ToString()); } if (row["LastDate"] != null && row["LastDate"].ToString() != "") { model.LastDate = DateTime.Parse(row["LastDate"].ToString()); } if (row["IsDelete"] != null && row["IsDelete"].ToString() != "") { model.IsDelete = int.Parse(row["IsDelete"].ToString()); } } return(model); }
/// <summary> /// 得到一个对象实体 /// <param name="ID">ID</param> /// </summary> public IM_UserInfo GetModel(string sys_UserID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,Sys_UserID,UserName,Pic,LoginDate,LastDate,IsDelete from IM_User "); strSql.Append(" where Sys_UserID=@Sys_UserID "); SqlParameter[] parameters = { new SqlParameter("@Sys_UserID", SqlDbType.VarChar, 50) }; parameters[0].Value = sys_UserID; IM_UserInfo model = new IM_UserInfo(); 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> /// 获取所有组中成员 /// <param name="UserID"></param> /// </summary> public List <IM_UserInfo> GetAllTeamMemberList(Guid userID) { StringBuilder strSql = new StringBuilder(); strSql.Append(@"select [IM_User].*,TeamID,TeamName from [dbo].[IM_TeamMember] inner join [dbo].[IM_Team] on [IM_TeamMember].TeamID=[IM_Team].ID inner join [dbo].[IM_User] on [IM_TeamMember].UserID=[IM_User].ID where [IM_Team].UserID=@UserID order by [IM_User].UserName asc"); SqlParameter[] parameters = { new SqlParameter("@UserID", SqlDbType.UniqueIdentifier, 16) }; parameters[0].Value = userID; DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); List <IM_UserInfo> list = new List <IM_UserInfo>(); foreach (DataRow row in ds.Tables[0].Rows) { IM_UserInfo model = new IM_UserInfo(); if (row != null) { if (row["ID"] != null && row["ID"].ToString() != "") { model.ID = new Guid(row["ID"].ToString()); } if (row["Sys_UserID"] != null) { model.Sys_UserID = row["Sys_UserID"].ToString(); } if (row["UserName"] != null) { model.UserName = row["UserName"].ToString(); } if (row["Pic"] != null) { model.Pic = row["Pic"].ToString(); } if (row["LoginDate"] != null && row["LoginDate"].ToString() != "") { model.LoginDate = DateTime.Parse(row["LoginDate"].ToString()); } if (row["LastDate"] != null && row["LastDate"].ToString() != "") { model.LastDate = DateTime.Parse(row["LastDate"].ToString()); } if (row["IsDelete"] != null && row["IsDelete"].ToString() != "") { model.IsDelete = int.Parse(row["IsDelete"].ToString()); } if (row["TeamID"] != null && row["TeamID"].ToString() != "") { model.TeamID = new Guid(row["TeamID"].ToString()); } if (row["TeamName"] != null) { model.TeamName = row["TeamName"].ToString(); } list.Add(model); } } return(list); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(IM_UserInfo model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// <param name="model">实体</param> /// </summary> public bool Add(IM_UserInfo model) { return(dal.Add(model)); }