条码拆码+工时单+器具权限

zzr99

2022-01-19 dfd0831df7b8245b7af6b6be28efd18b29fab17d

 WarM/±¨±í·ÖÎö/Kf_BarCodeOutInReport.cs

@@ -24,33 +24,38 @@

        Pub_Class.ClsGridListSum oSumGrid = new Pub_Class.ClsGridListSum();

        #region å›ºå®šä»£ç  
        #region  å›ºå®šä»£ç 

        private void initGrid()
        private void Kf_BarCodeOutInReport_Load(object sender, EventArgs e)
        {
            DBUtility.Xt_BaseBillFun.initGridRpt(grdMain, this.Name);
        }
       
        //得到对应列
        private Int32 Fun_GetCol(string sCol)
        {
            return DBUtility.Xt_BaseBillFun.Fun_GetCol(sCol, grdMain);
            SetFormCaption();
            oSumGrid.ogrdMain = grdMain;  //初始化 new
            //oSumGrid.oGridsum = grdSum;
            dtpHBDate.Value = DateTime.Today;
            dtpHEDate.Value = DateTime.Today;
            //加载单据类型信息
            Sub_AddBillTypeList();
        }

        private void tc_Click(object sender, EventArgs e)
        //加载单据类型信息
        private void Sub_AddBillTypeList()
        {
            this.Close();
            SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
            DataSet ds = oCn.RunProcReturn("exec h_p_WMS_BarCodeReport_BillType ", "h_p_WMS_BarCodeReport_BillType");
            if (ds == null || ds.Tables[0].Rows.Count == 0)
            {
                MessageBox.Show("获取单据类型失败");
                return;
            }
            cmbBillType.Items.Clear();
            cmbBillType.Items.Add("全部");
            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                cmbBillType.Items.Add(DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[i]["HBillTypeName"]));
            }
            cmbBillType.Text = "全部";
        }

        //Kf_BarCodeOutInReportDlg oDlg = new Kf_BarCodeOutInReportDlg();
        private void cx_Click(object sender, EventArgs e)
        {
            //oDlg.ShowDialog();
            //if (oDlg.IsOk == 1)
            //{
                timer1.Enabled = true;
            //}
        }
        //设置报表名称
        private void SetFormCaption()
        {
@@ -61,16 +66,16 @@
            cmbBillType.SelectedIndex = 0;
        }


        private void Frm_EasyReport_Load(object sender, EventArgs e)
        private void initGrid()
        {
            SetFormCaption();
            oSumGrid.ogrdMain = grdMain;  //初始化 new
            //oSumGrid.oGridsum = grdSum;
            dtpHBDate.Value = DateTime.Today;
            dtpHEDate.Value = DateTime.Today;
            DBUtility.Xt_BaseBillFun.initGridRpt(grdMain, this.Name);
        }

        //初始化表头显示
        private void initHeadCaption()
        {

        }

        private void timer1_Tick(object sender, EventArgs e)
        {
@@ -88,45 +93,10 @@
            }
        }

        private void Xs_SellOutPriceReport_KeyUp(object sender, KeyEventArgs e)
        private void timer2_Tick(object sender, EventArgs e)
        {
            if (e.KeyValue == 13)
                timer1.Enabled = true;
        }

        private void mrlk_Click(object sender, EventArgs e)
        {

            DBUtility.Xt_BaseBillFun.DefaultGridView(grdMain, this.Name);
        }

        private void bclk_Click(object sender, EventArgs e)
        {
            //保存列宽
            DBUtility.Xt_BaseBillFun.SaveGrid(grdMain, this.Name);
        }

        
        //打印
        private void dy_Click(object sender, EventArgs e)
        {
            Sub_SetReport();
            Report.Print(true);
        }
        //预览
        private void view_Click(object sender, EventArgs e)
        {
            Sub_SetReport();
            Report.PrintPreview(true);
        }
       
        #endregion

        #region ç•Œé¢å¤„理
        //初始化表头显示
        private void initHeadCaption()
        {
             
            timer2.Enabled = false;
            timer1.Enabled = true;
        }

        private bool Fun_AllowQuery()//审核查询条件
@@ -139,43 +109,87 @@
            return true;
        }

        private void grdMain_Paint(object sender, PaintEventArgs e)
        {
            DBUtility.Xt_BaseBillFun.GraphicsGrid(grdMain);
        }

        private void grdMain_CellMouseUp(object sender, DataGridViewCellMouseEventArgs e)
        {
            Total();
        }

        private void grdMain_ColumnWidthChanged(object sender, DataGridViewColumnEventArgs e)
        {
            Total();
        }

        private void Total()
        {
            if (grdMain.Rows.Count > 0 && grdMain.ColumnCount > 0)
            {
                oSumGrid.SetGridsum();
                oSumGrid.Total();
            }
        }

        //得到对应列
        private Int32 Fun_GetCol(string sCol)
        {
            return DBUtility.Xt_BaseBillFun.Fun_GetCol(sCol, grdMain);
        }

        private void Xs_SellOutPriceReport_KeyUp(object sender, KeyEventArgs e)
        {
            if (e.KeyValue == 13)
                timer1.Enabled = true;
        }

        //保存列宽
        private void bclk_Click(object sender, EventArgs e)
        {
            DBUtility.Xt_BaseBillFun.SaveGrid(grdMain, this.Name);
        }

        //默认列宽
        private void mrlk_Click(object sender, EventArgs e)
        {
            DBUtility.Xt_BaseBillFun.DefaultGridView(grdMain, this.Name);
        }

        #endregion

        #region  æŸ¥è¯¢åŠŸèƒ½

        private void cx_Click(object sender, EventArgs e)
        {
            timer1.Enabled = true;
        }

        private void Display()
        {
            ClsCN SubCn = new ClsCN();
            DataSet DSet = new DataSet();
            //显示报表头 æ ‡é¢˜
            
            //显示过滤条件


            //过滤条件Dlg
            string sDlgWhere = "";
            sDlgWhere = sDlgWhere + ",'" + dtpHBDate.Value.ToShortDateString() + "'";
            sDlgWhere = sDlgWhere + ",'" + dtpHEDate.Value.ToShortDateString() + "'";
            sDlgWhere = sDlgWhere + ",'" + txtHMater.Text + "'";
            sDlgWhere = sDlgWhere + ",'" + txtHWHName.Text + "'";
            sDlgWhere = sDlgWhere + ",'" + txtHSPName.Text + "'";
            sDlgWhere = sDlgWhere + ",'" + txtHBatchNo.Text + "'";
            sDlgWhere = sDlgWhere + ",'" + txtHBarCode.Text + "'";
            sDlgWhere = sDlgWhere + ",'" + cmbBillType.Text + "'";
            sDlgWhere = sDlgWhere + ",'" + txtHBillNo.Text + "'";
            //sDlgWhere = sDlgWhere + ",'" + oDlg.cmbHSumType.Text.Trim() + "'";
            sDlgWhere = sDlgWhere + ",'" + txtHBarCode.Text + "'";
            sDlgWhere = sDlgWhere + ",'" + txtHMater.Text + "'";
            sDlgWhere = sDlgWhere + ",'" + txtHBatchNo.Text + "'";
            sDlgWhere = sDlgWhere + ",'" + txtHWHName.Text + "'";
            sDlgWhere = sDlgWhere + ",'" + txtHSPName.Text + "'";
            sDlgWhere = sDlgWhere + ",'" + txtHSourceBillNo.Text + "'";
            sDlgWhere = sDlgWhere + ",'" + txtHMaker.Text + "'";
            if (sDlgWhere.Trim().Length > 0)
            {
                sDlgWhere = sDlgWhere.Substring(1, sDlgWhere.Length - 1);
            }
            //过滤条件
            //string sWhere = "";
            //sWhere = sWhere + ",'" + dtpHBDate.Value.ToShortDateString() + "'";
            //sWhere = sWhere + ",'" + dtpHEDate.Value.ToShortDateString() + "'";
            //sWhere = sWhere + "," + ClsPub.isLong(txtHCusID.Tag) + "";
            //sWhere = sWhere + ",3";
            //if (sWhere.Trim().Length > 0)
            //{
            //    sWhere = sWhere.Substring(1, sWhere.Length - 1);
            //}
            //
            DSet = SubCn.RunProcReturn("exec h_p_Kf_BarCodeOutInReport " + sDlgWhere, "h_p_Kf_BarCodeOutInReport");

            DSet = SubCn.RunProcReturn("exec h_p_Kf_BarCodeOutInReport_New " + sDlgWhere, "h_p_Kf_BarCodeOutInReport_New");
            //生成首行标题
            if (DSet == null)
            {
@@ -199,36 +213,9 @@

        #endregion

        #region æ‰“印设置
        #region  å¯¼å‡ºåŠŸèƒ½

        //打印设置
        GridppReport Report;
        //设置打印模版路径
        private void Sub_SetReport()
        {
            Report = new GridppReport();
            Report.LoadFromFile(ClsPub.AppPath + @"\Report\应收款明细表.grf");  //here .
            Report.BeforePostRecord += new _IGridppReportEvents_BeforePostRecordEventHandler(ReportBeforePostRecord);
            Report.FetchRecord += new _IGridppReportEvents_FetchRecordEventHandler(ReportFetchRecordByDataTable);
        }
        //填入单据表头信息
        private void ReportBeforePostRecord()//your report?kao
        {
            //Report.FieldByName("HDateItemID").AsString = lblHDateItemID.Text;
            //Report.FieldByName("CusNumber").AsString = lblHCusNumber.Text;
            //Report.FieldByName("CusName").AsString = lblHCusName.Text;
            //Report.FieldByName("BeginBalance").AsString = lblHBeginBalance.Text;
        }
        //填入单据明细信息
        private void ReportFetchRecordByDataTable()
        {
            //BLL.Utility.FillRecordToReport(Report, grdMain, false);
        }
        #endregion

        #region æ•°æ®å¯¼å‡º

        
        //引出
        private void yc_Click(object sender, EventArgs e)
        {
            //BLL.ClsPub_BLL.DataGridViewToExcel2(grdMain, this.Text);
@@ -321,46 +308,72 @@
            }
        }

        //导出
        private void dc_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
        }

        #endregion

         
        #region  é€€å‡ºåŠŸèƒ½

        private void timer2_Tick(object sender, EventArgs e)
        private void tc_Click(object sender, EventArgs e)
        {
            timer2.Enabled = false;
            //oDlg.ShowDialog();
            //if (oDlg.IsOk == 1)
            //{
                timer1.Enabled = true;
            //}
            this.Close();
        }

        private void Total()
        #endregion

        #region  æ‰“印功能

        //打印设置
        GridppReport Report;

        //预览
        private void view_Click(object sender, EventArgs e)
        {
            if (grdMain.Rows.Count > 0 && grdMain.ColumnCount > 0)
            {
                oSumGrid.SetGridsum();
                oSumGrid.Total();
            }
            Sub_SetReport();
            Report.PrintPreview(true);
        }

        private void grdMain_CellMouseUp(object sender, DataGridViewCellMouseEventArgs e)
        //打印
        private void dy_Click(object sender, EventArgs e)
        {
            Total();
            Sub_SetReport();
            Report.Print(true);
        }

        private void grdMain_ColumnWidthChanged(object sender, DataGridViewColumnEventArgs e)
        //设置打印模版路径
        private void Sub_SetReport()
        {
            Total();

            Report = new GridppReport();
            Report.LoadFromFile(ClsPub.AppPath + @"\Report\应收款明细表.grf");  //here .
            Report.BeforePostRecord += new _IGridppReportEvents_BeforePostRecordEventHandler(ReportBeforePostRecord);
            Report.FetchRecord += new _IGridppReportEvents_FetchRecordEventHandler(ReportFetchRecordByDataTable);
        }

        private void grdMain_Paint(object sender, PaintEventArgs e)
        //填入单据表头信息
        private void ReportBeforePostRecord()//your report?kao
        {
            DBUtility.Xt_BaseBillFun.GraphicsGrid(grdMain);
            //Report.FieldByName("HDateItemID").AsString = lblHDateItemID.Text;
            //Report.FieldByName("CusNumber").AsString = lblHCusNumber.Text;
            //Report.FieldByName("CusName").AsString = lblHCusName.Text;
            //Report.FieldByName("BeginBalance").AsString = lblHBeginBalance.Text;
        }

        
        //填入单据明细信息
        private void ReportFetchRecordByDataTable()
        {
            //BLL.Utility.FillRecordToReport(Report, grdMain, false);
        }

        #endregion






    }
}