private async void PSKS0103I_Import_Load(object sender, EventArgs e) { psks0103ibl = new PSKS0103I_BL(); btnOK.Enabled = false; for (int i = 0; i < dgv1.Rows.Count; i++) { await Insert(i); } btnOK.Enabled = true; }
private void frmPSKS0103I_Load(object sender, EventArgs e) { FunctionButtonDisabled(2); FunctionButtonDisabled(3); FunctionButtonDisabled(4); FunctionButtonDisabled(5); FunctionButtonDisabled(7); FunctionButtonDisabled(8); FunctionButtonDisabled(10); FunctionButtonDisabled(11); pskso116ibl = new PSKS0116I_BL(); psks0103ibl = new PSKS0103I_BL(); ucSupplier.GotFocus += new System.EventHandler(ucSupplier_GotFocus); FormName = "メーカー在庫取込"; lblMode.Visible = true; lblMode.Text = "先に通常取込を実施してください"; lblMode.BackColor = Color.FromArgb(255, 102, 255); lblMode.Width = 250; lblMode.TextAlign = ContentAlignment.MiddleCenter; btnImport.Enabled = false; FunctionButtonDisabled(12); mme = new M_MultiPorpose_Entity(); mme.fields = "Char1,Num1"; mme.tableName = "M_MultiPorpose"; mme.condition = "Where ID=101 And [Key]='1'"; DataTable dt = psks0103ibl.M_MultiPorpose_DynamicSelect(mme); if (dt.Rows.Count > 0) { lblServerPath.Text = "サーバーの" + dt.Rows[0]["Char1"].ToString() + "フォルダーに保存されているファイルを取込します。"; lblHistory.Text = dt.Rows[0]["Num1"] + "日間の履歴を保持しています"; folderPath = dt.Rows[0]["Char1"].ToString(); } dgvImportRireki.DisabledColumn("colNo1,colInportDateTime,colDataMoto,colInportFile,colInportOperator,colInportSu,colErrorSu"); dgvFileDetail.DisabledColumn("*"); tmire = new T_MakerInportRireki_Entity(); DataTable dtInport = psks0103ibl.T_MakerInportRireki_SELECT(tmire); dgvImportRireki.DataSource = dtInport; }
public bool IsColumnCountOKay(string Path, string mkr_CD, int count) { psks0103ibl = new PSKS0103I_BL(); DataTable dtpthname = psks0103ibl.get_ptnname(mkr_CD); //var e_2_d = ExcelToDatatable(Path); if (Convert.ToInt32(dtpthname.Rows[0]["Total_column"]).Equals(count)) { return(true); } else { return(false); } }