private void ShowEPPI_Sample()
{
foreach (DataRow dr in ClsCantierDB.Sohbi_GetLotCard4PrintingNew(_g_lotno).Rows)
{
RenderQrCode(dr["OuterLotCardNo"].ToString().Trim(), dr["QRcode"].ToString().Trim());
}
if (ClsCantierDB.Sohbi_GetEPPIinsideLotCards4Printing(_g_lotno).Rows.Count > 0)
{
foreach (DataRow dr in ClsCantierDB.Sohbi_GetEPPIinsideLotCards4Printing(_g_lotno).Rows)
{
RenderQrCode(dr["OuterLotCardNo"].ToString().Trim() + "-" + dr["InnerLotCardNo"].ToString().Trim(), dr["QRcode"].ToString().Trim());
}
}
LotCardLabel_Report_EPPI frm = new LotCardLabel_Report_EPPI();
frm._formNos = _g_lotno;
frm._reportType = "Sample";
frm.WindowStartupLocation = WindowStartupLocation.CenterScreen;
frm.Height = frmSize_Height;
frm.Width = frmSize_Width;
frm.WindowState = WindowState.Normal;
frm.ResizeMode = ResizeMode.CanResize;
frm.Show();
}
private Boolean _validateIfPrinted()
{
SqlCommand cmd = new SqlCommand("SELECT ISNULL(count(*),0) FROM tblLotCardGroup WHERE LotCardGroupNo=@LotCardNo AND IsPrinted = 1");
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@LotCardNo", _formNos.ToString().Trim());
if (Convert.ToInt32(SqlHelper.ExecuteScalar(ClsConfig.Cantier_LotCardLabelConnectionString, cmd)) > 0)
{
MessageBoxResult messageBoxResult = MessageBox.Show("This lot card was already printed. Are you sure you want to print it again?"
, "Confirmation", MessageBoxButton.YesNo);
if (messageBoxResult == MessageBoxResult.Yes)
{
//reportViewer.ViewerCore.PrintReport();
if (ClsCantierDB.Sohbi_GetEPPIinsideLotCards4Printing(_formNos.ToString().Trim()).Rows.Count > 0)
{
//PrinterSettings settings = new PrinterSettings();
//string defaultPrinterName = settings.PrinterName;
//MessageBox.Show(defaultPrinterName);
PrintData(docA, docB, 1, 0, 0);
MessageBox.Show("Record Successfully Printed");
this.Close();
}
else
{
//PrinterSettings settings = new PrinterSettings();
//string defaultPrinterName = settings.PrinterName;
//MessageBox.Show(defaultPrinterName);
PrintData2(docA, 1, 0, 0);
MessageBox.Show("Record Successfully Printed");
this.Close();
}
}
else
{
}
}
else
{
SqlCommand cmd2 = new SqlCommand(
"UPDATE [dbo].[tblLotCardGroup] SET IsPrinted = 1 WHERE LotCardGroupNo=@LotCardNo");
cmd2.CommandType = CommandType.Text;
cmd2.Parameters.AddWithValue("@LotCardNo", _formNos.ToString().Trim());
SqlHelper.ExecuteNonQuery(ClsConfig.Cantier_LotCardLabelConnectionString, cmd2);
//reportViewer.ViewerCore.PrintReport();
if (ClsCantierDB.Sohbi_GetEPPIinsideLotCards4Printing(_formNos.ToString().Trim()).Rows.Count > 0)
{
//PrinterSettings settings = new PrinterSettings();
//string defaultPrinterName = settings.PrinterName;
PrintData(docA, docB, 1, 0, 0);
MessageBox.Show("Record Successfully Printed");
this.Close();
//MessageBox.Show(defaultPrinterName);
}
else
{
//PrinterSettings settings = new PrinterSettings();
//string defaultPrinterName = settings.PrinterName;
//MessageBox.Show(defaultPrinterName);
PrintData2(docA, 1, 0, 0);
MessageBox.Show("Record Successfully Printed");
this.Close();
}
}
return(true);
}
