Esempio n. 1
0
        private void ourButton2_Click_1(object sender, EventArgs e)
        {
            UserProc.WaitStart(this);
            var das = db.Queryable <BaseIList>().Where(it => it.leibie == benleibie && it.SN == SN_SN).First();

            if (das != null)
            {
                BindingSource bindingSource = new BindingSource();
                bindingSource.DataSource = das;
                FrmPrn frmPrn = new FrmPrn();
                frmPrn.rptView.LocalReport.ReportEmbeddedResource = "DotNetBarProject.view.RDLC.rptMD.rdlc";
                string[] asdf = das.item3.Split("||".ToCharArray(), StringSplitOptions.RemoveEmptyEntries);
                float[]  a    = { 0, 0, 0, 0, 0 };
                for (var i = 0; i < asdf.Length; i++)
                {
                    asdf[i] = asdf[i] == "-" ? " " : asdf[i];
                    int www = (int)Math.Floor((double)i / 12);
                    a[www] += asdf[i] == " " ? 0 : float.Parse(asdf[i]);
                }
                string[] b = new string[5];
                for (int i = 0; i < a.Length; i++)
                {
                    b[i] = a[i] + "";
                    b[i] = b[i] == "0" ? " " : b[i];
                }


                ReportParameter parameters2 = new ReportParameter("P2", asdf);
                ReportParameter parameters3 = new ReportParameter("P3", ClsLogUser.XinMing);
                ReportParameter parameters4 = new ReportParameter("P4", b);
                frmPrn.rptView.LocalReport.SetParameters(parameters2);
                frmPrn.rptView.LocalReport.SetParameters(parameters3);
                frmPrn.rptView.LocalReport.SetParameters(parameters4);
                frmPrn.rptView.LocalReport.DataSources.Clear();
                ReportDataSource reportDataSource = new ReportDataSource();
                reportDataSource.Name  = "DataSet1";
                reportDataSource.Value = bindingSource;
                frmPrn.rptView.LocalReport.DataSources.Clear();
                frmPrn.rptView.LocalReport.DataSources.Add(reportDataSource);
                frmPrn.rptView.RefreshReport();
                frmPrn.ShowDialog();
                frmPrn.Close();
            }
            else
            {
                MessageBox.Show("数据错误,请重新选择在打印", "提示");
            }
            UserProc.WaitEnd(this);
        }
Esempio n. 2
0
        //打印
        private void editBtnPrn_Click(object sender, EventArgs e)
        {
            if ((string)editImgLDH.Tag == "")
            {
                return;
            }
            this.lblwait.showme();
            FrmPrn frmPrn = new FrmPrn();

            frmPrn.rptView.LocalReport.ReportEmbeddedResource = "DotNetBarProject.view.rptXY.rdlc";
            frmPrn.rptView.LocalReport.DataSources.Clear();
            ReportDataSource reportDataSource1 = new ReportDataSource();

            reportDataSource1.Name  = "ldmain";
            reportDataSource1.Value = (object)this.bsShowMain;
            ReportDataSource reportDataSource2 = new ReportDataSource();

            reportDataSource2.Name  = "lddata";
            reportDataSource2.Value = (object)this.bsShowData;
            frmPrn.rptView.LocalReport.DataSources.Add(reportDataSource1);
            frmPrn.rptView.LocalReport.DataSources.Add(reportDataSource2);
            string filename = Application.StartupPath + "\\imgLDH.Bmp";

            this.editImgLDH.Image.Save(filename, ImageFormat.Bmp);
            string str = "file:///" + filename.Replace("\\", "/");

            frmPrn.rptView.LocalReport.EnableExternalImages = true;
            ReportParameter reportParameter1 = new ReportParameter("LDH", str);
            ReportParameter reportParameter2 = new ReportParameter("GSname", UserProc.GSname);

            frmPrn.rptView.LocalReport.SetParameters((IEnumerable <ReportParameter>) new ReportParameter[2]
            {
                reportParameter1,
                reportParameter2
            });
            frmPrn.rptView.RefreshReport();
            int num = (int)frmPrn.ShowDialog();

            frmPrn.Close();
            this.lblwait.hideme();
        }
Esempio n. 3
0
        private void editBtnPrn_Click(object sender, EventArgs e)
        {
            if (this.showLDH == "")
            {
                return;
            }
            this.lblwait.showme();
            FrmPrn frmPrn = new FrmPrn();

            frmPrn.rptView.LocalReport.ReportEmbeddedResource = "DotNetBarProject.view.RDLC.rptSchCB.rdlc";
            frmPrn.rptView.LocalReport.DataSources.Clear();
            ReportDataSource reportDataSource1 = new ReportDataSource();

            reportDataSource1.Name  = "ldmain";
            reportDataSource1.Value = (object)this.bsShowMain;
            ReportDataSource reportDataSource2 = new ReportDataSource();

            reportDataSource2.Name = "lddata";
            DataTable        dataTable      = (DataTable)bsShowData.DataSource;
            List <T_PFdataT> list_T_PFdataT = new List <T_PFdataT>();

            for (var i = 0; i < dataTable.Rows.Count; i++)
            {
                T_PFdataT t_PFdataT = new T_PFdataT();
                var       a         = dataTable.Rows[i];
                t_PFdataT.gongxu        = a.Field <string>("gongxu");
                t_PFdataT.ranliao       = a.Field <string>("ranliao");
                t_PFdataT.bili          = a.Field <Decimal>("bili");
                t_PFdataT.biliDW        = a.Field <string>("biliDW");
                t_PFdataT.yongliang     = a.Field <Decimal>("yongliang");
                t_PFdataT.yongliangDW   = a.Field <string>("yongliangDW");
                t_PFdataT.yaoqiu        = a.Field <string>("yaoqiu");
                t_PFdataT.JLbili        = a.Field <Decimal>("JLbili");
                t_PFdataT.JLyongliang   = a.Field <Decimal>("JLyongliang");
                t_PFdataT.JLyongliangDW = a.Field <string>("JLyongliangDW");
                t_PFdataT.SNld          = a.Field <long>("SNld");
                t_PFdataT.danjia        = a.Field <Decimal?>("danjia");
                t_PFdataT.jine          = a.Field <Decimal?>("jine");
                list_T_PFdataT.Add(t_PFdataT);
            }
            reportDataSource2.Value = (object)list_T_PFdataT;
            frmPrn.rptView.LocalReport.DataSources.Add(reportDataSource1);
            frmPrn.rptView.LocalReport.DataSources.Add(reportDataSource2);
            string filename = Application.StartupPath + "\\imgLDH.Bmp";

            this.editImgLDH.Image.Save(filename, ImageFormat.Bmp);
            string str = "file:///" + filename.Replace("\\", "/");

            frmPrn.rptView.LocalReport.EnableExternalImages = true;
            ReportParameter reportParameter1 = new ReportParameter("LDH", str);
            ReportParameter reportParameter2 = new ReportParameter("GSname", UserProc.GSname);

            frmPrn.rptView.LocalReport.SetParameters((IEnumerable <ReportParameter>) new ReportParameter[2]
            {
                reportParameter1,
                reportParameter2
            });
            frmPrn.rptView.RefreshReport();
            int num = (int)frmPrn.ShowDialog();

            frmPrn.Close();
            this.lblwait.hideme();
        }
Esempio n. 4
0
        private void button5_Click(object sender, EventArgs e)
        {
            LCKA lcka = getByWhere[0];

            UserProc.WaitStart(this);
            string asd = lcka.riqiZhidan.ToString("yy-MM-dd HH:mm");

            //asd = asd.Replace("月", "-").Replace("日", "");
            Console.WriteLine("-------------" + asd);
            List <LCKA> list = new List <LCKA>();

            if (lcka == null)
            {
                MessageBox.Show(this, "该流程卡已不存在!请核对!", "提示");
                UserProc.WaitEnd(this);
            }
            else
            {
                var asdfg = db.Queryable <BaseIList>()
                            .Where(it => it.leibie == "产量登记" && it.item1 == "开卡" && it.dingdanhao == lcka.liushuihao)
                            .First();
                if (asdfg == null)
                {
                    var sd = new BaseIList()
                    {
                        leibie     = "产量登记",
                        dingdanhao = lcka.liushuihao,
                        pingmin    = lcka.peiming,
                        seming     = lcka.sebie,
                        sehao      = lcka.sehao,
                        item0      = ClsLogUser.XinMing, //操作人员
                        pishu      = lcka.peishu,
                        item1      = "开卡",               //工序
                        zongliang  = lcka.zhongliang,
                        item2      = "0%",               //百分比
                        riqi       = DateTime.Now,
                        item3      = "开卡",
                        kehu       = lcka.kehu,
                    };
                    db.Insertable <BaseIList>(sd).ExecuteCommand();
                }

                list.Add(lcka);

                /*
                 * if (lcka.zonggangshu == "" || !UserProc.IsInt(lcka.zonggangshu))
                 * {
                 *  list.Add(lcka);
                 * }
                 * else
                 * {
                 *  int num = Convert.ToInt32(lcka.zonggangshu);
                 *  for (int i = 0; i < num; i++)
                 *  {
                 *      LCKA asd1 = new LCKA();
                 *      asd1 = TransExpV2<LCKA, LCKA>.Trans(lcka);
                 *      asd1.liushuihao = string.Format("{0}", (int.Parse(lcka.liushuihao) + i));
                 *      list.Add(asd1);
                 *  }
                 * }
                 */
                FrmPrn frmPrn = new FrmPrn();
                frmPrn.rptView.LocalReport.ReportEmbeddedResource = "DotNetBarProject.view.Report2.rdlc";

                string filename = Application.StartupPath + "\\imgLCK.Bmp";
                pictureBox1.Image.Save(filename, ImageFormat.Bmp);
                string str = "file:///" + filename.Replace("\\", "/");
                frmPrn.rptView.LocalReport.EnableExternalImages = true;
                ReportParameter reportParameter1 = new ReportParameter("LDH", str);

                ReportParameter parameters  = new ReportParameter("p1", sclcgx.txt.Text);
                ReportParameter parameters1 = new ReportParameter("riqi", asd);

                string[] array = new string[30];
                var      asde  = db.Queryable <LCMX>().Where(it => it.SNka == lcka.SN).ToList();
                //string[] asdf = sclcgx.txt.Text.Split("->".ToCharArray(), StringSplitOptions.RemoveEmptyEntries);
                for (var i = 0; i < asde.Count; i++)
                {
                    array[i] = asde[i].gongxu;
                }
                for (int i = asde.Count; i < 30; i++)
                {
                    array[i] = "";
                }
                ReportParameter parameters2 = new ReportParameter("p2", array);
                //BindingSource asdfds = new BindingSource();
                //asdfds.DataSource = asde;
                //ReportDataSource reportDataSource1 = new ReportDataSource();
                //reportDataSource1.Name = "lblcmx";
                //reportDataSource1.Value = asdfds;

                frmPrn.rptView.LocalReport.SetParameters(parameters);
                frmPrn.rptView.LocalReport.SetParameters(parameters1);
                frmPrn.rptView.LocalReport.SetParameters(reportParameter1);
                frmPrn.rptView.LocalReport.SetParameters(parameters2);
                frmPrn.rptView.LocalReport.DataSources.Clear();
                ReportDataSource reportDataSource = new ReportDataSource();
                reportDataSource.Name  = "DataSet1";
                reportDataSource.Value = list;
                frmPrn.rptView.LocalReport.DataSources.Clear();
                frmPrn.rptView.LocalReport.DataSources.Add(reportDataSource);
                //frmPrn.rptView.LocalReport.DataSources.Add(reportDataSource1);
                var a = frmPrn.rptView.LocalReport.DataSources;
                frmPrn.rptView.RefreshReport();
                frmPrn.ShowDialog();
                frmPrn.Close();
                UserProc.WaitEnd(this);
            }
        }
Esempio n. 5
0
        private void 打印简历ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            UserProc.WaitStart(this);
            RSManage rSManage = db.Queryable <RSManage>().Where(it => it.SN == sn_sn).First();

            if (rSManage == null)
            {
                MessageBox.Show("请先选择要打印的行");
            }
            else
            {
                RSManage1 rSManage1 = new RSManage1();
                string[]  xinbie    = rSManage.Xingbie.Split(new string[] { "||" }, StringSplitOptions.RemoveEmptyEntries);

                rSManage1.SN         = rSManage.SN;
                rSManage1.Name       = rSManage.Name;
                rSManage1.Yixiang    = rSManage.Yixiang;
                rSManage1.Addr       = rSManage.Addr;
                rSManage1.phone      = rSManage.phone;
                rSManage1.EMail      = rSManage.EMail;
                rSManage1.born       = rSManage.born;
                rSManage1.JiGuan     = rSManage.JiGuan;
                rSManage1.Xingbie    = rSManage.Xingbie;
                rSManage1.Ziwopngjia = rSManage.Ziwopngjia;


                rSManage1.Xingbie = xinbie.Length == 0 ? "" : xinbie[0];
                rSManage1.sf      = xinbie.Length == 1 ? "" : xinbie[1];

                string[] jy = rSManage.JiaoYu.Split(new string[] { "||" }, StringSplitOptions.RemoveEmptyEntries);

                rSManage1.JiaoYu1 = jy[0] == "null" ? "" : jy[0];
                rSManage1.JiaoYu2 = jy[1] == "null" ? "" : jy[1];
                rSManage1.JiaoYu3 = jy[2] == "null" ? "" : jy[2];
                rSManage1.JiaoYu4 = jy[3] == "null" ? "" : jy[3];

                string[] gzjy = rSManage.gzjy.Split(new string[] { "||" }, StringSplitOptions.RemoveEmptyEntries);
                rSManage1.gzjy1 = gzjy[0] == "null" ? "" : gzjy[0];
                rSManage1.gzjy2 = gzjy[1] == "null" ? "" : gzjy[1];
                rSManage1.gzjy3 = gzjy[2] == "null" ? "" : gzjy[2];
                rSManage1.gzjy4 = gzjy[3] == "null" ? "" : gzjy[3];

                string[] JiNeng = rSManage.JiNeng.Split(new string[] { "||" }, StringSplitOptions.RemoveEmptyEntries);
                rSManage1.JiNeng1 = JiNeng[0] == "null" ? "" : JiNeng[0];
                rSManage1.JiNeng2 = JiNeng[1] == "null" ? "" : JiNeng[1];
                rSManage1.JiNeng3 = JiNeng[2] == "null" ? "" : JiNeng[2];
                rSManage1.JiNeng4 = JiNeng[3] == "null" ? "" : JiNeng[3];


                FrmPrn frmPrn = new FrmPrn();
                frmPrn.rptView.LocalReport.ReportEmbeddedResource = "DotNetBarProject.view.RDLC.rptTXL.rdlc";
                BindingSource bindingSource = new BindingSource();
                bindingSource.DataSource = rSManage1;
                ReportDataSource reportDataSource = new ReportDataSource();

                reportDataSource.Name  = "DataSet1";
                reportDataSource.Value = bindingSource;
                frmPrn.rptView.LocalReport.DataSources.Clear();
                frmPrn.rptView.LocalReport.DataSources.Add(reportDataSource);
                var a = frmPrn.rptView.LocalReport.DataSources;
                frmPrn.rptView.RefreshReport();
                frmPrn.ShowDialog();
                frmPrn.Close();
                UserProc.WaitEnd(this);
            }
        }