private void Print_Shelftag_datatable()
{
try
{
dt_ShelfTag.Rows.Clear();
using (DataClasses1DataContext db = new DataClasses1DataContext())
{
var g = (from ix in db.tb_Items select ix).Where(a => a.CodeNo == txtCodeNo.Text).ToList();
if (g.Count() > 0)
{
foreach (var gg in g)
{
dt_ShelfTag.Rows.Add(gg.CodeNo, gg.ItemDescription, gg.ShelfNo);
}
//DataTable DT = StockControl.dbClss.LINQToDataTable(g);
//Reportx1 po = new Reportx1("Report_PurchaseRequest_Content1.rpt", DT, "FromDT");
//po.Show();
Report.Reportx1 op = new Report.Reportx1("002_BoxShelf_Part.rpt", dt_ShelfTag, "FromDL");
op.Show();
}
else
{
MessageBox.Show("not found.");
}
}
}
catch (Exception ex) { MessageBox.Show(ex.Message); }
}
private void btnPrint_Click(object sender, EventArgs e)
{
try
{
string SHNo = "";
if (dgvData.Rows.Count > 0)
{
SHNo = StockControl.dbClss.TSt(dgvData.CurrentRow.Cells["ShippingNo"].Value);
}
if (TypeShip == "ShipFGAccident")
{
PrintPR a = new PrintPR(SHNo, SHNo, "ReportAccidentSlip");
a.ShowDialog();
}
else
{
Report.Reportx1.Value = new string[1];
Report.Reportx1.Value[0] = SHNo;
Report.Reportx1.WReport = "PickSlip";
Report.Reportx1 op = new Report.Reportx1("PickSlip_FG.rpt");
op.Show();
//PrintPR a = new PrintPR(SHNo, SHNo, "Shipping");
//a.ShowDialog();
}
}
catch { }
}
private void radButtonElement5_Click(object sender, EventArgs e)
{
try
{
string CheckNo = txtCheckNo.Text;
//ReportCheckStock.rpt
using (DataClasses1DataContext db = new DataClasses1DataContext())
{
//string CheckNo = dbClss.TSt(dgvData.CurrentRow.Cells["CheckNo"].Value);
var g = (from ix in db.sp_R_002_Report_DiffCheckStock(CheckNo, CheckNo, Convert.ToDateTime(DateTime.Now, new CultureInfo("en-US"))) select ix).ToList();
if (g.Count() > 0)
{
Report.Reportx1.Value = new string[2];
Report.Reportx1.Value[0] = CheckNo;
Report.Reportx1.Value[1] = CheckNo;
Report.Reportx1.WReport = "ReportCheckStockDiff";
Report.Reportx1 op = new Report.Reportx1("ReportCheckStockDiff.rpt");
op.Show();
}
else
{
MessageBox.Show("not found.");
}
}
}
catch (Exception ex) { MessageBox.Show(ex.Message); }
}
private void btn_PrintPR_Click(object sender, EventArgs e)
{
try
{
//dt_ShelfTag.Rows.Clear();
string PRNo1 = txtPRNo1.Text;
string PRNo2 = txtPRNo2.Text;
using (DataClasses1DataContext db = new DataClasses1DataContext())
{
if (Type.Equals("ListPurchaseAndPR"))
{
Report.Reportx1.Value = new string[4];
Report.Reportx1.Value[0] = dtDate1.Value.Date.ToString("dd/MMM/yyyy");
Report.Reportx1.Value[1] = dtDate2.Value.Date.ToString("dd/MMM/yyyy");
Report.Reportx1.Value[2] = txtPRNo1.Text;
Report.Reportx1.Value[3] = txtPRNo2.Text;
Report.Reportx1.WReport = "ListPurchaseAndPR";
Report.Reportx1 op = new Report.Reportx1("ListPurchaseAndPR.rpt");
op.Show();
}
}
}
catch (Exception ex) { MessageBox.Show(ex.Message); }
}
void PrintE()
{
if (tReport == 0)
{
Report.Reportx1.Value = new string[4];
Report.Reportx1.Value[0] = cbbYY.Text.ToSt();
Report.Reportx1.Value[1] = (cbbMM.SelectedIndex + 1).ToSt();
Report.Reportx1.Value[2] = cbbItem.SelectedValue.ToSt();
Report.Reportx1.Value[3] = cbbCSTM.SelectedValue.ToSt();
Report.Reportx1.WReport = "DeliveryPlanning";
Report.Reportx1 op = new Report.Reportx1("DeliveryPlanning.rpt");
op.Show();
}
else if (tReport == 1)
{
if (cbbMM.SelectedIndex > cbbMM2.SelectedIndex)
{
baseClass.Warning("ไม่สามารถเลือกเดือนเริ่มต้นมากกว่าเดือนสิ้นสุดได้.\n");
return;
}
Report.Reportx1.Value = new string[5];
Report.Reportx1.Value[0] = cbbYY.Text.ToSt();
Report.Reportx1.Value[1] = (cbbMM.SelectedIndex + 1).ToSt();
Report.Reportx1.Value[2] = (cbbMM2.SelectedIndex + 1).ToSt();
Report.Reportx1.Value[3] = cbbItem.SelectedValue.ToSt();
Report.Reportx1.Value[4] = cbbCSTM.SelectedValue.ToSt();
Report.Reportx1.WReport = "DeliveryPlanningMonth";
Report.Reportx1 op = new Report.Reportx1("DeliveryPlanningMonth.rpt");
op.Show();
}
}
private void btn_Print_Barcode_Click(object sender, EventArgs e)
{
try
{
dt_Kanban.Rows.Clear();
using (DataClasses1DataContext db = new DataClasses1DataContext())
{
var g = (from ix in db.tb_Items select ix).Where(a => a.CodeNo == txtPRNo2.Text).ToList();
if (g.Count() > 0)
{
foreach (var gg in g)
{
dt_Kanban.Rows.Add(gg.CodeNo, gg.ItemNo, gg.ItemDescription, gg.ShelfNo, gg.Leadtime, gg.VendorItemName, gg.GroupCode, gg.Toollife, gg.MaximumStock, gg.MinimumStock, gg.ReOrderPoint, gg.BarCode);
}
//DataTable DT = StockControl.dbClss.LINQToDataTable(g);
//Reportx1 po = new Reportx1("Report_PurchaseRequest_Content1.rpt", DT, "FromDT");
//po.Show();
Report.Reportx1 op = new Report.Reportx1("001_Kanban_Part.rpt", dt_Kanban, "FromDL");
op.Show();
}
else
{
MessageBox.Show("not found.");
}
}
}
catch (Exception ex) { MessageBox.Show(ex.Message); }
}
private void btnPrintCost_Click(object sender, EventArgs e)
{
try
{
if (dgvData.Rows.Count <= 0)
{
return;
}
string JobCard = StockControl.dbClss.TSt(dgvData.CurrentRow.Cells["JobCard"].Value);
string TempJobCard = StockControl.dbClss.TSt(dgvData.CurrentRow.Cells["TempJobCard"].Value);
string YYYY = "";
string MM = "";
using (DataClasses1DataContext db = new DataClasses1DataContext())
{
//var g = (from ix in db.sp_R013_Report_Jobcard_Cost(JobCard, TempJobCard, YYYY, MM, Convert.ToDateTime(DateTime.Now, new CultureInfo("en-US"))) select ix).ToList();
//if (g.Count() > 0)
//{
Report.Reportx1.Value = new string[4];
Report.Reportx1.Value[0] = JobCard;
Report.Reportx1.Value[1] = TempJobCard;
Report.Reportx1.Value[2] = YYYY;
Report.Reportx1.Value[3] = MM;
Report.Reportx1.WReport = "JobCard_Cost";
Report.Reportx1 op = new Report.Reportx1("JobCard_Cost3.rpt");
op.Show();
//}
//else
// MessageBox.Show("not found.");
}
}
catch (Exception ex) { MessageBox.Show(ex.Message); }
}
private void radButtonElement5_Click(object sender, EventArgs e)
{
Report.Reportx1.Value = new string[1];
Report.Reportx1.Value[0] = ddlTypePart.Text;
Report.Reportx1.WReport = "ItemList";
Report.Reportx1 op = new Report.Reportx1("ReportItemList.rpt");
op.Show();
}
private void btn_PrintPR_Click_1(object sender, EventArgs e)
{
Report.Reportx1.Value = new string[1];
Report.Reportx1.Value[0] = cbbStatus.Text;
Report.Reportx1.WReport = "CustomerList";
Report.Reportx1 op = new Report.Reportx1("ReportCustomerList.rpt");
op.Show();
}
private void btnImport_Click_1(object sender, EventArgs e)
{
//Report.Reportx1.Value = new string[1];
//Report.Reportx1.Value[0] = "";
Report.Reportx1.WReport = "WorkCenter";
Report.Reportx1 op = new Report.Reportx1("WorkCenterList.rpt");
op.Show();
}
private void btnReport_Click(object sender, EventArgs e)
{
//CustomerList.rpt
Report.Reportx1.Value = new string[1];
Report.Reportx1.Value[0] = "";
Report.Reportx1.WReport = "CustomerList2";
Report.Reportx1 op = new Report.Reportx1("CustomerList.rpt");
op.Show();
}
private void radButtonElement5_Click(object sender, EventArgs e)
{
// string JobNo = dgvData.Rows[dgvData.CurrentCell.RowIndex].Cells["JobNo"].Value.ToSt();
Report.Reportx1.Value = new string[1];
Report.Reportx1.Value[0] = cbbStatus.Text;
Report.Reportx1.WReport = "ProductionList";
Report.Reportx1 op = new Report.Reportx1("ReportProductionList.rpt");
op.Show();
}
private void btn_PrintShelfTag_Click(object sender, EventArgs e)
{
try
{
using (DataClasses1DataContext db = new DataClasses1DataContext())
{
//delete ทิ้งก่อน
var deleteItem = (from ii in db.TempPrintShelfs where ii.UserName == ClassLib.Classlib.User select ii);
foreach (var d in deleteItem)
{
db.TempPrintShelfs.DeleteOnSubmit(d);
db.SubmitChanges();
}
int c = 0;
string CodeNo = "";
radGridView1.EndEdit();
//insert
foreach (var Rowinfo in radGridView1.Rows)
{
if (StockControl.dbClss.TBo(Rowinfo.Cells["S"].Value).Equals(true))
{
CodeNo = StockControl.dbClss.TSt(Rowinfo.Cells["InternalNo"].Value);
var g = (from ix in db.mh_Items select ix).Where(a => a.InternalNo == CodeNo).ToList();
if (g.Count() > 0)
{
c += 1;
TempPrintShelf ps = new TempPrintShelf();
ps.UserName = ClassLib.Classlib.User;
ps.CodeNo = g.FirstOrDefault().InternalNo;
ps.PartDescription = g.FirstOrDefault().InternalDescription;
ps.PartNo = g.FirstOrDefault().InternalName;
ps.ShelfNo = "";// g.FirstOrDefault().ShelfNo;
ps.Max = Convert.ToDecimal(g.FirstOrDefault().MaximumQty);
ps.Min = Convert.ToDecimal(g.FirstOrDefault().MinimumQty);
ps.OrderPoint = Convert.ToDecimal(g.FirstOrDefault().ReorderPoint);
db.TempPrintShelfs.InsertOnSubmit(ps);
db.SubmitChanges();
}
}
}
if (c > 0)
{
Report.Reportx1.Value = new string[2];
Report.Reportx1.Value[0] = ClassLib.Classlib.User;
Report.Reportx1.WReport = "002_BoxShelf_Part";
Report.Reportx1 op = new Report.Reportx1("002_BoxShelf_Part.rpt");
op.Show();
}
else
{
MessageBox.Show("not found.");
}
}
}
catch (Exception ex) { MessageBox.Show(ex.Message); }
}
void PrintE()
{
Report.Reportx1.Value = new string[2];
Report.Reportx1.Value[0] = dtFrom.Value.Date.ToString("dd/MMM/yyyy");
Report.Reportx1.Value[1] = dtTo.Value.Date.ToString("dd/MMM/yyyy");
Report.Reportx1.WReport = "ReceiveAndDelivery";
Report.Reportx1 op = new Report.Reportx1("ReceiveAndDelivery.rpt");
op.Show();
}
private void btnPrint_Click(object sender, EventArgs e)
{
//ReportChangeJob.rpt
string SPNo = txtSPNo.Text.Trim();
if (SPNo != "")
{
Report.Reportx1.Value = new string[1];
Report.Reportx1.Value[0] = SPNo;
Report.Reportx1.WReport = "ReportChangeJob";
Report.Reportx1 op = new Report.Reportx1("ReportChangeJob.rpt");
op.Show();
}
}
private void btn_PrintPR_Click(object sender, EventArgs e)
{
//select Item for Print
//throw new NotImplementedException();
try
{
Report.Reportx1.Value = new string[2];
Report.Reportx1.Value[0] = dgvData.Rows[dgvData.CurrentCell.RowIndex].Cells["ShipmentNo"].Value.ToSt();
Report.Reportx1.Value[1] = dgvData.Rows[dgvData.CurrentCell.RowIndex].Cells["ShipmentNo"].Value.ToSt();
Report.Reportx1.WReport = "Shipment";
Report.Reportx1 op = new Report.Reportx1("ReportDelivery.rpt");
op.Show();
}
catch { }
}
private void radButtonElement1_Click(object sender, EventArgs e)
{
this.Cursor = Cursors.WaitCursor;
try
{
Report.Reportx1.WReport = "StockCard";
Report.Reportx1.Value = new string[2];
Report.Reportx1.Value[0] = "0101100014000";
Report.Reportx1.Value[1] = dbClss.UserID;
Report.Reportx1 op = new Report.Reportx1("StockCard.rpt");
op.Show();
}
catch { }
this.Cursor = Cursors.Default;
}
private void btnView_Click(object sender, EventArgs e)
{
try
{
if (MessageBox.Show("ต้องการออกรายงาน หรือไม่ ?", "ออกรายงาน", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
{
string YYYY = ddlYear.Text;
string MM = ddlMonth.Text;
if (YYYY == "" || MM == "")
{
MessageBox.Show("เลือกปีหรือเดือน !");
return;
}
using (DataClasses1DataContext db = new DataClasses1DataContext())
{
var g = (from ix in db.sp_R020_ConsumableBalance(txtCodeNo.Text
, txtCodeNo.Text, ddlYear.Text, ddlMonth.Text, ddlLocation.Text
, Convert.ToDateTime(DateTime.Now, new CultureInfo("en-US"))
, cboGroupType.Text
, cboTypeCode.Text
) select ix).ToList();
if (g.Count() > 0)
{
Report.Reportx1.Value = new string[7];
Report.Reportx1.Value[0] = txtCodeNo.Text;
Report.Reportx1.Value[1] = txtCodeNo.Text;
Report.Reportx1.Value[2] = ddlYear.Text;
Report.Reportx1.Value[3] = ddlMonth.Text;
Report.Reportx1.Value[4] = ddlLocation.Text;
Report.Reportx1.Value[5] = cboGroupType.Text;
Report.Reportx1.Value[6] = cboTypeCode.Text;
Report.Reportx1.WReport = "ReportConsumableBalance";
Report.Reportx1 op = new Report.Reportx1("ReportConsumableBalance.rpt");
op.Show();
}
else
{
MessageBox.Show("not found.");
}
}
}
}catch (Exception ex) { MessageBox.Show(ex.Message); }
}
private void btn_PrintPR_Click(object sender, EventArgs e)
{
//select Item for Print
//throw new NotImplementedException();
if (dgvData.CurrentCell == null)
{
return;
}
if (dgvData.CurrentCell.RowIndex >= 0)
{
string JobNo = dgvData.Rows[dgvData.CurrentCell.RowIndex].Cells["JobNo"].Value.ToSt();
Report.Reportx1.Value = new string[1];
Report.Reportx1.Value[0] = JobNo;
Report.Reportx1.WReport = "JOBNoList";
Report.Reportx1 op = new Report.Reportx1("JobOrderSheet3.rpt");
op.Show();
}
}
private void btnPrintReport_Click(object sender, EventArgs e)
{
try
{
string ListNo = txtListNo.Text.Trim();
//if (ListNo != "")
//{
Report.Reportx1.Value = new string[1];
Report.Reportx1.Value[0] = ListNo;
Report.Reportx1.WReport = "CheckStockList";
Report.Reportx1 op = new Report.Reportx1("ReportCheckStock.rpt");
op.Show();
//}
}
catch (Exception ex)
{
baseClass.Error(ex.Message);
}
}
private void btn_PrintPR_Click(object sender, EventArgs e)
{
//select Item for Print
//throw new NotImplementedException();
try
{
if (dgvData.CurrentCell.RowIndex >= 0)
{
string InvNo = dgvData.Rows[dgvData.CurrentCell.RowIndex].Cells["IVNo"].Value.ToSt();
Report.Reportx1.Value = new string[2];
Report.Reportx1.Value[0] = InvNo;
Report.Reportx1.Value[1] = InvNo;
Report.Reportx1.WReport = "Invoice";
Report.Reportx1 op = new Report.Reportx1("InvoiceDot.rpt");
op.Show();
}
}
catch { }
}
private void btnPrint_Click(object sender, EventArgs e)
{
try
{
string AdNo1 = "";
string AdNo2 = "";
if (dgvData.Rows.Count > 0)
{
AdNo1 = Convert.ToString(dgvData.CurrentRow.Cells["ADNo"].Value);
AdNo2 = Convert.ToString(dgvData.CurrentRow.Cells["ADNo"].Value);
}
Report.Reportx1.Value = new string[1];
Report.Reportx1.Value[0] = AdNo1;
Report.Reportx1.WReport = "ALLReport";
Report.Reportx1 op = new Report.Reportx1("ReportReturnRM.rpt");
op.Show();
//PrintPR a = new PrintPR(AdNo1, AdNo2, "AdjustStock");
//a.ShowDialog();
//using (DataClasses1DataContext db = new DataClasses1DataContext())
//{
// var g = (from ix in db.sp_R004_ReportShipping(txtSHNo.Text, DateTime.Now) select ix).ToList();
// if (g.Count() > 0)
// {
// Report.Reportx1.Value = new string[2];
// Report.Reportx1.Value[0] = txtSHNo.Text;
// Report.Reportx1.WReport = "ReportShipping";
// Report.Reportx1 op = new Report.Reportx1("ReportShipping.rpt");
// op.Show();
// }
// else
// MessageBox.Show("not found.");
//}
}
catch (Exception ex) { MessageBox.Show(ex.Message); }
}
private void btn_PrintPR_Click(object sender, EventArgs e)
{
//select Item for Print
//throw new NotImplementedException();
try
{
if (dgvData.CurrentCell != null)
{
var row = dgvData.CurrentCell.RowInfo;
Report.Reportx1.Value = new string[2];
Report.Reportx1.Value[0] = row.Cells["SONo"].Value.ToSt();
Report.Reportx1.Value[1] = row.Cells["SONo"].Value.ToSt();
Report.Reportx1.WReport = "SaleOrder";
Report.Reportx1 op = new Report.Reportx1("CustomerPO.rpt");
op.Show();
}
}
catch (Exception ex) { baseClass.Error(ex.Message); }
}
private void btn_PrintPR_Click(object sender, EventArgs e)
{
try
{
string BomNo = "";
string PartNo = "";
if (radGridView1.Rows.Count <= 0)
{
return;
}
BomNo = StockControl.dbClss.TSt(radGridView1.CurrentRow.Cells["BomNo"].Value);
PartNo = StockControl.dbClss.TSt(radGridView1.CurrentRow.Cells["PartNo"].Value);
using (DataClasses1DataContext db = new DataClasses1DataContext())
{
var g = (from ix in db.sp_R015_Report_Bom(PartNo, BomNo, "", "", Convert.ToDateTime(DateTime.Now, new CultureInfo("en-US"))) select ix).ToList();
if (g.Count() > 0)
{
Report.Reportx1.Value = new string[4];
Report.Reportx1.Value[0] = PartNo;
Report.Reportx1.Value[1] = BomNo;
Report.Reportx1.Value[2] = "";
Report.Reportx1.Value[3] = "";
Report.Reportx1.WReport = "Bom";
Report.Reportx1 op = new Report.Reportx1("Bom.rpt");
op.Show();
}
else
{
MessageBox.Show("not found.");
}
}
}
catch (Exception ex) { MessageBox.Show(ex.Message); }
}
private void PrintSignature(string User1)
{
string User = User1;
string Pass = "";
string Rpt = "Signature.rpt";
Report.Reportx1.WReport = "Signature";
Report.Reportx1.Value = new string[2];
Report.Reportx1.Value[0] = User;
Report.Reportx1.Value[1] = Pass;
Report.Reportx1 op = new Report.Reportx1(Rpt);//Rpt,Dt,PUR_TravellingReq
op.Show();
//Report.Reportx1.Value = new string[4];
//Report.Reportx1.Value[0] = PartNo;
//Report.Reportx1.Value[1] = BomNo;
//Report.Reportx1.Value[2] = "";
//Report.Reportx1.Value[3] = "";
//Report.Reportx1.WReport = "Bom";
//Report.Reportx1 op = new Report.Reportx1("Bom.rpt");
//op.Show();
}
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;
}
private void btn_PrintPR_Click(object sender, EventArgs e)
{
try
{
//dt_ShelfTag.Rows.Clear();
string PRNo1 = txtPRNo1.Text;
string PRNo2 = txtPRNo2.Text;
using (DataClasses1DataContext db = new DataClasses1DataContext())
{
if (Type.Equals("PR"))
{
var g = (from ix in db.sp_R005_ReportPR(PRNo1, PRNo2, Convert.ToDateTime(DateTime.Now, new CultureInfo("en-US"))) select ix).ToList();
if (g.Count() > 0)
{
Report.Reportx1.Value = new string[2];
Report.Reportx1.Value[0] = PRNo1;
Report.Reportx1.Value[1] = PRNo2;
Report.Reportx1.WReport = "PR";
Report.Reportx1 op = new Report.Reportx1("PR.rpt");
op.Show();
}
else
{
MessageBox.Show("not found.");
}
}
if (Type.Equals("PO"))
{
var g = (from ix in db.sp_R011_ReportPO(PRNo1, PRNo2, Convert.ToDateTime(DateTime.Now, new CultureInfo("en-US"))) select ix).ToList();
if (g.Count() > 0)
{
Report.Reportx1.Value = new string[2];
Report.Reportx1.Value[0] = PRNo1;
Report.Reportx1.Value[1] = PRNo2;
Report.Reportx1.WReport = "PO";
Report.Reportx1 op = new Report.Reportx1("PO.rpt");
op.Show();
}
else
{
MessageBox.Show("not found.");
}
}
else if (Type.Equals("Receive"))
{
//var g = (from ix in db.sp_R006_ReportReceive(PRNo1, PRNo2, Convert.ToDateTime(DateTime.Now, new CultureInfo("en-US"))) select ix).ToList();
//if (g.Count() > 0)
//{
Report.Reportx1.Value = new string[2];
Report.Reportx1.Value[0] = PRNo1;
Report.Reportx1.Value[1] = PRNo2;
Report.Reportx1.WReport = "ReportReceive2";
Report.Reportx1 op = new Report.Reportx1("ReportReceive2.rpt");
op.Show();
//}
//else
// MessageBox.Show("not found.");
}
else if (Type.Equals("Shipping"))
{
//var g = (from ix in db.sp_R007_ReportShipping(PRNo1, PRNo2, Convert.ToDateTime(DateTime.Now, new CultureInfo("en-US"))) select ix).ToList();
//if (g.Count() > 0)
//{
Report.Reportx1.Value = new string[2];
Report.Reportx1.Value[0] = PRNo1;
Report.Reportx1.Value[1] = PRNo2;
Report.Reportx1.WReport = "ReportShipping2";
//Report.Reportx1 op = new Report.Reportx1("ReportShipping2.rpt");
Report.Reportx1 op = new Report.Reportx1("ReportShipping2.rpt");
op.Show();
//}
//else
// MessageBox.Show("not found.");
}
else if (Type.Equals("ShippingToDay"))
{
string dt1 = "";
string dt2 = "";
if (cbDate.Checked)
{
// Convert.ToDateTime(DateTime.Now, new CultureInfo("en-US"))
dt1 = Convert.ToDateTime((dtDate1.Value), new CultureInfo("en-US")).ToString("yyyyMMdd");
dt2 = Convert.ToDateTime((dtDate2.Value), new CultureInfo("en-US")).ToString("yyyyMMdd");
}
var g = (from ix in db.sp_R021_ReportShipping_Today(PRNo1, PRNo2, dt1, dt2, Convert.ToDateTime(DateTime.Now, new CultureInfo("en-US"))) select ix).ToList();
if (g.Count() > 0)
{
Report.Reportx1.Value = new string[4];
Report.Reportx1.Value[0] = PRNo1;
Report.Reportx1.Value[1] = PRNo2;
Report.Reportx1.Value[2] = dt1;
Report.Reportx1.Value[3] = dt2;
Report.Reportx1.WReport = "ReportShippingToDay";
//Report.Reportx1 op = new Report.Reportx1("ReportShipping2.rpt");
Report.Reportx1 op = new Report.Reportx1("ReportShippingToDay.rpt");
op.Show();
}
else
{
MessageBox.Show("not found.");
}
}
else if (Type.Equals("AdjustStock"))
{
//var g = (from ix in db.sp_R008_ReportAdjustStock(PRNo1, PRNo2, Convert.ToDateTime(DateTime.Now, new CultureInfo("en-US"))) select ix).ToList();
//if (g.Count() > 0)
//{
Report.Reportx1.Value = new string[2];
Report.Reportx1.Value[0] = PRNo1;
Report.Reportx1.Value[1] = PRNo2;
Report.Reportx1.WReport = "ReportAdjustStock";
Report.Reportx1 op = new Report.Reportx1("ReportAdjustStock.rpt");
op.Show();
//}
//else
// MessageBox.Show("not found.");
}
else if (Type.Equals("JobCard"))
{
//var g = (from ix in db.sp_R010_Report_JobCard(PRNo1, PRNo2, Convert.ToDateTime(DateTime.Now, new CultureInfo("en-US"))) select ix).ToList();
//if (g.Count() > 0)
//{
Report.Reportx1.Value = new string[2];
Report.Reportx1.Value[0] = PRNo1;
Report.Reportx1.Value[1] = PRNo2;
Report.Reportx1.WReport = "JobCard";
Report.Reportx1 op = new Report.Reportx1("JobCard.rpt");
op.Show();
//}
//else
// MessageBox.Show("not found.");
}
else if (Type.Equals("ReportStockMovement"))
{
string dt1 = "";
string dt2 = "";
if (cbDate.Checked)
{
// Convert.ToDateTime(DateTime.Now, new CultureInfo("en-US"))
dt1 = Convert.ToDateTime((dtDate1.Value), new CultureInfo("en-US")).ToString("yyyyMMdd");
dt2 = Convert.ToDateTime((dtDate2.Value), new CultureInfo("en-US")).ToString("yyyyMMdd");
}
//var g = (from ix in db.sp_R009_Stock_Movement(PRNo1, PRNo2,dt1,dt2,ddlLocation.Text, Convert.ToDateTime(DateTime.Now, new CultureInfo("en-US"))) select ix).ToList();
//if (g.Count() > 0)
//{
Report.Reportx1.Value = new string[5];
Report.Reportx1.Value[0] = PRNo1;
Report.Reportx1.Value[1] = PRNo2;
Report.Reportx1.Value[2] = dt1;
Report.Reportx1.Value[3] = dt2;
Report.Reportx1.Value[4] = ddlLocation.Text;
Report.Reportx1.WReport = "ReportStockMovement";
Report.Reportx1 op = new Report.Reportx1("ReportStockMovement.rpt");
op.Show();
//}
//else
// MessageBox.Show("not found.");
}
else if (Type.Equals("ReportStockCard"))
{
string dt1 = "";
string dt2 = "";
if (cbDate.Checked)
{
// Convert.ToDateTime(DateTime.Now, new CultureInfo("en-US"))
dt1 = Convert.ToDateTime((dtDate1.Value), new CultureInfo("en-US")).ToString("yyyyMMdd");
dt2 = Convert.ToDateTime((dtDate2.Value), new CultureInfo("en-US")).ToString("yyyyMMdd");
}
ddlLocation.Text = "Warehouse";
//clear user
var del = db.mh_StockCards.Where(x => x.USERID == ClassLib.Classlib.User).ToList();
db.mh_StockCards.DeleteAllOnSubmit(del);
db.SubmitChanges();
var stBefore = db.sp_getStockBefore(PR1, ddlLocation.Text, dtDate1.Value.Date);
var rem = stBefore.ToDecimal();
var tool = db.mh_Items.Where(x => x.InternalNo == PR1).FirstOrDefault();
if (tool == null)
{
baseClass.Error("ไม่พบทูล");
return;
}
var tooluom = db.mh_ItemUOMs.Where(x => x.UOMCode == tool.BaseUOM && x.ItemNo == tool.InternalNo).FirstOrDefault();
var pcsunit = 1.00m;
if (tooluom != null)
{
pcsunit = tooluom.QuantityPer;
}
int rNo = 1;
var scard = new mh_StockCard
{
ItemNo = PR1,
ItemName = tool.InternalName,
dFrom = dtDate1.Value.Date,
dTo = dtDate2.Value.Date,
DocumentRef = "ยอดยกมา",
Location = ddlLocation.Text,
No = rNo,
UOM = tool.BaseUOM,
USERID = ClassLib.Classlib.User,
Shelf = tool.ShelfNo,
SubCust = "",
PCSUnit = pcsunit,
Date = dtDate1.Value.Date,
StartQty = rem,
InQty = 0,
OutQty = 0,
RemainQty = rem,
};
db.mh_StockCards.InsertOnSubmit(scard);
db.SubmitChanges();
DateTime?dFrom = (cbDate.Checked) ? (DateTime?)dtDate1.Value.Date : null;
DateTime?dTo = (cbDate.Checked) ? (DateTime?)dtDate2.Value.Date.AddDays(1).AddMinutes(-1) : null;
var st = db.tb_Stocks.Where(x => x.CodeNo == PRNo1 &&
(dFrom == null || (x.CreateDate >= dFrom && x.CreateDate <= dTo)) &&
x.Location == ddlLocation.Text
).OrderBy(x => x.CreateDate).ToList();
foreach (var s in st)
{
string refNo = s.DocNo;
bool findCustFromJob = false;
string custNo = "";
string custName = "";
rNo++;
string sName = "";
if (s.DocNo.ToSt().Length > 2)
{
if (s.DocNo.ToSt().Substring(0, 2) == "RC")
{
//receive
var po = db.mh_PurchaseOrders.Where(x => x.PONo == s.RefNo).FirstOrDefault();
if (po != null)
{
sName = po.VendorName.ToSt();
}
//Recieve from invoice
var rc = db.tb_ReceiveHs.Where(x => x.RCNo == s.DocNo).FirstOrDefault();
if (rc != null)
{
refNo = rc.InvoiceNo;
}
}
else if (s.DocNo.ToSt().Substring(0, 2) == "PK") //recive job
{
refNo = s.RefNo;
findCustFromJob = true;
}
else if ((s.DocNo.ToSt().Substring(0, 2) == "SH") &&
s.DocNo.ToSt().Substring(2, 1).ToInt() == 0) //Ship not normal
{
refNo = s.RefJobCode;
findCustFromJob = true;
if (s.DocNo.ToSt().Substring(0, 4) == "SHAS")
{
var acc = db.mh_Accident_SlipHs.Where(x => x.DocNo == s.RefJobCode).FirstOrDefault();
if (acc != null)
{
refNo = acc.JobCard;
}
}
}
else if (s.DocNo.ToSt().Substring(0, 2) == "RT") //Return RM
{
refNo = s.RefJobCode;
findCustFromJob = true;
}
else if (s.DocNo.ToSt().Substring(0, 2) == "SE") //Shipment Shipping
{
refNo = s.DocNo;
var sm = db.mh_Shipments.Where(x => x.SSNo == s.RefJobCode).FirstOrDefault();
if (sm != null)
{
refNo = sm.SSNo;
sName = sm.CustomerName;
//ถ้า Shipment ออก Invoice แล้ว ให้เอา
var inv = db.mh_InvoiceDTs.Where(x => x.RefId == sm.id && x.Active)
.Join(db.mh_InvoiceHDs.Where(x => x.Active)
, dt => dt.IVNo
, hd => hd.IVNo
, (dt, hd) => new { hd, dt }).FirstOrDefault();
if (inv != null)
{
refNo = inv.hd.IVNo;
sName = inv.hd.CustomerName;
}
}
}
}
if (findCustFromJob)
{
var pd = db.mh_ProductionOrders.Where(x => x.JobNo == refNo).FirstOrDefault();
if (pd != null)
{
var so = db.mh_SaleOrderDTs.Where(x => x.id == pd.RefDocId)
.Join(db.mh_SaleOrders
, dt => dt.SONo
, hd => hd.SONo
, (dt, hd) => new { hd, dt }).ToList();
if (so.Count > 0)
{
sName = so.FirstOrDefault().hd.CustomerName;
}
}
}
var startQ = rem;
var inQ = 0.00m;
var outQ = 0.00m;
if (s.Type_in_out == "In")
{
inQ = s.QTY.ToDecimal();
}
else
{
outQ = s.QTY.ToDecimal();
}
rem = startQ + inQ + outQ;
var sc = new mh_StockCard
{
ItemNo = PR1,
ItemName = tool.InternalName,
dFrom = dtDate1.Value.Date,
dTo = dtDate2.Value.Date,
DocumentRef = refNo,
Location = ddlLocation.Text,
No = rNo,
UOM = tool.BaseUOM,
USERID = ClassLib.Classlib.User,
Shelf = tool.ShelfNo,
SubCust = sName,
PCSUnit = pcsunit,
Date = s.CreateDate,
StartQty = startQ,
InQty = inQ,
OutQty = outQ,
RemainQty = rem,
CustNo = custNo,
CustName = custName,
};
db.mh_StockCards.InsertOnSubmit(sc);
db.SubmitChanges();
}
//var g = (from ix in db.sp_R009_Stock_Movement(PRNo1, PRNo2,dt1,dt2,ddlLocation.Text, Convert.ToDateTime(DateTime.Now, new CultureInfo("en-US"))) select ix).ToList();
//if (g.Count() > 0)
//{
Report.Reportx1.Value = new string[1];
Report.Reportx1.Value[0] = ClassLib.Classlib.User;
Report.Reportx1.WReport = "ReportStockCard";
Report.Reportx1 op = new Report.Reportx1("StockCard.rpt");
op.Show();
//}
//else
// MessageBox.Show("not found.");
}
else if (Type.Equals("Claim"))
{
//var g = (from ix in db.sp_R017_ReportClaim(PRNo1, PRNo2, Convert.ToDateTime(DateTime.Now, new CultureInfo("en-US"))) select ix).ToList();
//if (g.Count() > 0)
//{
Report.Reportx1.Value = new string[2];
Report.Reportx1.Value[0] = PRNo1;
Report.Reportx1.Value[1] = PRNo2;
Report.Reportx1.WReport = "ReportClaim";
Report.Reportx1 op = new Report.Reportx1("ReportClaim.rpt");
op.Show();
//}
//else
// MessageBox.Show("not found.");
}
else if (Type.Equals("SellFG"))
{
var g = (from ix in db.sp_R018_ReportSellFG(PRNo1, PRNo2, Convert.ToDateTime(DateTime.Now, new CultureInfo("en-US"))) select ix).ToList();
if (g.Count() > 0)
{
Report.Reportx1.Value = new string[2];
Report.Reportx1.Value[0] = PRNo1;
Report.Reportx1.Value[1] = PRNo2;
Report.Reportx1.WReport = "ReportSellFG";
Report.Reportx1 op = new Report.Reportx1("ReportSellFG.rpt");
op.Show();
}
else
{
MessageBox.Show("not found.");
}
}
else if (Type.Equals("ShippingAVG"))
{
string YYYY = "";
string MM = "";
if (cbYYYYMM.Checked)
{
if ((ddlYear.Text != "" && ddlMonth.Text == "") ||
(ddlYear.Text == "" && ddlMonth.Text != ""))
{
//err += "- “เลขที่ PR:” เป็นค่าว่าง \n";
MessageBox.Show("- “กรณีที่ระบุ ปีหรือเดือน ต้องห้ามเป็นค่าว่าง”");
return;
}
YYYY = ddlYear.Text;
MM = ddlMonth.Text;
}
//var g = (from ix in db.sp_R019_ReportShippingAVG(YYYY,MM,PRNo1, PRNo2, Convert.ToDateTime(DateTime.Now, new CultureInfo("en-US"))) select ix).ToList();
//if (g.Count() > 0)
//{
Report.Reportx1.Value = new string[4];
Report.Reportx1.Value[0] = ddlYear.Text;
Report.Reportx1.Value[1] = ddlMonth.Text;
Report.Reportx1.Value[2] = PRNo1;
Report.Reportx1.Value[3] = PRNo2;
Report.Reportx1.WReport = "ReportShippingAVG";
Report.Reportx1 op = new Report.Reportx1("ReportShippingAVG.rpt");
op.Show();
//}
//else
// MessageBox.Show("not found.");
}
else if (Type.Equals("ReportProductionOrder"))
{
string Dt1 = "";
string Dt2 = "";
//var g = (from ix in db.sp_R022_ReportProductsOrder(PRNo1, PRNo2, Dt1, Dt2, Convert.ToDateTime(DateTime.Now, new CultureInfo("en-US"))) select ix).ToList();
//if (g.Count() > 0)
//{
Report.Reportx1.Value = new string[4];
Report.Reportx1.Value[0] = PRNo1;
Report.Reportx1.Value[1] = PRNo2;
Report.Reportx1.Value[2] = Dt1;
Report.Reportx1.Value[3] = Dt2;
Report.Reportx1.WReport = "ReporProductionOrder";
Report.Reportx1 op = new Report.Reportx1("ReporProductionOrder.rpt");
op.Show();
//}
//else
// MessageBox.Show("not found.");
}
else if (Type.Equals("ReportAccidentSlip"))
{
////string Dt1 = "";
////string Dt2 = "";
//var g = (from ix in db.sp_R007_ReportShipping(PRNo1, PRNo2, Convert.ToDateTime(DateTime.Now, new CultureInfo("en-US"))) select ix).ToList();
//if (g.Count() > 0)
//{
Report.Reportx1.Value = new string[2];
Report.Reportx1.Value[0] = PRNo1;
Report.Reportx1.Value[1] = PRNo2;
Report.Reportx1.WReport = "ReportAccidentSlip";
Report.Reportx1 op = new Report.Reportx1("ReportAccidentSlip.rpt");
op.Show();
//}
//else
// MessageBox.Show("not found.");
}
else if (Type.Equals("PackingList"))
{
Report.Reportx1.Value = new string[2];
Report.Reportx1.Value[0] = dtDate1.Value.Date.ToString("dd/MMM/yyyy");
Report.Reportx1.Value[1] = dtDate2.Value.Date.ToString("dd/MMM/yyyy");
Report.Reportx1.WReport = "PackingList";
Report.Reportx1 op = new Report.Reportx1("ReceiveFG.rpt");
op.Show();
}
else if (Type.Equals("ListPurchaseAndPR"))
{
Report.Reportx1.Value = new string[2];
Report.Reportx1.Value[0] = dtDate1.Value.Date.ToString("dd/MMM/yyyy");
Report.Reportx1.Value[1] = dtDate2.Value.Date.ToString("dd/MMM/yyyy");
Report.Reportx1.WReport = "ListPurchaseAndPR";
Report.Reportx1 op = new Report.Reportx1("ListPurchaseAndPR.rpt");
op.Show();
}
}
}
catch (Exception ex) { MessageBox.Show(ex.Message); }
}
private void btnExport_Click(object sender, EventArgs e)
{
//Print TAG//
try
{
this.Cursor = Cursors.WaitCursor;
int Qty = 0;
int snp = 1;
int TAG = 0;
int a = 0;
double ap = 0;
int Remain = 0;
int.TryParse(txtQty.Text, out Qty);
int.TryParse(txtsNP.Text, out snp);
string OfTAG = "";
string QrCode = "";
if (Qty > 0)
{
// string TMNo = dbClss.GetSeriesNo(2, 2);
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;
}
int C = 0;
string ImagePath = "";
string ImageName = "";
using (DataClasses1DataContext db = new DataClasses1DataContext())
{
tb_Path ph = db.tb_Paths.Where(p => p.PathCode == "Image").First();
if (ph != null)
{
ImagePath = ph.PathFile;
}
tb_ItemList il = db.tb_ItemLists.Where(i => i.CodeNo == txtPartNo.Text).FirstOrDefault();
if (il != null)
{
ImageName = il.PathImage;
}
var tm = db.tb_ProductTAGs.Where(t => t.UserID.ToLower() == dbClss.UserID.ToLower()).ToList();
if (tm.Count > 0)
{
db.tb_ProductTAGs.DeleteAllOnSubmit(tm);
db.SubmitChanges();
}
for (int i = 1; i <= TAG; i++)
{
OfTAG = "";
QrCode = "";
if (Remain > snp)
{
Qty = snp;
Remain = Remain - snp;
}
else
{
Qty = Remain;
Remain = 0;
}
OfTAG = i + "of" + TAG;
QrCode = "";
QrCode = "PD," + txtBomNo.Text + "," + Qty + "," + snp + "," + txtLotNo.Text + "," + OfTAG + "," + txtPartNo.Text;
//MessageBox.Show(QrCode);
byte[] barcode = dbClss.SaveQRCode2D(QrCode);
///////////////////////////////
tb_ProductTAG ts = new tb_ProductTAG();
ts.UserID = dbClss.UserID;
ts.BOMNo = txtBomNo.Text;
ts.LotNo = txtLotNo.Text;
// ts. = dtDate1.Value.ToString("dd/MM/yyyy");
ts.QRCode = barcode;
ts.PartName = txtPartName.Text;
ts.PartNo = txtPartNo.Text;
ts.Machine = Environment.MachineName;
ts.OFTAG = i + "/" + TAG;
if (!ImageName.Equals(""))
{
ts.PathPic = ImagePath + ImageName;
}
else
{
ts.PathPic = "";
}
ts.Qty = Qty;
ts.Seq = i;
ts.CSTMShot = txtCustomerShortName.Text;
ts.CustomerName = txtCustomerName.Text;
ts.CSTMItem = txtCustItemNo.Text;
ts.CustItem2 = txtCustItemName.Text;
//ts.s = snp;
// ts.Company = "Nabtesco Autmotive Corporation";
//ts.Quantity = Qty;
// ts.OfTAG = i + " / " + TAG;
///////////////////////////////////////////////
db.tb_ProductTAGs.InsertOnSubmit(ts);
db.SubmitChanges();
C += 1;
}
}
if (txtAC.Text == "")
{
txtAC.Text = "1";
}
Report.Reportx1.WReport = "PDTAG";
Report.Reportx1.Value = new string[3];
Report.Reportx1.Value[0] = txtBomNo.Text;
Report.Reportx1.Value[1] = dbClss.UserID;
// Report.Reportx1.Value[2] = txtAC.Text;
Report.Reportx1 op = new Report.Reportx1("FG_TAG.rpt");
op.Show();
}
else
{
MessageBox.Show("Qty invalid!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); }
this.Cursor = Cursors.Default;
}
private void btn_Print_Barcode_Click(object sender, EventArgs e)
{
try
{
dt_Kanban.Rows.Clear();
this.Cursor = Cursors.WaitCursor;
using (DataClasses1DataContext db = new DataClasses1DataContext())
{
// Step 1 delete UserName
var deleteItem = (from ii in db.TempPrintKanbans where ii.UserName == ClassLib.Classlib.User select ii);
foreach (var d in deleteItem)
{
db.TempPrintKanbans.DeleteOnSubmit(d);
db.SubmitChanges();
}
// Step 2 Insert to Table
int c = 0;
string CodeNo = "";
radGridView1.EndEdit();
//insert
foreach (var Rowinfo in radGridView1.Rows)
{
if (StockControl.dbClss.TBo(Rowinfo.Cells["S"].Value).Equals(true))
{
CodeNo = StockControl.dbClss.TSt(Rowinfo.Cells["InternalNo"].Value);
var g = (from ix in db.mh_Items select ix).Where(a => a.InternalNo == CodeNo).ToList();
if (g.Count() > 0)
{
c += 1;
TempPrintKanban tm = new TempPrintKanban();
tm.UserName = ClassLib.Classlib.User;
tm.CodeNo = g.FirstOrDefault().InternalNo;
tm.PartDescription = g.FirstOrDefault().InternalDescription;
tm.PartNo = g.FirstOrDefault().InternalName;
tm.VendorName = g.FirstOrDefault().VendorName;
tm.ShelfNo = "";// g.FirstOrDefault().ShelfNo;
tm.GroupType = g.FirstOrDefault().GroupType;
tm.Max = Convert.ToDecimal(g.FirstOrDefault().MaximumQty);
tm.Min = Convert.ToDecimal(g.FirstOrDefault().MinimumQty);
tm.ReOrderPoint = Convert.ToDecimal(g.FirstOrDefault().ReorderPoint);
tm.ToolLife = 1;// Convert.ToDecimal(g.FirstOrDefault().Toollife);
tm.Location = g.FirstOrDefault().Location;
tm.TypePart = g.FirstOrDefault().InventoryGroup;
byte[] barcode = StockControl.dbClss.SaveQRCode2D(g.FirstOrDefault().InternalNo);
tm.BarCode = barcode;
db.TempPrintKanbans.InsertOnSubmit(tm);
db.SubmitChanges();
this.Cursor = Cursors.Default;
}
}
}
if (c > 0)
{
Report.Reportx1.Value = new string[2];
Report.Reportx1.Value[0] = ClassLib.Classlib.User;
Report.Reportx1.WReport = "001_Kanban_Part";
Report.Reportx1 op = new Report.Reportx1("001_Kanban_Part.rpt");
op.Show();
}
else
{
MessageBox.Show("not found.");
}
}
}
catch (Exception ex) { MessageBox.Show(ex.Message); }
this.Cursor = Cursors.Default;
}
private void btn_PrintPR_Click(object sender, EventArgs e)
{
try
{
//dt_ShelfTag.Rows.Clear();
string ApproveDocuNo = "";
if (radGridView1.Rows.Count > 0)
{
ApproveDocuNo = StockControl.dbClss.TSt(radGridView1.CurrentRow.Cells["ApproveDocuNo"].Value);
string Type = dbClss.TSt(radGridView1.CurrentRow.Cells["ApproveType"].Value);
if (Type == "Purchase Order")
{
//PrintPR a = new PrintPR(ApproveDocuNo, ApproveDocuNo, "PO");
//a.ShowDialog();
Report.Reportx1.Value = new string[2];
Report.Reportx1.Value[0] = ApproveDocuNo;
Report.Reportx1.Value[1] = ApproveDocuNo;
Report.Reportx1.WReport = "PO";
Report.Reportx1 op = new Report.Reportx1("PO.rpt");
op.Show();
}
else if (Type == "Job Req")
{
Report.Reportx1.Value = new string[1];
Report.Reportx1.Value[0] = ApproveDocuNo;
Report.Reportx1.WReport = "JOBNoList";
Report.Reportx1 op = new Report.Reportx1("JobOrderSheet3.rpt");
op.Show();
}
else if (Type == "Sale Order")
{
//PrintPR a = new PrintPR(ApproveDocuNo, ApproveDocuNo, "PR");
//a.ShowDialog();
Report.Reportx1.Value = new string[2];
Report.Reportx1.Value[0] = ApproveDocuNo;
Report.Reportx1.Value[1] = ApproveDocuNo;
Report.Reportx1.WReport = "SaleOrder";
Report.Reportx1 op = new Report.Reportx1("CustomerPO.rpt");
op.Show();
}
else if (Type == "Taking Stock")
{
Report.Reportx1.Value = new string[1];
Report.Reportx1.Value[0] = ApproveDocuNo;
Report.Reportx1.WReport = "CheckStockList";
Report.Reportx1 op = new Report.Reportx1("ReportCheckStock.rpt");
op.Show();
}
else if (Type == "Job Cancel" || Type == "Change Job")
{
Report.Reportx1.Value = new string[1];
Report.Reportx1.Value[0] = ApproveDocuNo;
Report.Reportx1.WReport = "ReportChangeJob";
Report.Reportx1 op = new Report.Reportx1("ReportChangeJob.rpt");
op.Show();
}
else if (Type == "Price List")
{
using (var db = new DataClasses1DataContext())
{
var m = db.mh_PriceLists.Where(x => x.PriceListCode == ApproveDocuNo).FirstOrDefault();
if (m != null)
{
if (m.AttachFile.ToSt() != "")
{
try
{
System.Diagnostics.Process.Start(Path.Combine(baseClass.GetPathServer(PathCode.PriceList), m.AttachFile));
}
catch (Exception ex)
{
baseClass.Error(ex.Message);
}
}
else
{
baseClass.Warning("ไม่มีไฟล์แนบ.");
}
}
else
{
baseClass.Warning("ไม่พบเลขที่เอกสาร.");
}
}
}
}
}
catch (Exception ex) { MessageBox.Show(ex.Message); }
}
