public R_FILE GetFileByName(string Name, string UseType, OleExec DB) { string strSql = $@"select r.id, r.name,r.filename,r.md5,r.usetype,r.valid,r.state,r.edit_time,r.edit_emp,blob_file from r_file r where r.name='{Name}' and r.usetype ='{UseType}' and r.valid = 1"; DataSet ret = DB.RunSelect(strSql); Row_R_FILE r = (Row_R_FILE)this.NewRow(); if (ret.Tables[0].Rows.Count > 0) { r.loadData(ret.Tables[0].Rows[0]); } //if (r.NAME != null) //{ // strSql = $@"select ID , clob_file , blob_file from r_file r where r.name='{Name}' and r.usetype ='{UseType}' and r.valid = 1"; // //System.Data.OleDb.OleDbParameter para = new System.Data.OleDb.OleDbParameter(":FILE", ""); // //para.Direction = ParameterDirection.Output; // //para.Size = 999999999; // ////para.DbType = DbType.Object; // //DB.ExecSqlNoReturn(strSql, new System.Data.OleDb.OleDbParameter[] { para }); // System.Data.OleDb.OleDbDataReader reader = DB.RunDataReader(strSql); // if (reader.Read()) // { // System.IO.TextReader TR = reader.GetTextReader(1); // r.CLOB_FILE = TR.ReadToEnd(); // } // reader.Close(); //} return(r.GetDataObject()); }
public R_FILE GetFileByFileName(string fileName, string UseType, OleExec DB) { string strSql = $@"select r.id, r.name,r.filename,r.md5,r.usetype,r.valid,r.state,r.edit_time,r.edit_emp,blob_file from r_file r where r.filename='{fileName}' and r.usetype ='{UseType}' and r.valid = 1"; DataSet ret = DB.RunSelect(strSql); Row_R_FILE r = (Row_R_FILE)this.NewRow(); if (ret.Tables[0].Rows.Count > 0) { r.loadData(ret.Tables[0].Rows[0]); } return(r.GetDataObject()); }
public List <R_FILE> GetFileList(string UseType, OleExec DB) { List <R_FILE> ret = new List <R_FILE>(); string strSql = $@"select r.id, r.name,r.filename,r.md5,r.usetype,r.valid,r.state,r.edit_time,r.edit_emp from r_file r where r.usetype ='{UseType}' and r.valid = 1"; DataSet res = DB.RunSelect(strSql); for (int i = 0; i < res.Tables[0].Rows.Count; i++) { Row_R_FILE RRF = (Row_R_FILE)NewRow(); RRF.loadData(res.Tables[0].Rows[i]); ret.Add(RRF.GetDataObject()); } return(ret); }