Beispiel #1
0
        /// <summary>
        /// 组批查询
        /// </summary>
        private void Query3()
        {
            string whereSql = " AND TRM.C_STA_ID='" + staID + "' ";

            if (this.dt_ExecStart.DateTime != DateTime.MinValue)
            {
                whereSql += " AND  TRM.D_MOD_DT>=to_date('" + dt_ExecStart.DateTime.ToString("yyyyMMdd") + "','yyyy-mm-dd') ";
                whereSql += " AND  TRM.D_MOD_DT<=to_date('" + dt_ExecEnd.DateTime.ToString("yyyyMMdd") + "','yyyy-mm-dd') ";
            }
            DataTable dt = bll_TRC_ROLL_MAIN.GetListMain(whereSql, false).Tables[0];

            this.gc_ZGZPSJ.DataSource = dt;
            this.gv_ZGZPSJ.OptionsView.ColumnAutoWidth = false;
            gridColumn12.ColumnEdit = sub.GetBCIdDescItemComboBox();
            gridColumn13.ColumnEdit = sub.GetBZIdDescItemComboBox();
            SetGridViewRowNum.SetRowNum(gv_ZGZPSJ);
        }