| | |
| | | var ajaxLoad = layer.load(); |
| | | //è¿å
¥é¡µé¢æ¾ç¤ºçç¼åå表 |
| | | $.ajax({ |
| | | url: GetWEBURL() + '/Sc_MouldRepairInBillList/Get_Sc_MouldLifeUsePicReport', |
| | | url: GetWEBURL() + '/Sc_MouldRepairInBillList/Get_Sc_MouldLifeUsePicReport_list', |
| | | type: "GET", |
| | | async:false, |
| | | data: { "sWhere": sWhere, "user": sessionStorage["HUserName"] }, |
| | |
| | | } |
| | | //å¨å表左边添å å¾éæ¡ |
| | | col.push({ type: 'checkbox', fixed: 'left' }); |
| | | for (var i = 0; i < data.length; i++) { |
| | | // if (data[i].name == 'HInterID' || data[i].name == 'HBillType' || data[i].name == 'hmainid') { |
| | | for (var i = 0; i < data.length; i++) { |
| | | if ($.inArray(data[i].name, titleData) > -1) { |
| | | col.push({ field: data[i].id, title: data[i].name, align: 'center', hide: true }); //éèidå |
| | | } |
| | |
| | | var HMouldNo = $("#HMouldNo").val(); |
| | | var HName = $("#HName").val(); |
| | | |
| | | if (HBeginDate) { |
| | | sWhere += " and CONVERT(varchar(7),æ¥æ, 23) >= '" + HBeginDate + "'"; |
| | | sWhere = { |
| | | HBeginDate: HBeginDate |
| | | , HEndDate: HEndDate |
| | | , HMouldNo: HMouldNo |
| | | , HName: HName |
| | | } |
| | | if (HEndDate) { |
| | | sWhere += " and CONVERT(varchar(7),æ¥æ, 23) <= '" + HEndDate + "'"; |
| | | } |
| | | |
| | | if (HMouldNo != "" || HName != "") { |
| | | if (HMouldNo) { |
| | | sWhere += " and 模å
·ç¼å· like '%" + HMouldNo + "%'"; |
| | | } |
| | | if (HName) { |
| | | sWhere += " and 模å
·åç§° like '%" + HName + "%'"; |
| | | } |
| | | get_Display(sWhere); |
| | | get_Display(JSON.stringify(sWhere)); |
| | | //å è½½æ±ç¶å¾ |
| | | set_Graphics(); |
| | | } else { |
| | | if (HMouldNo) { |
| | | sWhere += " and 模å
·ç¼å· like '%" + HMouldNo + "%'"; |
| | | } |
| | | if (HName) { |
| | | sWhere += " and 模å
·åç§° like '%" + HName + "%'"; |
| | | } |
| | | get_Display(sWhere); |
| | | } |
| | | |
| | | |
| | | get_Display(JSON.stringify(sWhere)); |
| | | } |
| | | sWhere = "";//è°ç¨æ¥å£åæ¸
空sWhereç¼å |
| | | |
| | | } |
| | | //éç½®å¿«éæ¥è¯¢ |
| | | function set_ClearQuery() { |
| | | $("#HBeginDate").val(Format(new Date(new Date().setMonth(new Date().getMonth() - 3)), "yyyy-MM-dd")); |
| | | $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd")); //ç»ææ¥æ |
| | | |
| | | $("#HMouldNo").val(""); |
| | | $("#HName").val(""); |
| | | $("#btnSearch").click(); |
| | | form.render('select'); |
| | | |