protected bool Check_Bom(string Parent, string Child) { Message msg = new Message(g_user_id, g_lang); MfgBom bom = new MfgBom(g_user_id, g_lang); DataSet ds = new DataSet(); if (Parent == Child) { lblMsg.Text = msg.GetMessage("PARENT_AND_CHILD_SAME"); lblMsg.ForeColor = Color.Red; return(false); } return(true); }
/// <summary> /// 明細削除ボタン /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnDET_DEL_Click(object sender, EventArgs e) { ComLibrary com = new ComLibrary(); Message msg = new Message(g_user_id, g_lang); //Location loc = new Location(g_user_id, g_lang); MfgBom Mfb = new MfgBom(g_user_id, g_lang); if (txtSequent.Text.Trim() == "") { lblMsg.Text = msg.GetMessage("INPUT_MANDATORY_ERR") + "(" + flblSequent.Text + ")"; lblMsg.ForeColor = Color.Red; return; } // 削除 //loc.whs_cd = hdnITEM_NO.Value; //loc.location = hdnSequent.Value; //loc.chg_pgm = "MstLocationMnt"; Mfb.data_char1 = txtBOM_No.Text; Mfb.data_num1 = com.StringToInt(txtBOM_Level.Text); Mfb.data_num2 = com.StringToInt(txtBOM_Sub_Level.Text); Mfb.parent_item_no = hdnITEM_NO.Value; Mfb.part_seq = com.StringToInt(hdnSequent.Value); Mfb.child_item_no = hdnChild_Item.Value; /*int rtn = loc.Delete(); * if (rtn != ComConst.SUCCEED) * { * lblMsg.Text = loc.strErr; * lblMsg.ForeColor = Color.Red; * return; * }*/ int rtn = Mfb.Delete(); if (rtn == ComConst.FAILED) { lblMsg.Text = Mfb.strErr; lblMsg.ForeColor = Color.Red; return; } if (dgvDetail.Rows.Count <= 1) { dgvDetail.PageIndex = 0; } Edit_Screen(); }
private static UserBomTableRow Convert(MfgBom.Bom.Part part) { return new UserBomTableRow() { Description = part.Description, Manufacturer = part.Manufacturer, ManufacturerPartNumber = part.ManufacturerPartNumber, Notes = part.Notes, Package = part.Package, Quantity = part.quantity, ReferenceDesignators = String.Join(", " + Environment.NewLine, part.instances_in_design .Select(ci => ci.path)), Supplier1 = part.SelectedSupplierName, Supplier1PartNumber = part.SelectedSupplierSku, Supplier1UnitPrice = part.SelectedSupplierPartCostPerUnit }; }
protected void cmdPrint_Click(object sender, EventArgs e) { // // 製造指示表リスト発行 // ComLibrary com = new ComLibrary(); Message msg = new Message(g_user_id, g_lang); MfgBom mbom = new MfgBom(g_user_id, g_lang); DataTable dt = (DataTable)(ViewState["gdvDetail"]); if (dt == null) { return; } bool print_flag = false; //int seqno = 0; //Print Data DataTable prtDt = new DataTable(); //SubReport Data //DataTable prtDtTotal = new DataTable(); // 対象の行を探す for (int i = 0; i < dt.Rows.Count; i++) { if (com.IntToBool(com.StringToInt(dt.Rows[i]["SELECT"].ToString()))) { //印刷マーク print_flag = true; //seqno++; // Testing prtDt.Columns.Add(new DataColumn("FE_CRANK_ONLINE_NO")); prtDt.Columns.Add(new DataColumn("PRODUCTION_DATE")); prtDt.Columns.Add(new DataColumn("SHIFT")); prtDt.Columns.Add(new DataColumn("MODEL")); prtDt.Columns.Add(new DataColumn("LOTNO_ZOZAI")); prtDt.Columns.Add(new DataColumn("DIE_NO")); prtDt.Columns.Add(new DataColumn("ONLINE_DATE")); prtDt.Columns.Add(new DataColumn("ONLINE_STAMPING")); prtDt.Columns.Add(new DataColumn("REMARK")); DataRow dr = prtDt.NewRow(); dr["FE_CRANK_ONLINE_NO"] = "CRON-20180101-0001"; dr["PRODUCTION_DATE"] = "2018-04-23 00:00:00.000"; dr["SHIFT"] = "X"; dr["MODEL"] = "55A"; dr["LOTNO_ZOZAI"] = "P50203N7"; dr["DIE_NO"] = "99"; dr["ONLINE_DATE"] = "100"; dr["ONLINE_STAMPING"] = "H-0746"; dr["REMARK"] = ""; prtDt.Rows.Add(dr); // Actual Codes // データ検索 //WIPJo jo = new WIPJo(g_user_id, g_lang); //jo.job_order_no = dt.Rows[i]["Online_No"].ToString(); //jo.item_no = dt.Rows[i]["Part_No"].ToString(); //DataSet ds = jo.Get_OnRptDetail(); //if (ds == null) //{ // lblMsg.Text = jo.strErr; // lblMsg.ForeColor = Color.Red; // return; //} //prtDt = ds.Tables[0]; } } if (print_flag == false) { lblMsg.Text = msg.GetMessage("PRINT_DATA_NOT_EXIST_ERR"); lblMsg.ForeColor = Color.Red; return; } ReportClass Rpt = null; Rpt = new HondaTraceabilitySystem.Common.Report.FeOnline(); string ReportName = "MfgJOList"; try { //Rpt.Subreports["SubReport"].SetDataSource(prtDtTotal); Rpt.SetDataSource(prtDt); Rpt.SetParameterValue("H_TITLE", "INSPECTION SHEET(SEMICONDUCTOR"); PdfRtfWordFormatOptions pdfFormatOpts = new PdfRtfWordFormatOptions(); DiskFileDestinationOptions diskOpts = new DiskFileDestinationOptions(); // exportOpts; ExportOptions exportOpts = Rpt.ExportOptions; exportOpts.ExportDestinationType = ExportDestinationType.DiskFile; exportOpts.ExportFormatType = ExportFormatType.PortableDocFormat; exportOpts.FormatOptions = pdfFormatOpts; string tmpFilenm = ReportName + "_" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".pdf"; diskOpts.DiskFileName = Server.MapPath(WebConfigurationManager.ConnectionStrings["ReportOutDir"].ConnectionString + tmpFilenm); exportOpts.DestinationOptions = diskOpts; //print Rpt.Export(); Type cstype = this.GetType(); this.Page.ClientScript.RegisterClientScriptBlock(cstype, "a", @"<script>window.open('" + WebConfigurationManager.ConnectionStrings["ReportOutDir"].ConnectionString + tmpFilenm + "', '" + ReportName + "', 'status,resizable=yes');</script>"); } catch (Exception ex) { string strErr = ex.ToString(); lblMsg.Text = ex.ToString(); return; } lblMsg.Text = msg.GetMessage("NORMAL_PRINT"); lblMsg.ForeColor = Color.Blue; }
private static int ParseArgs(string[] args, out MfgBom.CostEstimation.CostEstimationRequest Request, out AVM.DDP.MetaTBManifest Manifest, out String pathResultsFolder) { Request = null; Manifest = null; pathResultsFolder = ""; var pathManifest = args[0]; if (false == File.Exists(pathManifest)) { Console.Error.WriteLine("No file found at location: {0}", pathManifest); return -2; } pathResultsFolder = Path.GetDirectoryName(pathManifest); Manifest = AVM.DDP.MetaTBManifest.OpenForUpdate(pathResultsFolder); if (null == Manifest) { Console.Error.WriteLine("Manifest is empty or didn't load correctly: {0}", pathManifest); return -3; } var artifactRequest = Manifest.Artifacts.FirstOrDefault(a => a.Tag == "CyPhy2MfgBom::CostEstimationRequest"); if (null == artifactRequest) { Console.Error.WriteLine("Didn't find any artifacts in the manifest with the tag \"CyPhy2MfgBom::CostEstimationRequest\": {0}", pathManifest); return -4; } var pathRequest = Path.Combine(pathResultsFolder, artifactRequest.Location); if (false == File.Exists(pathRequest)) { Console.Error.WriteLine("Couldn't find the file tagged with \"CyPhy2MfgBom::CostEstimationRequest\" at given path: {0}", pathRequest); return -5; } String jsonRequest; try { jsonRequest = File.ReadAllText(pathRequest); Request = MfgBom.CostEstimation.CostEstimationRequest.Deserialize(jsonRequest); } catch (Exception ex) { Console.Error.WriteLine("Exception loading the cost estimation request at \"{0}\": {1}", pathRequest, ex); return -6; } return 0; }
/// <summary> /// 明細変更ボタン /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnDET_CHANGE_Click(object sender, EventArgs e) { ComLibrary com = new ComLibrary(); Message msg = new Message(g_user_id, g_lang); //Location loc = new Location(g_user_id, g_lang); MfgBom Mfb = new MfgBom(g_user_id, g_lang); if (txtSequent.Text.Trim() == "") { lblMsg.Text = msg.GetMessage("INPUT_MANDATORY_ERR") + "(" + flblSequent.Text + ")"; lblMsg.ForeColor = Color.Red; return; } if (txtUsg_Qty.Text.Trim() == "") { lblMsg.Text = msg.GetMessage("INPUT_MANDATORY_ERR") + "(" + flblUsg_Qty.Text + ")"; lblMsg.ForeColor = Color.Red; return; } Mfb.data_char1 = txtBOM_No.Text.ToUpper(); Mfb.data_num1 = com.StringToInt(txtBOM_Level.Text); Mfb.data_num2 = com.StringToInt(txtBOM_Sub_Level.Text); Mfb.parent_item_no = txtITEM_NO.Text.ToUpper(); Mfb.part_seq = com.StringToInt(txtSequent.Text); Mfb.child_item_no = txtChild_Item.Text.ToUpper(); Mfb.usage_dec = com.StringToDouble(txtUsg_Qty.Text); Mfb.chg_user_id = g_user_id; Mfb.chg_pgm = "MstMfgBOMMnt"; int rtn = Mfb.Update(); if (rtn == ComConst.FAILED) { lblMsg.Text = Mfb.strErr; lblMsg.ForeColor = Color.Red; return; } // ここでは削除して登録 //loc.whs_cd = hdnITEM_NO.Value; //loc.location = hdnSequent.Value; //loc.chg_pgm = "MstLocationMnt"; //int rtn = loc.Delete(); //if (rtn != ComConst.SUCCEED) //{ // lblMsg.Text = loc.strErr; // lblMsg.ForeColor = Color.Red; // return; //} //loc.whs_cd = txtITEM_NO.Text.Trim().ToUpper(); //loc.location = txtSequent.Text.Trim().ToUpper(); //loc.location_desc = txtChild_Item.Text.Trim(); //loc.chg_pgm = "MstLocationMnt"; //rtn = loc.Insert(); //if (rtn != ComConst.SUCCEED) //{ // lblMsg.Text = loc.strErr; // lblMsg.ForeColor = Color.Red; // return; //} Edit_Screen(); }
/// <summary> /// 画面編集 /// </summary> protected void Edit_Screen() { ComLibrary com = new ComLibrary(); Message msg = new Message(g_user_id, g_lang); Item item = new Item(g_user_id, g_lang); MfgBom Mfb = new MfgBom(g_user_id, g_lang); if (txtITEM_NO.Text.Trim() == "") { lblMsg.Text = msg.GetMessage("INPUT_MANDATORY_ERR") + "(" + flblITEM_NO.Text + ")"; lblMsg.ForeColor = Color.Red; return; } else { item.item_no = txtITEM_NO.Text.ToUpper().Trim(); if (item.GetItemDetail() == ComConst.SUCCEED) { txtITEM_DESC.Text = item.item_desc; txtITEM_DESC.ToolTip = item.item_desc; } else { lblMsg.Text = msg.GetMessage("ITEM_NOT_EXIST_ERR"); lblMsg.ForeColor = Color.Red; dgvDetail.DataSource = null; dgvDetail.DataBind(); txtBOM_No.Text = ""; txtBOM_Level.Text = ""; txtBOM_Sub_Level.Text = ""; txtSequent.Text = ""; txtChild_Item.Text = ""; //txtChild_ItemDesc.Text = ""; txtUsg_Qty.Text = ""; txtITEM_DESC.Text = ""; return; } } //Warehouse whs = new Warehouse(g_user_id, g_lang); //whs.whs_cd = txtITEM_NO.Text.ToUpper(); //txtITEM_NO.Text = whs.whs_cd; //int rtn = whs.GetWarehouseDetail(); //if (rtn == ComConst.FAILED) //{ // txtITEM_DESC.Text = ""; // lblMsg.Text = msg.GetMessage("WAREHOUSE_NOT_EXIST_ERR"); // lblMsg.ForeColor = Color.Red; // return; //} //txtITEM_DESC.Text = whs.whs_desc; // マスタを検索 //Location loc = new Location(g_user_id, g_lang); //loc.whs_cd = txtITEM_NO.Text.ToUpper().Trim(); //DataSet ds = loc.GetLocationList(); Mfb.parent_item_no = txtITEM_NO.Text.ToUpper(); txtITEM_NO.Text = Mfb.parent_item_no; DataSet ds = Mfb.GetMfgBomList(); if (ds == null) { //lblMsg.Text = loc.strErr; lblMsg.Text = Mfb.strErr; lblMsg.ForeColor = Color.Red; dgvDetail.DataSource = null; dgvDetail.DataBind(); txtBOM_No.Text = ""; txtBOM_Level.Text = ""; txtBOM_Sub_Level.Text = ""; txtSequent.Text = ""; txtChild_Item.Text = ""; //txtChild_ItemDesc.Text = ""; txtUsg_Qty.Text = ""; return; } if (ds.Tables[0].Rows.Count == 0) { //Clear DataGridView dgvDetail.DataSource = null; dgvDetail.DataBind(); lblMsg.Text = msg.GetMessage("DATA_NOT_EXIST_ERR"); lblMsg.ForeColor = Color.Red; txtBOM_No.Text = ""; txtBOM_Level.Text = ""; txtBOM_Sub_Level.Text = ""; txtSequent.Text = ""; txtChild_Item.Text = ""; //txtChild_ItemDesc.Text = ""; txtUsg_Qty.Text = ""; return; } txtBOM_No.Text = ""; txtBOM_Level.Text = ""; txtBOM_Sub_Level.Text = ""; txtSequent.Text = ""; txtChild_Item.Text = ""; txtChild_ItemDesc.Text = ""; txtUsg_Qty.Text = ""; hdnITEM_NO.Value = ""; hdnSequent.Value = ""; hdnChild_Item.Value = ""; Edit_grid(ds.Tables[0]); ViewState["dgvSearch"] = ds.Tables[0]; dgvDetail.SelectedIndex = -1; }