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