public List <string> GetDrwingsList() { var strSql = "SELECT filepath FROM history"; DataSet ds = MysqlDBUtil.Query(strSql); List <string> _list = new List <string>(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { _list.Add(ds.Tables[0].Rows[i][0].ToString()); } return(_list); }
static string getByNewCode(string oldCode) { string sql = "select newcode from code where oldcode='" + oldCode + "'"; DataSet dataSet = MysqlDBUtil.Query(sql); if (dataSet.Tables.Count > 0) { if (dataSet.Tables[0].Rows.Count > 0) { DataRow row = dataSet.Tables[0].Rows[0]; return(row["newcode"].ToString()); } } return(""); }
public HistoryDto GetDrwingsDto(string filename) { HistoryDto dto = new HistoryDto(); var strSql = "SELECT * FROM history WHERE filename='" + filename + "'"; DataSet ds = MysqlDBUtil.Query(strSql); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { dto.Id = ds.Tables[0].Rows[i]["id"].ToString(); dto.FileName = ds.Tables[0].Rows[i]["filename"].ToString(); dto.FilePath = ds.Tables[0].Rows[i]["filepath"].ToString(); dto.FileStatus = ds.Tables[0].Rows[i]["id"].ToString(); return(dto); } return(null); }