public DataSet getFaultInfos(DateTime starDateTime, DateTime endDateTime, string unitName, string responsibleUserName, string serviceStyle) { ArrayList paraList = new ArrayList(); MySqlParameter paraStartTime = new MySqlParameter("@paraStartTime", starDateTime); MySqlParameter paraEndTime = new MySqlParameter("@paraEndTime", endDateTime); MySqlParameter paraUnitName = new MySqlParameter("@paraUnitName", unitName); MySqlParameter paraResponsibleUserName = new MySqlParameter("@paraResponsibleUserName", responsibleUserName); MySqlParameter paraServiceStyle = new MySqlParameter("@paraServiceStyle", serviceStyle); paraList.Add(paraStartTime); paraList.Add(paraEndTime); string sql = "SELECT a.`equip_name`,a.`equip_version`,a.`falut_info`,a.`maintenance_mode`,a.`spare_part_name`,a.`spare_part_version`,a.`spare_part_specification`,a.`spare_part_count`,a.`service_id`,b.`start_date`,b.`end_date` FROM `falut_infos` a,`services` b WHERE b.`start_date` > @paraStartTime and b.`end_date` < @paraEndTime and a.service_id = b.id"; if (unitName != "全部" && unitName != "请选择单位") { sql += "and b.unit_name = @paraUnitName "; paraList.Add(paraUnitName); } if (responsibleUserName != "全部" && responsibleUserName != "请选择带队人") { sql += "and b.responsible_user_name = @paraResponsibleUserName "; paraList.Add(paraResponsibleUserName); } if (serviceStyle != "全部" && serviceStyle != "请选择服务类型") { sql += "and b.service_style = @paraServiceStyle"; paraList.Add(paraServiceStyle); } return(MySqlHelper.GetDataSet(MySqlHelper.conn, CommandType.Text, sql, (MySqlParameter[])paraList.ToArray(typeof(MySqlParameter)))); }
public DataSet getServiceInfos(DateTime starDateTime, DateTime endDateTime, string unitName, string responsibleUserName, string serviceStyle) { ArrayList paraList = new ArrayList(); MySqlParameter paraStartTime = new MySqlParameter("@paraStartTime", starDateTime); MySqlParameter paraEndTime = new MySqlParameter("@paraEndTime", endDateTime); MySqlParameter paraUnitName = new MySqlParameter("@paraUnitName", unitName); MySqlParameter paraResponsibleUserName = new MySqlParameter("@paraResponsibleUserName", responsibleUserName); MySqlParameter paraServiceStyle = new MySqlParameter("@paraServiceStyle", serviceStyle); paraList.Add(paraStartTime); paraList.Add(paraEndTime); string sql = "SELECT `info_name`,`receiver_name`,`work_order_number`,`unit_name`,`responsible_customer_name`,`responsible_customer_tel`,`responsible_user_name`,`start_date`,`end_date`,`user_names`,`service_style`,`return_money` FROM services where start_date > @paraStartTime and end_date < @paraEndTime "; if (unitName != "全部" && unitName != "请选择单位") { sql += "and unit_name = @paraUnitName "; paraList.Add(paraUnitName); } if (responsibleUserName != "全部" && responsibleUserName != "请选择带队人") { sql += "and responsible_user_name = @paraResponsibleUserName "; paraList.Add(paraResponsibleUserName); } if (serviceStyle != "全部" && serviceStyle != "请选择服务类型") { sql += "and service_style = @paraServiceStyle"; paraList.Add(paraServiceStyle); } return(MySqlHelper.GetDataSet(MySqlHelper.conn, CommandType.Text, sql, (MySqlParameter[])paraList.ToArray(typeof(MySqlParameter)))); }