public string SearchEquipment(string type, string value)
{
DEVICEATTACH_BN dev_bn = new DEVICEATTACH_BN();
JavaScriptSerializer js = new JavaScriptSerializer();
DEVICEATTACH model = js.Deserialize <DEVICEATTACH>(value);
if (type == "DEVICECODE")
{
return(dev_bn.GetMapEqipment(type + " = '" + model.DEVICECODE + "'"));
}
else
{
return(dev_bn.SearchEqipment(model));
}
}
public string SearchEqipment(DEVICEATTACH model)
{
StringBuilder strSql = new StringBuilder();
DbAPI dbHelper = new DbAPI();
OracleParameter[] parameters = null;
strSql.Append("select * ");
strSql.Append(" FROM DEVICEFULL WHERE 1=1 ");
if (model.SEAAREA != "全部")
{
strSql.Append(" AND SEAAREA = '" + model.SEAAREA + "'");
}
if (model.PROVINCE != "全部")
{
strSql.Append(" AND PROVINCE LIKE '%" + dbHelper.CheckDBNull(model.PROVINCE).ToString() + "%'");
}
if (model.BAY != "全部")
{
strSql.Append(" AND BAY = '" + model.BAY + "'");
}
if (model.BUREAUDEVICE != "全部")
{
strSql.Append(" AND BUREAUDEVICE ='" + model.BUREAUDEVICE + "'");
}
if (model.LOCALDEVICE != "全部")
{
strSql.Append(" AND LOCALDEVICE = '" + model.LOCALDEVICE + "'");
}
if (model.SERVICE != "全部")
{
strSql.Append(" AND SERVICE = '" + model.SERVICE + "'");
}
try
{
dbHelper.OpenConn("");
DataTable dt = new DataTable();
dt = dbHelper.GetDataTable(strSql.ToString(), parameters);
dbHelper.CloseConn();
string result = JsonConvert.SerializeObject(dt, new DataTableConverter());
return(result);
}
catch (Exception ex)
{
LogBN.WriteLog(typeof(DEVICEATTACH_BN), "SearchEqipment 程序段的异常" + ex);
return("");
}
}
