/// <summary>Error Check Before Import /// /// </summary> /// <param name="FilePath">import file path</param> /// <returns></returns> private bool ErrorCheck(ArrayList FilePath) { if (!string.IsNullOrWhiteSpace(ucSupplier.UC_Code)) { if (!ucSupplier.SelectData()) { DSP_MSG("E101", string.Empty, string.Empty, string.Empty, string.Empty, string.Empty); ucSupplier.SetFocus(); return(false); } else if (!psks0103ibl.MakerBrandSelect("MakerCD", "M_MakerBrand", "Where DataSourseMakerCD ='" + ucSupplier.UC_Code + "'")) { DSP_MSG("E101", string.Empty, string.Empty, string.Empty, string.Empty, string.Empty); ucSupplier.SetFocus(); return(false); } } else { DSP_MSG("E102", "名前", string.Empty, string.Empty, string.Empty, string.Empty); ucSupplier.SetFocus(); return(false); } //ErrChkFlg = "0"; foreach (DataGridViewRow row1 in dgvImportRireki.Rows) { DataGridViewCheckBoxCell chk1 = row1.Cells["chk1"] as DataGridViewCheckBoxCell; DataGridViewCheckBoxCell chk2 = row1.Cells["chk2"] as DataGridViewCheckBoxCell; DataGridViewCheckBoxCell chk3 = row1.Cells["chk3"] as DataGridViewCheckBoxCell; if (chk1.Value == null) { chk1.Value = false; } if (chk2.Value == null) { chk2.Value = false; } if (chk3.Value == null) { chk3.Value = false; } if (Convert.ToBoolean(chk1.Value) != false && Convert.ToBoolean(chk2.Value) != false)// check「結果」「エラー」 { DSP_MSG("E126", string.Empty, string.Empty, string.Empty, string.Empty, string.Empty); return(false); } else if (Convert.ToBoolean(chk3.Value) == false)//Check File Type and Folder path { if (FilePath.Count <= 0) { DSP_MSG("E127", string.Empty, string.Empty, string.Empty, string.Empty, string.Empty); return(false); } } else { ErrChkFlg = "3"; Delete_row = row1.Index; return(false); } } if (string.IsNullOrWhiteSpace(cboPatternCD.Text)) { MessageBox.Show("フォーマット Doesn't Exists", "メッセージ"); return(false); } if (!(Have_opened_Excel(FilePath))) // Added by Phyoe Gyi in 03082019 --- for Checking the imported excel are opened or not? { MessageBox.Show("Some of the imported files are being used by another process. please close those files to be able to import"); return(false); } return(true); }
private bool ErrorCheck() { if (!string.IsNullOrWhiteSpace(ucSupplier.UC_Code)) { if (!ucSupplier.SelectData()) { DSP_MSG("E101", string.Empty, string.Empty, string.Empty, string.Empty, string.Empty); ucSupplier.SetFocus(); //btnImport.Enabled = false; return(false); } else if (!psks0103ibl.MakerBrandSelect("MakerCD", "M_MakerBrand", "Where MakerCD='" + ucSupplier.UC_Code + "'")) { DSP_MSG("E101", string.Empty, string.Empty, string.Empty, string.Empty, string.Empty); ucSupplier.SetFocus(); //btnImport.Enabled = false; return(false); } } else { //DSP_MSG("E102", "名前", string.Empty, string.Empty, string.Empty, string.Empty); ucSupplier.SetFocus(); //btnImport.Enabled = false; return(false); } ErrChkFlg = "0"; foreach (DataGridViewRow row1 in dgvImportRireki.Rows) { DataGridViewCheckBoxCell chk1 = row1.Cells["chk1"] as DataGridViewCheckBoxCell; DataGridViewCheckBoxCell chk2 = row1.Cells["chk2"] as DataGridViewCheckBoxCell; DataGridViewCheckBoxCell chk3 = row1.Cells["chk3"] as DataGridViewCheckBoxCell; if (chk1.Value == null) { chk1.Value = false; } if (chk2.Value == null) { chk2.Value = false; } if (chk3.Value == null) { chk3.Value = false; } if ((bool)chk1.Value != false && (bool)chk2.Value != false)// check「結果」「エラー」 { DSP_MSG("E126", string.Empty, string.Empty, string.Empty, string.Empty, string.Empty); return(false); } else if ((bool)chk3.Value == false)//Check File Type and Folder path { //if (!File.Exists(getFilePath())) if (getFilePath().Count <= 0) { DSP_MSG("E127", string.Empty, string.Empty, string.Empty, string.Empty, string.Empty); return(false); } } else { ErrChkFlg = "3"; Delete_row = row1.Index; return(false); } } if (string.IsNullOrWhiteSpace(lblFormatCD.Text)) { MessageBox.Show("フォーマット Doesn't Exists", "メッセージ"); return(false); } if (psks0103ibl.JANCD_PositionCheck(ucSupplier.UC_Code).Equals("0")) { MessageBox.Show("JAN Position Not Found!", "メッセージ"); return(false); } return(true); }