/// <summary> /// 更新一条数据 /// <param name="model">实体</param> /// </summary> public bool Update(IM_FileInfo model) { StringBuilder strSql = new StringBuilder(); int n = 0; strSql.Append("update IM_File set "); strSql.Append("FileName=@FileName,"); strSql.Append("FilePath=@FilePath,"); strSql.Append("UserID=@UserID,"); strSql.Append("ReceiveID=@ReceiveID,"); strSql.Append("Type=@Type,"); strSql.Append("CreateDate=@CreateDate"); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@FileName", SqlDbType.NVarChar), new SqlParameter("@FilePath", SqlDbType.VarChar, 100), new SqlParameter("@UserID", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@ReceiveID", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@Type", SqlDbType.Int, 4), new SqlParameter("@CreateDate", SqlDbType.DateTime), new SqlParameter("@ID", SqlDbType.UniqueIdentifier, 16) }; parameters[n++].Value = model.FileName; parameters[n++].Value = model.FilePath; parameters[n++].Value = model.UserID; parameters[n++].Value = model.ReceiveID; parameters[n++].Value = model.Type; 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); } }
/// <summary> /// 增加一条数据 /// <param name="model">实体</param> /// </summary> public bool Add(IM_FileInfo model) { StringBuilder strSql = new StringBuilder(); int n = 0; strSql.Append("insert into IM_File("); strSql.Append("ID,FileName,FilePath,UserID,ReceiveID,Type,CreateDate)"); strSql.Append(" values ("); strSql.Append("@ID,@FileName,@FilePath,@UserID,@ReceiveID,@Type,@CreateDate)"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@FileName", SqlDbType.NVarChar), new SqlParameter("@FilePath", SqlDbType.VarChar, 100), new SqlParameter("@UserID", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@ReceiveID", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@Type", SqlDbType.Int, 4), new SqlParameter("@CreateDate", SqlDbType.DateTime) }; parameters[n++].Value = model.ID; parameters[n++].Value = model.FileName; parameters[n++].Value = model.FilePath; parameters[n++].Value = model.UserID; parameters[n++].Value = model.ReceiveID; parameters[n++].Value = model.Type; parameters[n++].Value = model.CreateDate; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public IM_FileInfo DataRowToModel(DataRow row) { IM_FileInfo model = new IM_FileInfo(); if (row != null) { if (row["ID"] != null && row["ID"].ToString() != "") { model.ID = new Guid(row["ID"].ToString()); } if (row["FileName"] != null) { model.FileName = row["FileName"].ToString(); } if (row["FilePath"] != null) { model.FilePath = row["FilePath"].ToString(); } if (row["UserID"] != null && row["UserID"].ToString() != "") { model.UserID = new Guid(row["UserID"].ToString()); } if (row["ReceiveID"] != null && row["ReceiveID"].ToString() != "") { model.ReceiveID = new Guid(row["ReceiveID"].ToString()); } if (row["Type"] != null && row["Type"].ToString() != "") { model.Type = int.Parse(row["Type"].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_FileInfo GetModel(Guid ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,FileName,FilePath,UserID,ReceiveID,Type,CreateDate from IM_File "); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.UniqueIdentifier, 16) }; parameters[0].Value = ID; IM_FileInfo model = new IM_FileInfo(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
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); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(IM_FileInfo model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// <param name="model">实体</param> /// </summary> public bool Add(IM_FileInfo model) { return(dal.Add(model)); }