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);
}
}
