public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { rpt_KTNB02 rpt = new rpt_KTNB02(); rpt.Site = this.Site; return(rpt); }
private void BtnOk_OnClick(object sender, RoutedEventArgs e) { try { cls.ClsConnect(); string pos = BienBll.NdMadv; 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"] + ",COT06=" + dr["COT06"] + ",COT07=" + dr["COT07"] + ",ND_MA='" + BienBll.Ndma + "',ND_TEN=N'" + BienBll.NdTen + "'" + " where MAPOS='" + pos + "' and TT='" + dr["TT"] + "' and THANG='" + thang + "' and NAM='" + nam + "' and MAU='1'"; cls.UpdateDataText(strsql); } MessageBox.Show("Update Ok", "Mess", MessageBoxButton.OK, MessageBoxImage.Information); } 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) where MAPOS='" + pos + "' and THANG='" + thang + "' and NAM='" + nam + "' and MAU='1'"; cls.UpdateDataText(strup); var dtin = cls.LoadDataText("select * from LUUKTNB where MAPOS='" + pos + "' and THANG='" + thang + "' and NAM='" + nam + "' and MAU='1' order by TT"); rpt_KTNB02 rpt = new rpt_KTNB02(); 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(); } }