| | |
| | | |
| | | //#region æ¤é¡µé¢æææ¹æ³ |
| | | function set_ClearBill() { |
| | | //åå§åæ¥æ |
| | | $("#BenginHCreateDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd"));//å¼å§æ¥æ |
| | | $("#EndHCreateDate").val(Format(new Date(), "yyyy-MM-dd"));//ç»ææ¥æ |
| | | //åå§åè¡¨æ ¼(主表) |
| | | set_InitGrid(); |
| | | //åå§åè¡¨æ ¼(å表1) |
| | |
| | | , { field: 'HUnitID', title: 'åä½ID', width: 200, hide: true } |
| | | , { field: 'HUnitNumber', title: 'åä½ä»£ç ', width: 200 } |
| | | , { field: 'HUnitName', title: 'åä½åç§°', width: 200 } |
| | | , { field: 'HManagerID', title: 'è´è´£äººID', width: 200, hide: true } |
| | | , { field: 'HManagerNumber', title: 'è´è´£äººä»£ç ', width: 200 } |
| | | , { field: 'HManagerName', title: 'è´è´£äºº', width: 200 } |
| | | //, { field: 'HManagerID', title: 'è´è´£äººID', width: 200, hide: true } |
| | | //, { field: 'HManagerNumber', title: 'è´è´£äººä»£ç ', width: 200 } |
| | | //, { field: 'HManagerName', title: 'è´è´£äºº', width: 200 } |
| | | , { field: 'HQty', title: 'å®é
ç¨é', width: 200 } |
| | | , { field: 'HQtyMust', title: 'æ åç¨é', width: 200 } |
| | | , { field: 'HRemark', title: '夿³¨', width: 200 } |
| | |
| | | sWhere += " and CONVERT(varchar(100),æ¥æ, 23) >= '" + BenginHCreateDate + "'"; |
| | | } |
| | | if (EndHCreateDate) { |
| | | sWhere += " and CONVERT(varchar(100),æ¥æ, 23) >= '" + EndHCreateDate + "'"; |
| | | sWhere += " and CONVERT(varchar(100),æ¥æ, 23) <= '" + EndHCreateDate + "'"; |
| | | } |
| | | get_Display(sWhere); |
| | | sWhere = "";//è°ç¨æ¥å£åæ¸
空sWhereç¼å |
| | |
| | | $("#HBillNo").val("");//åæ®å· |
| | | $("#HSourceBillNo").val("");//æºåå· |
| | | $("#HCreateBy").val("");//å¶å人 |
| | | $("#BenginHCreateDate").val("");//å¼å§å¶åæ¶é´ |
| | | $("#EndHCreateDate").val("");//ç»æå¶åæ¶é´ |
| | | $("#BenginHCreateDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd"));//å¼å§æ¥æ |
| | | $("#EndHCreateDate").val(Format(new Date(), "yyyy-MM-dd"));//ç»ææ¥æ |
| | | $("#ColContent").val(""); |
| | | $("#ColName").val("0"); |
| | | $("#Comparator").val("0"); |