| | |
| | | $.ajax({ |
| | | url: GetWEBURL() + 'EquipMentCollectionTemp/list', |
| | | type: "GET", |
| | | data: { "sWhere": sWhere , "user": sessionStorage["HUserName"]}, |
| | | async: false, |
| | | data: { "sWhere": sWhere, "user": sessionStorage["HUserName"] }, |
| | | success: function (data1) { |
| | | if (data1.count == 1) { |
| | | var data = []; |
| | |
| | | //å¿«éè¿æ»¤ |
| | | function get_FastQuery(table, option,number) { |
| | | var HSourceCode = $("#HSourceCode").val();//设å¤ç¼ç |
| | | var HTechParamName = $("#HTechParamName").val();//ç»ææ¥æ |
| | | var HBeginDate = $("#HBeginDate").val(); //å¼å§æ¥æ |
| | | var HEndDate = $("#HEndDate").val(); //ç»ææ¥æ |
| | | var HTechParamName = $("#HTechParamName").val(); //å·¥èºåæ°åç§° |
| | | //ä»»æåæ®µè¿æ»¤ |
| | | var ColName = $("#ColName").val();//å¤éæ¡ |
| | | var Comparator = $("#Comparator").val() |
| | |
| | | if (HTechParamName) { |
| | | sWhere += " and å·¥èºåæ°åç§° like '%" + HTechParamName + "%'"; |
| | | } |
| | | |
| | | if (HBeginDate) { |
| | | sWhere += " and CONVERT(varchar(100),æ¥æ, 23) >= '" + HBeginDate + "'"; |
| | | } |
| | | if (HEndDate) { |
| | | sWhere += " and CONVERT(varchar(100),æ¥æ, 23) <= '" + HEndDate + "'"; |
| | | } |
| | | sWhere += addSWhereByOpenType(); |
| | | //æ·»å æ¥è¯¢æ¡ä»¶ï¼æ ¹æ®å½åç»å½ç¨æ·å
³èèåè¿åæ°æ® |
| | | //sWhere += " and HUserID =" + sessionStorage["Czybm"] |
| | |
| | | function set_ClearQuery() { |
| | | $("#HSourceCode").val(""); |
| | | $("#HTechParamName ").val(""); |
| | | $("#HBeginDate").val(""); |
| | | $("#HEndDate").val(""); |
| | | $("#ColContent").val(""); |
| | | $("#ColName").val("0"); |
| | | $("#Comparator").val("0"); |