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