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();
}
}
