public List <Record> selectListByAll(string id, string seriesNum, string operatorName, DateTime startTime, DateTime endTime) { string query_string = "SELECT * from `t_record` where isDel=0"; if (id != "") { query_string = query_string + " and id='" + id + "'"; } if (operatorName != "") { query_string = query_string + " and operator='" + operatorName + "'"; } if (seriesNum != "") { query_string = query_string + " and seriesNum='" + seriesNum + "'"; } if (startTime.Year != 1) { query_string = query_string + " and createTime>='" + startTime.ToString("yyyy-MM-dd HH:mm:ss") + "'"; } if (endTime.Year != 1) { query_string = query_string + " and createTime<='" + endTime.ToString("yyyy-MM-dd HH:mm:ss") + "'"; } DataTable dt = MysqlTool.queryData(query_string, new MySqlParameter[] { new MySqlParameter() }); List <Record> ls = MysqlTool.toList <Record>(dt); return(ls.Count > 0 ? ls : null); }
public List <RecordDetail> selectListByRecordId(string recordId) { string query_string = "SELECT * from `t_record_detail` where recordId=@recordId and isDel=0 order by `index`"; DataTable dt = MysqlTool.queryData(query_string, new MySqlParameter[] { new MySqlParameter("@recordId", recordId) }); List <RecordDetail> ls = MysqlTool.toList <RecordDetail>(dt); return(ls.Count > 0 ? ls : null); }