/// <summary> /// 得到一个对象实体 /// </summary> public FileContentModel GetSimpleModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 * from [" + databaseprefix + "DetailContent] "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; FileContentModel model = new FileContentModel(); DataSet ds = DbHelperFileContentSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { model = ChangeSimpleRowToFile(ds.Tables[0].Rows[0]); return(model); } else { return(null); } }
/// <summary> /// 是否存在该记录 /// </summary> public bool Exists(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select count(1) from " + databaseprefix + "DetailContent"); strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; return(DbHelperFileContentSQL.Exists(strSql.ToString(), parameters)); }
/// <summary> /// 系统检查 /// </summary> public static void SystemCheck() { // 获取配置信息 Model.SystemConfig config = SystemConfigBll.GetConfig(); // 设置数据库连接 string conn = string.Format("server={0};uid={1};pwd={2};database={3};", config.DbAddress, config.DbUser, config.DbPassword, config.DbName); DbHelperSQL.SetConnectionString(conn); string fileContentConn = string.Format("server={0};uid={1};pwd={2};database={3};", config.DbFileContentAddress, config.DbFileContentUser, config.DbFileContentPassword, config.DbFileContentName); DbHelperFileContentSQL.SetConnectionString(fileContentConn); }
/// <summary> /// 获取文件内容 /// </summary> /// <param name="id"></param> /// <returns></returns> public byte[] GetContent(string id) { id = "'" + id + "'"; StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 File_Content from [" + databaseprefix + "DetailContent] "); strSql.Append(" where id=" + id); DataSet ds = DbHelperFileContentSQL.Query(strSql.ToString()); if (ds.Tables[0].Rows.Count > 0) { return((byte[])ds.Tables[0].Rows[0]["File_Content"]); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public string Add(Model.FileContentModel model) { //文件内容的上传 StringBuilder strSql = new StringBuilder(); strSql.Append("insert into [" + databaseprefix + "DetailContent]("); strSql.Append("ID,File_ID,File_VerID,File_Ver,File_Content,Add_Time)"); strSql.Append(" values ("); strSql.Append("@ID,@File_ID,@File_VerID,@File_Ver,@File_Content,@Add_Time )"); //strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.NVarChar), new SqlParameter("@File_ID", SqlDbType.Int), new SqlParameter("@File_VerID", SqlDbType.Int), new SqlParameter("@File_Ver", SqlDbType.NVarChar,100), new SqlParameter("@File_Content", SqlDbType.VarBinary), new SqlParameter("@Add_Time", SqlDbType.DateTime), }; parameters[0].Value = model.ID; parameters[1].Value = model.File_ID; parameters[2].Value = model.File_VerID; parameters[3].Value = model.File_Ver; parameters[4].Value = model.File_Content; parameters[5].Value = model.Add_Time; int obj = DbHelperFileContentSQL.ExecuteSql(strSql.ToString(), parameters); if (obj == 0) { return(string.Empty); } else { return(model.ID); } }