From 7b31d00b64218b6f11e2fa92386e3d15ee332d3e Mon Sep 17 00:00:00 2001 From: yxj <1qaz@123> Date: 星期一, 16 五月 2022 15:51:49 +0800 Subject: [PATCH] Merge branch 'master' of http://101.37.171.70:10101/r/MES-WEB-API --- WorkM/流转卡管理/MES_StationEntrustOutBillList.cs | 17 +++++++++++++++++ 1 files changed, 17 insertions(+), 0 deletions(-) diff --git "a/WorkM/\346\265\201\350\275\254\345\215\241\347\256\241\347\220\206/MES_StationEntrustOutBillList.cs" "b/WorkM/\346\265\201\350\275\254\345\215\241\347\256\241\347\220\206/MES_StationEntrustOutBillList.cs" index 1216702..602f3a2 100644 --- "a/WorkM/\346\265\201\350\275\254\345\215\241\347\256\241\347\220\206/MES_StationEntrustOutBillList.cs" +++ "b/WorkM/\346\265\201\350\275\254\345\215\241\347\256\241\347\220\206/MES_StationEntrustOutBillList.cs" @@ -51,6 +51,11 @@ string sSql = ""; string sWhere = ""; + if (chkWJieAn.Checked == true) + { + sWhere = " and HBillStatus<>3 "; + } + if (frmCondition.SqlStr.Trim().Length == 0) { sSql = "Select top 5000 * from " + ViewName + " Where 1=1 " + sWhere + sDlgWhere + " order by 鏃ユ湡 desc,鍗曟嵁鍙� desc "; @@ -200,6 +205,7 @@ oSumGrid.ogrdMain = grdMain; //鍒濆鍖� new oSumGrid.oGridsum = grdSum; initGrid(); + chkWJieAn.Checked = true; } private void grdMain_DblClick(object sender, EventArgs e) @@ -276,6 +282,17 @@ // return; //} + //鍒ゆ柇浼氳鏈熸槸鍚﹀悎鐞� + string s = ""; + int sYear = 0; + int sPeriod = 0; + if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(DBUtility.ClsPub.isDate(oBill.omodel.HDate), ref sYear, ref sPeriod, ref s) == false) + { + MessageBox.Show(s, "鎻愮ず"); + return; + } + + SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); DataSet ds; -- Gitblit v1.9.1