/// <summary> /// 增加一条数据 /// <param name="model">实体</param> /// </summary> public bool Add(IM_TalkGroupHintInfo model) { StringBuilder strSql = new StringBuilder(); int n = 0; strSql.Append("insert into IM_TalkGroupHint("); strSql.Append("ID,GroupID,TalkGroupID,UserID,State)"); strSql.Append(" values ("); strSql.Append("@ID,@GroupID,@TalkGroupID,@UserID,@State)"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@GroupID", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@TalkGroupID", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@UserID", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@State", SqlDbType.Int, 4) }; parameters[n++].Value = model.ID; parameters[n++].Value = model.GroupID; parameters[n++].Value = model.TalkGroupID; parameters[n++].Value = model.UserID; parameters[n++].Value = model.State; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public IM_TalkGroupHintInfo DataRowToModel(DataRow row) { IM_TalkGroupHintInfo model = new IM_TalkGroupHintInfo(); 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["TalkGroupID"] != null && row["TalkGroupID"].ToString() != "") { model.TalkGroupID = new Guid(row["TalkGroupID"].ToString()); } if (row["UserID"] != null && row["UserID"].ToString() != "") { model.UserID = new Guid(row["UserID"].ToString()); } if (row["State"] != null && row["State"].ToString() != "") { model.State = int.Parse(row["State"].ToString()); } } return(model); }
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> /// 更新一条数据 /// <param name="model">实体</param> /// </summary> public bool Update(IM_TalkGroupHintInfo model) { StringBuilder strSql = new StringBuilder(); int n = 0; strSql.Append("update IM_TalkGroupHint set "); strSql.Append("GroupID=@GroupID,"); strSql.Append("TalkGroupID=@TalkGroupID,"); strSql.Append("UserID=@UserID,"); strSql.Append("State=@State"); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@GroupID", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@TalkGroupID", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@UserID", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@State", SqlDbType.Int, 4), new SqlParameter("@ID", SqlDbType.UniqueIdentifier, 16) }; parameters[n++].Value = model.GroupID; parameters[n++].Value = model.TalkGroupID; parameters[n++].Value = model.UserID; parameters[n++].Value = model.State; parameters[n++].Value = model.ID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// <param name="ID">ID</param> /// </summary> public IM_TalkGroupHintInfo GetModel(Guid ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,GroupID,TalkGroupID,UserID,State from IM_TalkGroupHint "); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.UniqueIdentifier, 16) }; parameters[0].Value = ID; IM_TalkGroupHintInfo model = new IM_TalkGroupHintInfo(); 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_TalkGroupHintInfo model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// <param name="model">实体</param> /// </summary> public bool Add(IM_TalkGroupHintInfo 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); }