public DataTable M_MakerZaiko_D_Select(MakerZaiko_D_Entity maker_D_entity) { Dictionary <string, string> dic = new Dictionary <string, string>(); dic.Add("@PatternCD", maker_D_entity.PatternCD); return(SelectData(dic, "M_MakerZaiko_Select")); }
public bool MakerZaiko_Delete(M_MakerZaiko_H_Entity makerH_data, MakerZaiko_D_Entity makerD_data, M_NoukiHenkan_Entity nouki_data, L_Log_Entity l_log, SuuryoHenKan_Entity suuryo_data) { hdl.StartTransaction(); makerD_data.KamokuXML = DataTableToXml(makerD_data.dtKamoKu); nouki_data.NoukiXML = DataTableToXml(nouki_data.dtNouki); if (hdl.M_MakerZaiko_H_Delete(makerH_data)) { ddl.Transaction = hdl.Transaction; if (ddl.M_MakerZaiko_D_Delete(makerD_data)) { if (ndl.M_NoukiHenkan_Delete(nouki_data)) { sydl.Transaction = hdl.Transaction; if (sydl.SuuryoHenKan_Delete(suuryo_data)) { LogDL.Transaction = hdl.Transaction; if (LogDL.L_Log_Insert(l_log)) { hdl.CommitTransaction(); return(true); } } } } } return(false); }
public bool M_MakerZaiko_D_Delete(MakerZaiko_D_Entity maker_D_entity) { Dictionary <string, string> dic = new Dictionary <string, string>(); dic.Add("@PatternCD", maker_D_entity.PatternCD); return(InsertUpdateDeleteData(dic, "M_MakerZaiko_D_Delete")); }
private MakerZaiko_D_Entity GetMakerD_Entity() { makerD_entity = new MakerZaiko_D_Entity(); makerD_entity.PatternCD = ucPattern.UC_Code; makerD_entity.dtKamoKu = dtKaMoku; return(makerD_entity); }
public bool MakerZaiko_Insert(M_MakerZaiko_H_Entity makerH_data, MakerZaiko_D_Entity makerD_data, M_NoukiHenkan_Entity nouki_data, L_Log_Entity l_log, SuuryoHenKan_Entity suuryo_data) { hdl.StartTransaction(); DataRow[] dtrowMaker = makerD_data.dtKamoKu.Select("ItemName IS NOT NULL OR ItemName <> ' '"); DataRow[] dtrowNouki = nouki_data.dtNouki.Select("Maker IS NOT NULL OR Maker <> ' '"); DataRow[] dtrowSuuryo = suuryo_data.dtSuuryo.Select("MakerSuuryo IS NOT NULL OR MakerSuuryo <> ' '"); if (dtrowMaker.Count() > 0) { DataTable dtMaker = makerD_data.dtKamoKu.Select("ItemName IS NOT NULL OR ItemName <> ' '").CopyToDataTable(); makerD_data.KamokuXML = DataTableToXml(dtMaker); } if (dtrowNouki.Count() > 0) { DataTable dtNouki = nouki_data.dtNouki.Select("Maker IS NOT NULL OR Maker <> ' '").CopyToDataTable(); nouki_data.NoukiXML = DataTableToXml(dtNouki); } if (dtrowSuuryo.Count() > 0) { DataTable dtSuuryo = suuryo_data.dtSuuryo.Select("MakerSuuryo IS NOT NULL OR MakerSuuryo <> ' '").CopyToDataTable(); suuryo_data.SuuryoXML = DataTableToXml(dtSuuryo); } if (hdl.M_MakerZaiko_H_Update(makerH_data)) { ddl.Transaction = hdl.Transaction; if (ddl.M_MakerZaiko_D_Insert(makerD_data)) { ndl.Transaction = hdl.Transaction; if (ndl.M_NoukiHenkan_Insert(nouki_data)) { sydl.Transaction = hdl.Transaction; if (sydl.SuuryoHenKan_Insert(suuryo_data)) { LogDL.Transaction = hdl.Transaction; if (LogDL.L_Log_Insert(l_log)) { hdl.CommitTransaction(); return(true); } } } } } return(false); }
private bool ExecutionProcess() { makerH_entity = GetMakerH_Entity(); makerD_entity = GetMakerD_Entity(); nouki_entity = GetNouki_Entity(); suuryo_entity = GetSuuryo_Entity(); LLogEntity = new L_Log_Entity(); LLogEntity.InsertOperator = loginInfo.OperatorCode; string dateandTime = DateTime.Now.ToString(); LLogEntity.OperateDate = makerH_entity.InsertDateTime = nouki_entity.InsertDateTime = suuryo_entity.InsertDateTime = dateandTime; LLogEntity.Program = "PSKS0101M"; LLogEntity.PC = loginInfo.PcName; LLogEntity.OperateMode = FormMode; LLogEntity.KeyItem = ucPattern.UC_Code; makerH_entity.InsertOperator = loginInfo.OperatorCode; nouki_entity.InsertOperator = loginInfo.OperatorCode; suuryo_entity.InsertOperator = loginInfo.OperatorCode; bool result = false; switch (FormMode) { case "新規": result = sks0101M_bl.MakerZaiko_Insert(makerH_entity, makerD_entity, nouki_entity, LLogEntity, suuryo_entity); break; case "修正": makerH_entity.UpdateOperator = loginInfo.OperatorCode; nouki_entity.UpdateOperator = loginInfo.OperatorCode; suuryo_entity.UpdateOperator = loginInfo.OperatorCode; makerH_entity.UpdateDateTime = nouki_entity.UpdateDateTime = suuryo_entity.UpdateDateTime = dateandTime; result = sks0101M_bl.MakerZaiko_Update(makerH_entity, makerD_entity, nouki_entity, LLogEntity, suuryo_entity); break; case "削除": result = sks0101M_bl.MakerZaiko_Delete(makerH_entity, makerD_entity, nouki_entity, LLogEntity, suuryo_entity); break; } return(result); }
public DataTable M_MakerZaiko_D_Select(MakerZaiko_D_Entity maker_D_entity) { return(mmzddl.M_MakerZaiko_D_Select(maker_D_entity)); }
private void SetMaker_Data(string comCode) { MakerZaiko_D_Entity maker_D_data = new MakerZaiko_D_Entity(); M_NoukiHenkan_Entity nouki_data = new M_NoukiHenkan_Entity(); M_MakerZaiko_H_Entity maker_H_data = new M_MakerZaiko_H_Entity(); SuuryoHenKan_Entity suuryo_data = new SuuryoHenKan_Entity(); PSKS0101M_BL sks0101m_bl = new PSKS0101M_BL(); DataTable dtmakerD = new DataTable(); DataTable dtnoukidata = new DataTable(); DataTable dtsuuryodata = new DataTable(); if (!FormMode.Equals("新規")) { txtPatternName.Text = ucPattern.UC_Name; } maker_D_data.PatternCD = comCode; nouki_data.PatternCD = comCode; maker_H_data.PatternCD = comCode; suuryo_data.PatternCD = comCode; dtmakerD = sks0101m_bl.MakerZaiko_Select(maker_D_data); dtnoukidata = sks0101m_bl.Nouki_Select(nouki_data); dtsuuryodata = sks0101m_bl.Suuryo_Select(suuryo_data); for (int i = 1; i <= 300; i++) { DataRow[] drs = dtnoukidata.Select("SEQ = '" + i + "'"); if (drs.Count() <= 0) { DataRow dr = dtnoukidata.NewRow(); dr["SEQ"] = i.ToString(); dtnoukidata.Rows.Add(dr); DataView dv = dtnoukidata.DefaultView; dv.Sort = "SEQ ASC"; dtNouki = dv.ToTable(); } } dtNouki = dtnoukidata; dgvdelivery.DataSource = dtNouki; for (int i = 1; i <= 300; i++) { DataRow[] drs = dtmakerD.Select("SEQ = '" + i + "'"); if (drs.Count() <= 0) { DataRow dr = dtmakerD.NewRow(); dr["SEQ"] = i.ToString(); dtmakerD.Rows.Add(dr); DataView dv = dtmakerD.DefaultView; dv.Sort = "SEQ ASC"; dtmakerD = dv.ToTable(); } } dtKaMoku = dtmakerD; dgvKamoku.DataSource = dtKaMoku; for (int i = 1; i <= 300; i++) { DataRow[] drs = dtsuuryodata.Select("SEQ= '" + i + "'"); if (drs.Count() <= 0) { DataRow dr = dtsuuryodata.NewRow(); dr["SEQ"] = i.ToString(); dtsuuryodata.Rows.Add(dr); DataView dv = dtsuuryodata.DefaultView; dv.Sort = "SEQ ASC "; dtsuuryodata = dv.ToTable(); } } dtSuuryo = dtsuuryodata; dgvSuuryoHenKan.DataSource = dtsuuryodata; ucPattern.SetFocus(); }
public DataTable MakerZaiko_Select(MakerZaiko_D_Entity maker_D_data) { return(ddl.M_MakerZaiko_D_Select(maker_D_data)); }
public bool InsertData(int i) { try { dgv1.Rows[i].Cells["colStatus"].Value = "Importing....."; dgv1.Rows[i].Cells["colImage"].Value = SMS.Properties.Resources.dbImport; dgv1.Rows[i].Cells["colImage"].Style.BackColor = Color.FromArgb(255, 255, 192); string filePath = dgv1.Rows[i].Cells["colFileName"].Value.ToString(); string ext = Path.GetExtension(filePath); DataTable dtImport = new DataTable(); mzde = new MakerZaiko_D_Entity(); mzde.PatternCD = patternCD; DataTable dtPattern = psks0103ibl.M_MakerZaiko_D_Select(mzde); if (ext.Equals(".csv")) { if (patternCD == "011") /// for sankyo_ maker by etz { dtImport = CSVToTable(filePath, dtPattern.Rows.Count); } else { dtImport = CSVToTable(filePath); } } else if (ext.Equals(".xlsx") || ext.Equals(".xls")) { dtImport = ExcelToDatatable(filePath); } else { dgv1.Rows[i].Cells["colStatus"].Value = "Invalid File"; dgv1.Rows[i].Cells["colImage"].Value = SMS.Properties.Resources.close; dgv1.Rows[i].Cells["colImage"].Style.BackColor = Color.Red; return(false); } //Delete Extra Column With Blank Rows ---ktp 2019-04-16 ArrayList arrdatacolumn = new ArrayList(); string Keys = "MaungPhyoeGyi_JennieKim"; // -------PTK Added Use-header row Conflict if (!CheckAllPhyoeGyiColumns(dtImport, Keys)) /// PTK Added For Use-header row Conflict { foreach (DataColumn dc in dtImport.Columns) { if (dc.ColumnName.Contains(Keys)) { arrdatacolumn.Add(dc); } } foreach (DataColumn dc in arrdatacolumn) { dtImport.Columns.Remove(dc); } } dtImport.AcceptChanges(); try { M_MultiPorpose_Entity mme1 = new M_MultiPorpose_Entity(); mme1.fields = "Char1,Num1,Char5"; mme1.tableName = "M_MultiPorpose"; mme1.condition = "Where ID=101 And [Key]='1'"; DataTable dt1 = psks0103ibl.M_MultiPorpose_DynamicSelect(mme1); if (dt1.Rows[0]["Char5"].ToString() == "1") { MessageBox.Show("Excel cols " + dtImport.Columns.Count.ToString() + Environment.NewLine + "Pattern Cols" + dtPattern.Rows.Count.ToString()); } } catch { } if (dtImport.Columns.Count != dtPattern.Rows.Count) { DSP_MSG("E137", string.Empty, string.Empty, string.Empty, string.Empty, string.Empty); dgv1.Rows[i].Cells["colStatus"].Value = "Failed"; dgv1.Rows[i].Cells["colImage"].Value = SMS.Properties.Resources.Failed; dgv1.Rows[i].Cells["colImage"].Style.BackColor = Color.Red; return(false); } tmze.dt1 = dtImport; tmze.ImportFileName = Path.GetFileName(filePath); M_MultiPorpose_Entity mme = new M_MultiPorpose_Entity(); mme.fields = "Char1,Char2,Num1"; mme.tableName = "M_MultiPorpose"; mme.condition = "Where ID=101 And [Key]='1'"; DataTable dt = psks0103ibl.M_MultiPorpose_DynamicSelect(mme); //string destination = @"C:\SMS\PSKS0103I\ImportFinished\"; string destination = String.IsNullOrEmpty(dt.Rows[0]["Char2"].ToString()) ? @"C:\SMS\PSKS0103I\ImportFinished\" : dt.Rows[0]["Char2"].ToString() + @"\"; if (psks0103ibl.ImportProcess(tmze, patternCD, dtPattern, i, System.DateTime.Now.ToString())) { dgv1.Rows[i].Cells["colStatus"].Value = "Finished"; dgv1.Rows[i].Cells["colImage"].Value = SMS.Properties.Resources.success; dgv1.Rows[i].Cells["colImage"].Style.BackColor = Color.FromArgb(192, 255, 192); if (!Directory.Exists(destination)) { Directory.CreateDirectory(destination); } if (File.Exists(destination + Path.GetFileName(filePath))) { File.Delete(destination + Path.GetFileName(filePath)); } try { File.Move(filePath, destination + Path.GetFileName(filePath)); } catch { }; } else { dgv1.Rows[i].Cells["colStatus"].Value = "Failed"; dgv1.Rows[i].Cells["colImage"].Value = SMS.Properties.Resources.close; dgv1.Rows[i].Cells["colImage"].Style.BackColor = Color.Red; } return(true); } catch (Exception ex) { MessageBox.Show(ex.InnerException.ToString()); return(false); } }