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))));
}