public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
rpt_Nguon_Cqlv rpt = new rpt_Nguon_Cqlv();
rpt.Site = this.Site;
return(rpt);
}
private void BtnOk_OnClick(object sender, RoutedEventArgs e)
{
try
{
if (dtNew.Rows.Count > 0)
{
cls.ClsConnect();
foreach (DataRow dr in dtNew.Rows)
{
//MessageBox.Show(dr["NG_MATO"].ToString()+" "+dr["A01"].ToString());
string strsql = "update NGUON_CQLV set C11=" + dr["C11"] + ",C12=" + dr["C12"] + ",C13=" +
dr["C13"] + ",C14=" + dr["C14"] + ",C15=" + dr["C15"] + ",C16=" + dr["C16"]
+ ",C17=" + dr["C17"] + ",C18=" + dr["C18"] + ",C19=" + dr["C19"]
+ ",C20=" + dr["C20"] + ",C21=" + dr["C21"]
+ " where NG_MAXA='" + dr["NG_MAXA"].ToString().Trim() + "'";
cls.UpdateDataText(strsql);
}
MessageBox.Show("Update Ok", "Mess", MessageBoxButton.OK, MessageBoxImage.Information);
if (
MessageBox.Show("Có muốn in số liệu ra không ?", "Question", MessageBoxButton.YesNo,
MessageBoxImage.Warning) == MessageBoxResult.Yes)
{
cls.ClsConnect();
int thamso = 1;
string[] bien = new string[thamso];
object[] giatri = new object[thamso];
bien[0] = "@MaPos";
giatri[0] = s.Left(CboPos.SelectedValue.ToString().Trim(), 6);
var dtin = cls.LoadDataProcPara("usp_InNguon_Cqlv", bien, giatri, thamso);
rpt_Nguon_Cqlv rpt = new rpt_Nguon_Cqlv();
RPUtility.ShowRp(rpt, dtin, this, srv.DbSourceSerVer(), srv.DbNameSerVer(), srv.DbUserSerVer(), srv.DbPassSerVer());
}
dtNew.Clear();
//dgvTarGet.ItemsSource = dtNew.DefaultView;
}
else
{
MessageBox.Show("Xem lại. Chưa có dữ liệu", "Mess", MessageBoxButton.OK, MessageBoxImage.Warning);
}
}
catch (Exception ex)
{
MessageBox.Show("Error \n" + ex.Message, "Mess", MessageBoxButton.OK, MessageBoxImage.Error);
}
finally
{
cls.DongKetNoi();
}
}
