Beispiel #1
0
        public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
        {
            rpt_KTNB01 rpt = new rpt_KTNB01();

            rpt.Site = this.Site;
            return(rpt);
        }
Beispiel #2
0
        private void BtnOk_OnClick(object sender, RoutedEventArgs e)
        {
            try
            {
                cls.ClsConnect();
                string pos   = s.Left(CboPos.SelectedValue.ToString(), 6);
                string thang = dtpNgay.SelectedDate.Value.ToString("MM");
                string nam   = dtpNgay.SelectedDate.Value.ToString("yyyy");
                dtNew = dt.GetChanges();
                if (dtNew != null && dtNew.Rows.Count > 0)
                {
                    foreach (DataRow dr in dtNew.Rows)
                    {
                        //MessageBox.Show(dr["NG_MATO"].ToString()+"      "+dr["A01"].ToString());
                        string strsql = "update LUUKTNB set COT03=" + dr["COT03"] + ",COT04=" + dr["COT04"] + ",COT05=" + dr["COT05"]
                                        + ",COT06=" + dr["COT06"] + ",COT07=" + dr["COT07"]
                                        + ",COT08=" + dr["COT08"] + ",COT09=" + dr["COT09"] + ",COT10=" + dr["COT10"] + ",COT11=" +
                                        dr["COT11"] + ",COT12=" + dr["COT12"] + ",COT13=" + dr["COT13"] + ",COT14=" + dr["COT14"] +
                                        ",COT15=" + dr["COT15"] + ",COT16=" + dr["COT16"] + ",COT17=" + dr["COT17"]
                                        + ",ND_MA='" + BienBll.Ndma + "',ND_TEN=N'" + BienBll.NdTen + "'"
                                        + " where MAPOS='" + pos + "' and TT='" + dr["TT"] + "' and THANG='" + thang + "' and NAM='" + nam + "' and MAU='2'";
                        cls.UpdateDataText(strsql);
                    }
                }
                else
                {
                    MessageBox.Show("Xem lại. Chưa có thay đổi nào!", "Mess", MessageBoxButton.OK, MessageBoxImage.Warning);
                }
                string strup = "update LUUKTNB set COT05= (case when COT03>0 then COT04*100/COT03 else 0 end)" +
                               ",COT08=(case when COT06>0 then COT07*100/COT06 else 0 end) " +
                               ",COT11=(case when COT09>0 then COT10*100/COT09 else 0 end) " +
                               ",COT14=(case when COT12>0 then COT13*100/COT12 else 0 end) " +
                               ",COT17=(case when COT15>0 then COT16*100/COT15 else 0 end) " +
                               "where MAPOS='" + pos + "' and THANG='" + thang + "' and NAM='" + nam + "' and MAU='2'";
                cls.UpdateDataText(strup);
                if (Option1.IsChecked == true)
                {
                    strin = "select * from LUUKTNB where MAPOS='" + pos + "' and THANG='" + thang +
                            "' and NAM='" + nam + "' and MA='H' and MAU='2' order by TT";
                }
                else
                {
                    strin = "select * from LUUKTNB where MAPOS='" + pos + "' and THANG='" + thang +
                            "' and NAM='" + nam + "' and MA='T' and MAU='2'  order by TT";
                }

                var dtin =
                    cls.LoadDataText(strin);
                rpt_KTNB01 rpt = new rpt_KTNB01();
                RPUtility.ShowRp(rpt, dtin, this, srv.DbSourceSerVer(), srv.DbNameSerVer(), srv.DbUserSerVer(), srv.DbPassSerVer());
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error \n" + ex.Message, "Mess", MessageBoxButton.OK, MessageBoxImage.Error);
            }
            finally
            {
                cls.DongKetNoi();
            }
        }