private void radGridView1_CellEndEdit(object sender, Telerik.WinControls.UI.GridViewCellEventArgs e)
{
try
{
if (e.ColumnIndex == radGridView1.Columns["LotNo"].Index)
{
string LotNo = radGridView1.Rows[e.RowIndex].Cells["LotNo"].Value.ToString();
string PONo = radGridView1.Rows[e.RowIndex].Cells["PORDER"].Value.ToString();
DateTime date1 = Convert.ToDateTime(radGridView1.Rows[e.RowIndex].Cells["DeliveryDate"].Value.ToString());
using (DataClasses1DataContext db = new DataClasses1DataContext())
{
tb_HistoryPrintSupplier tp = db.tb_HistoryPrintSuppliers.Where(t => t.PONo == PONo).FirstOrDefault();
if (tp != null)
{
tp.LotNo = LotNo;
db.SubmitChanges();
}
else
{
tb_HistoryPrintSupplier tn = new tb_HistoryPrintSupplier();
tn.PONo = PONo;
tn.LotNo = LotNo;
tn.PrintTAG = false;
tn.DeliveryDate = date1;
db.tb_HistoryPrintSuppliers.InsertOnSubmit(tn);
db.SubmitChanges();
}
}
}
}
catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); }
}
private void PrintTAG()
{
try
{
this.Cursor = Cursors.WaitCursor;
//Supplier_TAG.rpt
//@UserID
//@Datex
//WP=> SupplierTAG
int chkAdd = 0;
int Qty = 0;
int Snp = 0;
int TAG = 0;
int Remain = 0;
DateTime dl = DateTime.Now;
string QrCode = "";
string OfTAG = "";
double ap = 0;
int a = 0;
// DateTime DateDl = DateTime.Now;
using (DataClasses1DataContext db = new DataClasses1DataContext())
{
var td = db.TempPrintSuppliers.Where(t => t.UserID.ToLower() == dbClss.UserID.ToLower());
db.TempPrintSuppliers.DeleteAllOnSubmit(td);
db.SubmitChanges();
radGridView1.EndUpdate();
radGridView1.EndEdit();
foreach (GridViewRowInfo rd in radGridView1.Rows.Where(o => Convert.ToBoolean(o.Cells["chk"].Value)))
{
if (Convert.ToBoolean(rd.Cells["chk"].Value))
{
Snp = Convert.ToInt32(rd.Cells["LotSize"].Value);
Qty = Convert.ToInt32(rd.Cells["OrderQty"].Value);
dl = Convert.ToDateTime(rd.Cells["DeliveryDate"].Value);
if (Qty != 0 && Snp != 0)
{
a = 0;
ap = (Qty % Snp);
if (ap > 0)
{
a = 1;
}
TAG = Convert.ToInt32(Math.Floor((Convert.ToDouble(Qty) / Convert.ToDouble(Snp)) + a));//.ToString("###");
//txtOftag.Text = Math.Ceiling((double)1.7 / 10).ToString("###");
Remain = Qty;
}
////////////////////////////////////////////////
for (int i = 1; i <= TAG; i++)
{
if (Remain > Snp)
{
Qty = Snp;
Remain = Remain - Snp;
}
else
{
Qty = Remain;
Remain = 0;
}
OfTAG = i + "of" + TAG;
QrCode = "";
QrCode = "EX," + rd.Cells["PORDER"].Value.ToString() + "," + Qty + "," + Snp + "," + rd.Cells["LotNo"].Value.ToString() + "," + OfTAG + "," + rd.Cells["Code"].Value.ToString();
//MessageBox.Show(QrCode);
byte[] barcode = dbClss.SaveQRCode2D(QrCode);
TempPrintSupplier ts = new TempPrintSupplier();
ts.UserID = dbClss.UserID;
ts.PONo = rd.Cells["PORDER"].Value.ToString();
ts.LotNo = rd.Cells["LotNo"].Value.ToString();
ts.TAGRemark = dl.ToString("dd/MM/yyyy");
ts.QRCode = barcode;
ts.PartName = rd.Cells["NAME"].Value.ToString();
ts.ItemNo = rd.Cells["Code"].Value.ToString();
ts.SNP = Convert.ToInt32(rd.Cells["LotSize"].Value);
ts.Company = rd.Cells["VendorName"].Value.ToString();
ts.Quantity = Qty;
ts.OfTAG = i + " / " + TAG;
///////////////////////////////////////////////
db.TempPrintSuppliers.InsertOnSubmit(ts);
db.SubmitChanges();
}
tb_HistoryPrintSupplier tp = db.tb_HistoryPrintSuppliers.Where(t => t.PONo == rd.Cells["PORDER"].Value.ToString()).FirstOrDefault();
if (tp != null)
{
tp.LotNo = rd.Cells["LotNo"].Value.ToString();
tp.PrintTAG = true;
db.SubmitChanges();
}
else
{
tb_HistoryPrintSupplier tn = new tb_HistoryPrintSupplier();
tn.PONo = rd.Cells["PORDER"].Value.ToString();
tn.LotNo = rd.Cells["LotNo"].Value.ToString();
tn.PrintTAG = true;
tn.DeliveryDate = dl;
db.tb_HistoryPrintSuppliers.InsertOnSubmit(tn);
db.SubmitChanges();
}
chkAdd += 1;
}
}
}
Report.Reportx1.WReport = "SupplierTAG";
Report.Reportx1.Value = new string[1];
Report.Reportx1.Value[0] = dbClss.UserID;
Report.Reportx1 op = new Report.Reportx1("Supplier_TAG.rpt");
op.Show();
}
catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); }
this.Cursor = Cursors.Default;
}
