public static string select() { string sql = "select * from mg_DelJet_SEQNR "; DataTable table = SqlHelper.GetDataDataTable(SqlHelper.SqlConnString, CommandType.Text, sql, null); string result = JSONTools.DataTableToJSON(table); return(result); }
void st() //查询工位 { JavaScriptSerializer s = new JavaScriptSerializer(); HttpRequest request = HttpContext.Current.Request; string fl_id = request.Params["fl_id"]; string sql = "select distinct a.st_no,a.st_id from mg_station a LEFT JOIN View_mg_sys_log b ON a.st_no=b.st_no where a.fl_id='" + fl_id + "' and len(b.AngleResult) > 0 order by a.st_no"; DataTable ResTable = SqlHelper.GetDataDataTable(SqlHelper.SqlConnString, CommandType.Text, sql, null); if (ResTable == null) { string json = JSONTools.ObjectToJSON(""); Response.Write(json); Response.End(); } else { string json = JSONTools.DataTableToJSON(ResTable); Response.Write(json); Response.End(); } }
void fl() //查询流水线 { JavaScriptSerializer s = new JavaScriptSerializer(); HttpRequest request = HttpContext.Current.Request; string sql = "select fl_id, fl_name from dbo.mg_FlowLine order by fl_name"; DataTable ResTable3 = SqlHelper.GetDataDataTable(SqlHelper.SqlConnString, CommandType.Text, sql, null); //string json = FunCommon.DataTableToJson(ResTable1); if (ResTable3 == null) { string json = JSONTools.ObjectToJSON(""); Response.Write(json); Response.End(); } else { string json = JSONTools.DataTableToJSON(ResTable3); Response.Write(json); Response.End(); } }
void part() //查询部件号 { JavaScriptSerializer s = new JavaScriptSerializer(); HttpRequest request = HttpContext.Current.Request; string fl_id = request.Params["fl_id"]; string st_id = request.Params["st_id"]; string sql = "select distinct part_no from View_mg_sys_log where fl_id='" + fl_id + "' and st_id='" + st_id + "'"; DataTable ResTable = SqlHelper.GetDataDataTable(SqlHelper.SqlConnString, CommandType.Text, sql, null); if (ResTable == null) { string json = JSONTools.ObjectToJSON(""); Response.Write(json); Response.End(); } else { string json = JSONTools.DataTableToJSON(ResTable); Response.Write(json); Response.End(); } }