更改代码上传

王 垚

2020-12-14 82eb3f2600467ec9281b17d7ef97cf85f51e1e8e

 src/BLL/Demo.BillView/PRD/ProCompleteAnalysisMateriel.cs

@@ -42,7 +42,7 @@
                                        where FHMainICMOInterIDr ='{0}' and FIDENTIFICAT=2 and FHMATERID ='{1}'", FHMainICMOInterIDr, FMatrailId);
                sql = string.Format(@"/*dialect*/select a.*,b.FBILLNO FBILLNOs from JIT_MOMaterReadysBill a  
                                        left join T_PRD_MO b on a.FHMainICMOInterIDr=b.FID
                                        where   FHMATERID ='{0}'", FMatrailId);
                                        where  FCompleteCount>0 and    FHMATERID ='{0}'", FMatrailId);
                DataTable dt = DBServiceHelper.ExecuteDataSet(this.Context, sql).Tables[0];
                if (dt.Rows.Count > 0)
                {
@@ -69,7 +69,7 @@
        /// </summary>
        public void SearchList()
        {
            string sqlwhere = " where 1=1";
            string sqlwhere = " where FCompleteCount>0 and  1=1";
            string sql = string.Format(@"/*dialect*/select a.*,b.FBILLNO FBILLNOs from JIT_MOMaterReadysBill a  
                                        left join T_PRD_MO b on a.FHMainICMOInterIDr=b.FID   
                                         ");