/// <summary> /// 增加一条数据 /// <param name="model">实体</param> /// </summary> public bool Add(IM_TalkInfo model) { StringBuilder strSql = new StringBuilder(); int n = 0; strSql.Append("insert into IM_Talk("); strSql.Append("SendUserID,ReceiveUserID,Note,Type,State)"); strSql.Append(" values ("); strSql.Append("@SendUserID,@ReceiveUserID,@Note,@Type,@State)"); SqlParameter[] parameters = { new SqlParameter("@SendUserID", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@ReceiveUserID", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@Note", SqlDbType.NVarChar), new SqlParameter("@Type", SqlDbType.Int, 4), new SqlParameter("@State", SqlDbType.Int, 4) }; parameters[n++].Value = model.SendUserID; parameters[n++].Value = model.ReceiveUserID; parameters[n++].Value = model.Note; parameters[n++].Value = model.Type; parameters[n++].Value = model.State; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// <param name="model">实体</param> /// </summary> public bool Update(IM_TalkInfo model) { StringBuilder strSql = new StringBuilder(); int n = 0; strSql.Append("update IM_Talk set "); strSql.Append("SendUserID=@SendUserID,"); strSql.Append("ReceiveUserID=@ReceiveUserID,"); strSql.Append("Note=@Note,"); strSql.Append("Type=@Type,"); strSql.Append("State=@State,"); strSql.Append("CreateDate=@CreateDate"); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@SendUserID", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@ReceiveUserID", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@Note", SqlDbType.NVarChar), new SqlParameter("@Type", SqlDbType.Int, 4), new SqlParameter("@State", SqlDbType.Int, 4), new SqlParameter("@CreateDate", SqlDbType.DateTime), new SqlParameter("@ID", SqlDbType.UniqueIdentifier, 16) }; parameters[n++].Value = model.SendUserID; parameters[n++].Value = model.ReceiveUserID; parameters[n++].Value = model.Note; parameters[n++].Value = model.Type; parameters[n++].Value = model.State; parameters[n++].Value = model.CreateDate; parameters[n++].Value = model.ID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public string sendUserTalk(string SendUserID, string ReceiveUserID, string Type, string Note) { switch (Type) { case "1": IM_TalkInfo talkModel = new IM_TalkInfo(); talkModel.SendUserID = new Guid(SendUserID); talkModel.ReceiveUserID = new Guid(ReceiveUserID); talkModel.Note = Note; talkModel.Type = 0; talkModel.State = 0; new IM_TalkBLL().Add(talkModel); return(DateTime.Now.ToString("yyyy-MM-dd HH:mm")); case "2": //ReceiveUserID为GroupID IM_TalkGroupInfo talkGroupModel = new IM_TalkGroupInfo(); talkGroupModel.ID = Guid.NewGuid(); talkGroupModel.SendUserID = new Guid(SendUserID); talkGroupModel.GroupID = new Guid(ReceiveUserID); talkGroupModel.Note = Note; talkGroupModel.Type = 0; new IM_TalkGroupBLL().Add(talkGroupModel); QueryBuilder queryBuilder = new QueryBuilder(); queryBuilder.AddFilter(IM_GroupMemberInfo.GroupID_Field, "=", ReceiveUserID); List <IM_GroupMemberInfo> groupMemberList = new IM_GroupMemberBLL().GetList(queryBuilder); IM_TalkGroupHintBLL talkGroupHintBLL = new IM_TalkGroupHintBLL(); foreach (IM_GroupMemberInfo tmpModel in groupMemberList) { IM_TalkGroupHintInfo talkGroupHintModel = new IM_TalkGroupHintInfo(); talkGroupHintModel.ID = Guid.NewGuid(); talkGroupHintModel.TalkGroupID = talkGroupModel.ID; talkGroupHintModel.GroupID = talkGroupModel.GroupID; talkGroupHintModel.UserID = tmpModel.UserID; talkGroupHintModel.State = 0; talkGroupHintBLL.Add(talkGroupHintModel); } return(DateTime.Now.ToString()); } return(""); }
/// <summary> /// 得到一个对象实体 /// </summary> public IM_TalkInfo DataRowToModel(DataRow row) { IM_TalkInfo model = new IM_TalkInfo(); if (row != null) { if (row["ID"] != null && row["ID"].ToString() != "") { model.ID = new Guid(row["ID"].ToString()); } if (row["SendUserID"] != null && row["SendUserID"].ToString() != "") { model.SendUserID = new Guid(row["SendUserID"].ToString()); } if (row["ReceiveUserID"] != null && row["ReceiveUserID"].ToString() != "") { model.ReceiveUserID = new Guid(row["ReceiveUserID"].ToString()); } if (row["Note"] != null) { model.Note = row["Note"].ToString(); } if (row["Type"] != null && row["Type"].ToString() != "") { model.Type = int.Parse(row["Type"].ToString()); } if (row["State"] != null && row["State"].ToString() != "") { model.State = int.Parse(row["State"].ToString()); } if (row["CreateDate"] != null && row["CreateDate"].ToString() != "") { model.CreateDate = DateTime.Parse(row["CreateDate"].ToString()); } } return(model); }
/// <summary> /// 得到一个对象实体 /// <param name="ID">ID</param> /// </summary> public IM_TalkInfo GetModel(Guid ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,SendUserID,ReceiveUserID,Note,Type,State,CreateDate from IM_Talk "); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.UniqueIdentifier, 16) }; parameters[0].Value = ID; IM_TalkInfo model = new IM_TalkInfo(); 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="sendUserID">sendUserID</param> /// <param name="receiveUserID">receiveUserID</param> /// <param name="state">state</param> /// </summary> public List <IM_TalkInfo> GetList(Guid sendUserID, Guid receiveUserID, int state) { StringBuilder strSql = new StringBuilder(); strSql.Append(@" select [IM_Talk].*,UserName as SendUserName from [dbo].[IM_Talk] inner join [dbo].[IM_User] on [IM_Talk].[SendUserID]=[IM_User].ID where [ReceiveUserID]=@ReceiveUserID and SendUserID=@SendUserID and State=@State "); SqlParameter[] parameters = { new SqlParameter("@SendUserID", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@ReceiveUserID", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@State", SqlDbType.Int, 4) }; parameters[0].Value = sendUserID; parameters[1].Value = receiveUserID; parameters[2].Value = state; DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); List <IM_TalkInfo> list = new List <IM_TalkInfo>(); foreach (DataRow row in ds.Tables[0].Rows) { IM_TalkInfo model = new IM_TalkInfo(); if (row != null) { if (row["ID"] != null && row["ID"].ToString() != "") { model.ID = new Guid(row["ID"].ToString()); } if (row["SendUserID"] != null && row["SendUserID"].ToString() != "") { model.SendUserID = new Guid(row["SendUserID"].ToString()); } if (row["ReceiveUserID"] != null && row["ReceiveUserID"].ToString() != "") { model.ReceiveUserID = new Guid(row["ReceiveUserID"].ToString()); } if (row["Note"] != null) { model.Note = row["Note"].ToString(); } if (row["Type"] != null && row["Type"].ToString() != "") { model.Type = int.Parse(row["Type"].ToString()); } if (row["State"] != null && row["State"].ToString() != "") { model.State = int.Parse(row["State"].ToString()); } if (row["CreateDate"] != null && row["CreateDate"].ToString() != "") { model.CreateDate = DateTime.Parse(row["CreateDate"].ToString()); } if (row["SendUserName"] != null && row["SendUserName"].ToString() != "") { model.SendUserName = row["SendUserName"].ToString(); } //if (row["ReceiveUserName"] != null && row["ReceiveUserName"].ToString() != "") //{ // model.ReceiveUserName = row["ReceiveUserName"].ToString(); //} } list.Add(model); } return(list); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(IM_TalkInfo model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// <param name="model">实体</param> /// </summary> public bool Add(IM_TalkInfo model) { return(dal.Add(model)); }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; context.Response.Charset = "utf-8"; HttpPostedFile file = context.Request.Files["Filedata"]; string uploadPath = context.Server.MapPath("~/UpLoadFiles/Files/"); string ReceiveID = context.Request["ReceiveID"].Replace("'", ""); string UserID = context.Request["UserID"].Replace("'", ""); string Type = context.Request["Type"].Replace("'", ""); string FileName = ""; string FileType = ""; if (file != null) { FileID = Guid.NewGuid().ToString(); FileType = file.FileName.Substring(file.FileName.LastIndexOf('.') + 1).ToLower(); FileName = file.FileName.Substring(0, file.FileName.LastIndexOf('.')); if (!Directory.Exists(uploadPath)) { Directory.CreateDirectory(uploadPath); } uploadPath += FileID + "." + FileType; file.SaveAs(uploadPath); FileName += "." + FileType; IM_FileInfo fileModel = new IM_FileInfo(); fileModel.ID = Guid.NewGuid(); fileModel.FileName = FileName; fileModel.FilePath = "/UpLoadFiles/Files/" + FileID + "." + FileType; fileModel.UserID = new Guid(UserID); fileModel.ReceiveID = new Guid(ReceiveID); fileModel.Type = 1; fileModel.CreateDate = DateTime.Now; new IM_FileBLL().Add(fileModel); string Note = "<a href=\"" + fileModel.FilePath + "\" target=\"_blank\">" + fileModel.FileName + "</a>"; switch (Type) { case "1": IM_TalkInfo talkModel = new IM_TalkInfo(); talkModel.SendUserID = fileModel.UserID; talkModel.ReceiveUserID = fileModel.ReceiveID; talkModel.Note = Note; talkModel.Type = 1; talkModel.State = 0; new IM_TalkBLL().Add(talkModel); break; case "2": IM_TalkGroupInfo talkGroupModel = new IM_TalkGroupInfo(); talkGroupModel.ID = Guid.NewGuid(); talkGroupModel.SendUserID = fileModel.UserID; talkGroupModel.GroupID = fileModel.ReceiveID; talkGroupModel.Note = Note; talkGroupModel.Type = 1; new IM_TalkGroupBLL().Add(talkGroupModel); QueryBuilder queryBuilder = new QueryBuilder(); queryBuilder.AddFilter(IM_GroupMemberInfo.GroupID_Field, "=", fileModel.ReceiveID.ToString()); List <IM_GroupMemberInfo> groupMemberList = new IM_GroupMemberBLL().GetList(queryBuilder); IM_TalkGroupHintBLL talkGroupHintBLL = new IM_TalkGroupHintBLL(); foreach (IM_GroupMemberInfo tmpModel in groupMemberList) { IM_TalkGroupHintInfo talkGroupHintModel = new IM_TalkGroupHintInfo(); talkGroupHintModel.ID = Guid.NewGuid(); talkGroupHintModel.TalkGroupID = talkGroupModel.ID; talkGroupHintModel.GroupID = talkGroupModel.GroupID; talkGroupHintModel.UserID = tmpModel.UserID; talkGroupHintModel.State = 0; talkGroupHintBLL.Add(talkGroupHintModel); } break; } } context.Response.Write(ReceiveID + "|" + FileName + "|" + "/UpLoadFiles/Files/" + FileID + "." + FileType + "|" + DateTime.Now); }