/// <summary>Import /// /// </summary> private void F12() { if (ErrChkFlg == "3") { Cursor.Current = Cursors.WaitCursor; DeleteBy_DeleteCheck(); Cursor.Current = Cursors.Default; } else { ArrayList FilePath = getFilePath(); if (ErrorCheck(FilePath))//1 { if (DSP_MSG("Q101", string.Empty, string.Empty, string.Empty, string.Empty, string.Empty).Equals("1")) { //Modify2018-11-09 tmze = new T_MakerZaiko_Entity(); tmze.MakerCD = ucSupplier.UC_Code; tmze.InsertOperator = loginInfo.OperatorCode; PopUp.PSKS0103I_Import import = new PopUp.PSKS0103I_Import(FilePath, tmze, lblHiddenKubun.Text, cboPatternCD.Text); import.ShowDialog(); InportRireki_Select(); } } } }
/// <summary> /// Save record from Gridview /// </summary> private void F12() { if (DSP_MSG("Q101", string.Empty, string.Empty, string.Empty, string.Empty, string.Empty).Equals("1")) { if (!string.IsNullOrWhiteSpace(ucSupplier.UC_Code)) { string DateAndTime = System.DateTime.Now.ToString(); if (ErrorCheck2()) { if (dgvPSK0104I.Rows.Count > 0) { tmze = GetTmze(); lle = GetLogData(); psks0104ibl.psks0104I_InsertUpdate(tmze, lle); EnabledCtrl(); Clear(); dt_PSKS0104I.AcceptChanges(); } } else { ucSupplier.SetFocus(); } } else { DSP_MSG("E102", "名前", string.Empty, string.Empty, string.Empty, string.Empty); ucSupplier.SetFocus(); } } }
public bool Delete_BeforeImoprt(T_MakerZaiko_Entity tmze)//取込前データ削除 { M_SiiresakiZaiko_DL mszdl = new M_SiiresakiZaiko_DL(); M_SiiresakiZaiko_Entity msze = new M_SiiresakiZaiko_Entity(); T_MakerZaiko_DL tmzdl = new T_MakerZaiko_DL(); msze.SiiresakiCD = tmze.MakerCD; DataTable dt = mszdl.M_SiiresakiZaiko_Select(msze);//確定済の判断 if (dt.Rows.Count > 0) { if (dt.Rows[0]["TorikomiFixedFLG"].ToString() == "1")//TorikomiFixedFLG == 1なら(確定済) { tmzdl.Transaction = psks0103idl.Transaction; if (tmzdl.T_MakerZaiko_DELETE(tmze))//既存データ削除 { tmze.InsertDateTime = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"); if (!tmzdl.T_MakerZaiko_Insert(tmze)) { return(false); } } else { return(false); } } } return(true); }
public bool T_MakerZaiko_DELETE(T_MakerZaiko_Entity tmze) { Dictionary <string, string> dic = new Dictionary <string, string>(); dic.Add("@MakerCD", tmze.MakerCD); return(InsertUpdateDeleteData(dic, "T_MakerZaiko_DELETE")); }
public bool T_MakerZaiko_Insert(T_MakerZaiko_Entity tmze) { Dictionary <string, string> dic = new Dictionary <string, string>(); dic.Add("@DateTime", tmze.InsertDateTime); dic.Add("@MakerCD", tmze.MakerCD); dic.Add("@InsertOperator", tmze.InsertOperator); return(InsertUpdateDeleteData(dic, "T_MakerZaiko_INSERT")); }
/// <summary> /// Add from Datatable Data to Entity /// </summary> /// <returns></returns> private T_MakerZaiko_Entity GetTmze() { tmze = new T_MakerZaiko_Entity(); tmze.MakerCD = ucSupplier.UC_Code; tmze.InsertOperator = loginInfo.OperatorCode; tmze.InsertDateTime = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"); tmze.KakuTeiFlg = lblKakuteiMode.Text == "確定" ? "1" : "0"; tmze.dt1 = dt_PSKS0104I; return(tmze); }
public bool T_MakerZaiko_Update(T_MakerZaiko_Entity tmze) { Dictionary <string, string> dic = new Dictionary <string, string>(); dic.Add("@MakerCD", tmze.MakerCD); dic.Add("@KakuTeiFlg", tmze.KakuTeiFlg); dic.Add("@xml", tmze.xml); dic.Add("@InsertOperator", tmze.InsertOperator); dic.Add("@InsertDateTime", tmze.InportDateTime); return(InsertUpdateDeleteData(dic, "T_MakerZaiko_Update")); }
public PSKS0103I_Import(ArrayList arrlst, T_MakerZaiko_Entity tmze, string firstColHeader, string patternCD) { InitializeComponent(); this.arrlst = arrlst; this.tmze = tmze; lblNum.Text = arrlst.Count.ToString(); this.firstColHeader = firstColHeader; this.patternCD = patternCD; BindGrid(arrlst); //dgv1.AlternatingRowsDefaultCellStyle.BackColor = Color.Empty; dgv1.DisabledColumn("colNo"); }
/// <summary> /// check to add new record /// </summary> /// <returns></returns> private bool GvAddRow_Check() { if (!string.IsNullOrWhiteSpace(ucSupplier.UC_Code)) { txtZaikoSu.Text = string.IsNullOrWhiteSpace(txtZaikoSu.Text) ? "0" : txtZaikoSu.Text; if (Convert.ToInt32(txtZaikoSu.Text.Replace(",", "")) < 0) { DSP_MSG("E109", string.Empty, string.Empty, string.Empty, string.Empty, string.Empty); return(false); } if (!string.IsNullOrWhiteSpace(ucJANCD2.UC_Code)) { DataTable dt = new DataTable(); dt = psks0104ibl.JANCD_ExistsCheck(ucJANCD2.UC_Code); //Check Exist in Sugoraku if (dt.Rows.Count <= 0) { DSP_MSG("E101", string.Empty, string.Empty, string.Empty, string.Empty, string.Empty); return(false); } else { vm_hanbai_shohin = dt.Rows[0]["VM_SHOHIN"].ToString(); } } else { DSP_MSG("E102", string.Empty, string.Empty, string.Empty, string.Empty, string.Empty); ucJANCD2.SetFocus(); return(false); } tmze = new T_MakerZaiko_Entity(); tmze.MakerCD = ucSupplier.UC_Code; tmze.JanCD = ucJANCD2.UC_Code; DataRow[] drJanDuplicate = dt_PSKS0104I.Select("JANCD='" + ucJANCD2.UC_Code + "'"); if (psks0104ibl.T_MakerZaiko_ExistCheck(tmze).Rows.Count > 0 || drJanDuplicate.Count() > 0) // Check Exist in shouhinkanri { DSP_MSG("E131", string.Empty, string.Empty, string.Empty, string.Empty, string.Empty); return(false); } } else { DSP_MSG("E102", string.Empty, string.Empty, string.Empty, string.Empty, string.Empty); ucSupplier.SetFocus(); return(false); } return(true); }
private void F12() { if (ErrorCheck())//1 { if (DSP_MSG("Q101", string.Empty, string.Empty, string.Empty, string.Empty, string.Empty).Equals("1")) { ArrayList FilePath = getFilePath();//Modify2018-11-09 tmze = new T_MakerZaiko_Entity(); tmze.MakerCD = ucSupplier.UC_Code; tmze.InsertOperator = loginInfo.OperatorCode; //PopUp.PSKS0103I_Import import = new PopUp.PSKS0103I_Import(FilePath, tmze,"1"); //import.ShowDialog(); InportRireki_Select(); } } else if (ErrChkFlg == "3") { DeleteBy_DeleteCheck(); } }
public bool ImportProcess(T_MakerZaiko_Entity tmze, string patternCD, DataTable dtPattern, int i, string insertDateTime) { psks0103idl.StartTransaction(); bool result = false; if (i == 0) { result = Delete_BeforeImoprt(tmze);//do for first file only } else { result = true; } if (result) { if (InportProcesses(tmze, patternCD, dtPattern, insertDateTime)) { psks0103idl.CommitTransaction(); return(true); } } return(false); }
private bool InportProcesses(T_MakerZaiko_Entity tmze, string patternCD, DataTable dtPattern, string insertDateTime)//取込処理 { try { string noukiFlag = "0"; DataRow[] drs = dtPattern.Select("Convert(ItemProperty, 'System.Int32') = 1"); int colIndex = Convert.ToInt32(drs[0]["SEQ"].ToString()) - 1; tmze.dt1.Columns[colIndex].ColumnName = "JANCD"; drs = dtPattern.Select("Convert(ItemProperty, 'System.Int32') = 2"); int i = 0; foreach (DataRow dr in drs) { colIndex = Convert.ToInt32(drs[i]["SEQ"].ToString()) - 1; tmze.dt1.Columns[colIndex].ColumnName = "P" + ++i; } while (i < 5) { DataColumn dc = new DataColumn(); dc.DefaultValue = 0; dc.ColumnName = "P" + ++i; tmze.dt1.Columns.Add(dc); } i = 0; drs = dtPattern.Select("Convert(ItemProperty, 'System.Int32') = 3"); foreach (DataRow dr in drs) { colIndex = Convert.ToInt32(drs[i]["SEQ"].ToString()) - 1; tmze.dt1.Columns[colIndex].ColumnName = "M" + ++i; } while (i < 5) { DataColumn dc = new DataColumn(); dc.DefaultValue = 0; dc.ColumnName = "M" + ++i; tmze.dt1.Columns.Add(dc); } tmze.dt1.Columns.Add("ZaikoSuTotal"); drs = dtPattern.Select("Convert(ItemProperty, 'System.Int32') = 9 or Convert(ItemProperty, 'System.Int32') = 10"); if (drs.Count() > 0) { colIndex = Convert.ToInt32(drs[0]["SEQ"].ToString()) - 1; tmze.dt1.Columns[colIndex].ColumnName = "Nouki"; if (drs[0]["Convert(ItemProperty, 'System.Int32')"].ToString().Equals("9")) { noukiFlag = "1"; } } else { tmze.dt1.Columns.Add("Nouki"); } ArrayList arrcol = new ArrayList(); foreach (DataColumn dc in tmze.dt1.Columns) { if (!(dc.ColumnName.Equals("JANCD") || dc.ColumnName.Equals("P1") || dc.ColumnName.Equals("P2") || dc.ColumnName.Equals("P3") || dc.ColumnName.Equals("P4") || dc.ColumnName.Equals("P5") || dc.ColumnName.Equals("M1") || dc.ColumnName.Equals("M2") || dc.ColumnName.Equals("M3") || dc.ColumnName.Equals("M4") || dc.ColumnName.Equals("M5") || dc.ColumnName.Equals("ZaikoSuTotal") || dc.ColumnName.Equals("Nouki"))) { arrcol.Add(dc); } } foreach (DataColumn dc in arrcol) { tmze.dt1.Columns.Remove(dc); } tmze.dt1.AcceptChanges(); tmze.dt1.Columns.Add("HenkanNouki"); tmze.dt1.Columns.Add("ErrorKBN"); tmze.dt1.Columns.Add("ErrorText"); DataColumn dc1 = new DataColumn(); dc1.DefaultValue = 0; dc1.ColumnName = "SEQ"; tmze.dt1.Columns.Add(dc1); tmie = new T_MakerInport_Entity(); tmie.DataSourseMakerCD = tmze.MakerCD; tmie.InportFile = tmze.ImportFileName; tmie.InsertOperator = tmze.InsertOperator; tmie.PatternCD = patternCD; tmie.xml = DataTableToXml(tmze.dt1); return(psks0103idl.Import(tmie, insertDateTime, noukiFlag)); } catch (Exception) { return(false); } }