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 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 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 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); } }
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 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 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 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 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 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 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 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 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); } }
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 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("Movement_InOut.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("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."); } } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
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; }