// <summary>
///データを入力、更新する、CSV出力
/// </summary>
/// <param></param>
/// <returns></returns>
public void F12()
{
if (ErrorCheck())
{
if (DSP_MSG("Q101", string.Empty, string.Empty, string.Empty, string.Empty, string.Empty).Equals("1"))
{
bool valid = true;
DataTable dtImport = new DataTable();
int rowcount = 0;
dtImport = CsvToDataTable(txtfilepath.Text);
amazonyoteidate_data = new T_AmazonYoteiDate_Entity();
LLogEntity = new L_Log_Entity();
amazonyoteidate_data.OperatorCD = loginInfo.OperatorCode;
if (IsEmptyGrid(dtImport))
{
DSP_MSG("E137", string.Empty, string.Empty, string.Empty, string.Empty, string.Empty);
txtfilepath.Focus();
valid = false;
}
else
{
string aa = dtImport.Rows[0]["A"].ToString();
//if (!(dtImport.Rows[0]["A"].ToString().Equals("order-id")) && !(dtImport.Rows[0]["B"].ToString().Equals("order-item-id")) && !(dtImport.Rows[0]["C"].ToString().Equals("purchase-date")))
if (!((dtImport.Rows[0]["A"].ToString().Equals("order-id")) && (dtImport.Rows[0]["B"].ToString().Equals("order-item-id")) && (dtImport.Rows[0]["C"].ToString().Equals("purchase-date"))))
{
DSP_MSG("E137", string.Empty, string.Empty, string.Empty, string.Empty, string.Empty);
txtfilepath.Focus();
valid = false;
}
}
if (valid)
{
if (petc0306ibl.PETC0306I_DELETE(amazonyoteidate_data))
{
for (int i = 1; i < dtImport.Rows.Count; i++)
{
rowcount = rowcount + 1;
amazonyoteidate_data.OperatorCD = loginInfo.OperatorCode;
amazonyoteidate_data.SEQ = rowcount.ToString();
amazonyoteidate_data.amazon_order_id = dtImport.Rows[i]["A"].ToString();
amazonyoteidate_data.sku = dtImport.Rows[i]["H"].ToString();
//insert data into database from csv
petc0306ibl.PETC0306I_Insert(amazonyoteidate_data);
//update estimated date data into databse
petc0306ibl.PETC0306I_Update(amazonyoteidate_data);
}
Export_CSV(petc0306ibl.PETC0306I_Select(amazonyoteidate_data));
}
}
}
}
}
public bool L_Log_Insert(L_Log_Entity L_LogEntity)
{
Dictionary <string, string> dic = new Dictionary <string, string>();
dic.Add("@OperateDate", L_LogEntity.OperateDate);
dic.Add("@InsertOperator", L_LogEntity.InsertOperator);
dic.Add("@Program", L_LogEntity.Program);
dic.Add("@PC", L_LogEntity.PC);
dic.Add("@OperateMode", L_LogEntity.OperateMode);
dic.Add("@KeyItem", L_LogEntity.KeyItem);
return(InsertUpdateDeleteData(dic, "L_Log_Insert"));
}
private L_Log_Entity Get_Log_Data()
{
log_data = new L_Log_Entity()
{
Program = "JANCDHenkou",
PC = InPcID,
OperateMode = string.Empty,
Operator = InOperatorCD,
KeyItem = string.Empty
};
return(log_data);
}
private L_Log_Entity Get_Log_Data()
{
log_data = new L_Log_Entity()
{
Program = "MasterTouroku_ShiireKakeritsu",
PC = InPcID,
OperateMode = string.Empty,
Operator = InOperatorCD,
KeyItem = string.Empty
};
return(log_data);
}
private L_Log_Entity Get_L_Log_Entity()
{
lle = new L_Log_Entity
{
InsertOperator = this.InOperatorCD,
PC = this.InPcID,
Program = this.InProgramID,
OperateMode = "",
KeyItem = txtTagetFrom.Text + "_S " + txtTargetTo.Text + "_E " + sc_Customer.TxtCode.Text + " " + cboStore.SelectedValue.ToString()
};
return(lle);
}
public bool M_MultiPorpose_Num1_Update(M_MultiPorpose_Entity mme, L_Log_Entity lle)
{
mmdl.StartTransaction();
if (mmdl.M_MultiPorpose_Num1_Update(mme))
{
lldl.Transaction = mmdl.Transaction;
if (lldl.L_Log_Insert(lle))
{
mmdl.CommitTransaction();
return(true);
}
}
return(false);
}
public Youshi(DataTable dt, params string[] loginfo)
{
InitializeComponent();
lle = new L_Log_Entity();
lst = loginfo;
tdl = new TempoRegiFurikomiYoushi_DL();
HideAllLine();
bdl = new Base_DL();
dtreport = dt;
L_Log_DL ldl = new L_Log_DL();
ldl.L_Log_Insert(lst);
// AllEvent_PrintLog();
}
private L_Log_Entity Get_L_Log_Entity()
{
L_Log_Entity lle = new L_Log_Entity();
lle = new L_Log_Entity
{
InsertOperator = this.InOperatorCD,
PC = this.InPcID,
Program = this.InProgramID,
OperateMode = "",
KeyItem = txtTargetPeriodF.Text + "," + txtTargetPeriodT.Text + "," + cboSouko.AccessibilityObject.Name
};
return(lle);
}
private void F12()
{
if (ErrorCheck())
{
if (jhbl.ShowMessage("Q101") == DialogResult.Yes)
{
xml = jhbl.DataTableToXml(dtGenJanCD);
log_data = Get_Log_Data();
if (jhbl.JanCDHenkou_Insert(xml, log_data))
{
Clear();
}
}
}
}
public bool PSKS0120S_Update(M_Zaiko_Kanri_Entity zaikokanri, L_Log_Entity lle)
{
zaikokanri.UpdateDateTime = lle.OperateDate = System.DateTime.Now.ToString();
zaikokanridl.StartTransaction();
logdl.Transaction = zaikokanridl.Transaction;
if (zaikokanridl.PSKS0120S_Update(zaikokanri))
{
if (logdl.L_Log_Insert(lle))
{
zaikokanridl.CommitTransaction();
return(true);
}
}
return(false);
}
public bool M_MakerBrand_Insert_Xml(M_MakerBrand_Entity mmbe, L_Log_Entity lle)
{
mmbe.xml = DataTableToXml(mmbe.dt1);
makerbrandDL.StartTransaction();
if (makerbrandDL.M_MakerBrand_InsertXML(mmbe))
{
LogDL.Transaction = makerbrandDL.Transaction;
if (LogDL.L_Log_Insert(lle))
{
makerbrandDL.CommitTransaction();
return(true);
}
}
return(false);
}
private void UpdateInsert()
{
//if (dtExcel != null || dtMain !=null)
//{
// dgv_ShiireKakeritsu.DataSource = dtExcel;
// //dtMain = dtAdd;
// Xml = mskbl.DataTableToXml(dtExcel);
// log_data = Get_Log_Data();
// moe.VendorCD = scSupplierCD.TxtCode.Text;
// moe.StoreCD = cbo_Store.SelectedValue.ToString();
// moe.ChangeDate = txtRevisionDate.Text;
// moe.Rate = txtRate1.Text;
//}
//else
//{
dtMain.AcceptChanges();
for (int i = 0; i < dtMain.Rows.Count; i++)
{
var Brand = dtMain.Rows[i]["BrandCD"].ToString();
var Sports = dtMain.Rows[i]["SportsCD"].ToString();
var Segment = dtMain.Rows[i]["SegmentCD"].ToString();
var LastYearTerm = dtMain.Rows[i]["LastYearTerm"].ToString();
var LastSeason = dtMain.Rows[i]["LastSeason"].ToString();
if (String.IsNullOrEmpty(Brand) || String.IsNullOrEmpty(Sports) || String.IsNullOrEmpty(Segment) || String.IsNullOrEmpty(LastYearTerm) || String.IsNullOrEmpty(LastSeason))
{
dtMain.Rows[i].Delete();
}
}
dgv_ShiireKakeritsu.DataSource = dtMain;
Xml = mskbl.DataTableToXml(dtMain);
log_data = Get_Log_Data();
moe.VendorCD = scSupplierCD.TxtCode.Text;
moe.StoreCD = cbo_Store.SelectedValue.ToString();
moe.ChangeDate = txtRevisionDate.Text;
moe.Rate = txtRate1.Text;
DataTable dt = mskbl.M_OrderRate_Update(moe, Xml, log_data);
scSupplierCD.Clear();
cbo_Store.SelectedValue = "0000";
Clear(panelDetail);
dgv_ShiireKakeritsu.DataSource = string.Empty;
mskbl.ShowMessage("I101");
scSupplierCD.SetFocus(1);
}
/// <summary>
/// get Log information
/// print log
/// </summary>
private L_Log_Entity Get_L_Log_Entity()
{
string item = detailControls[0].Text;
for (int i = 1; i < (int)EIndex.COUNT; i++)
{
switch (i)
{
case (int)EIndex.Chk1:
case (int)EIndex.Chk2:
case (int)EIndex.Chk3:
case (int)EIndex.Chk4:
case (int)EIndex.Chk5:
case (int)EIndex.ChkMihakko:
case (int)EIndex.ChkSaihakko:
case (int)EIndex.ChkNohinSeikyu:
if (((CheckBox)detailControls[i]).Checked)
{
item += "," + detailControls[i].Text;
}
else
{
item += ",";
}
break;
default:
item += "," + detailControls[i].Text;
break;
}
}
L_Log_Entity lle = new L_Log_Entity
{
InsertOperator = this.InOperatorCD,
PC = this.InPcID,
Program = this.InProgramID,
OperateMode = "",
KeyItem = item
};
return(lle);
}
/// <summary>
/// get Log information
/// print log
/// </summary>
private L_Log_Entity Get_L_Log_Entity()
{
L_Log_Entity lle = new L_Log_Entity();
string item = detailControls[0].Text;
for (int i = 1; i <= (int)EIndex.DayEnd; i++)
{
item += "," + detailControls[i].Text;
}
lle = new L_Log_Entity
{
InsertOperator = this.InOperatorCD,
PC = this.InPcID,
Program = this.InProgramID,
OperateMode = "",
KeyItem = item
};
return(lle);
}
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_Shiirekakeritsu(M_OrderRate_Entity moe, string xml, L_Log_Entity log_data)
{
string sp = "M_OrderRate_Update";
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@xml", new ValuePair {
value1 = SqlDbType.VarChar, value2 = xml
} },
{ "@VendorCD", new ValuePair {
value1 = System.Data.SqlDbType.VarChar, value2 = moe.VendorCD
} },
{ "@StoreCD", new ValuePair {
value1 = System.Data.SqlDbType.VarChar, value2 = moe.StoreCD
} },
{ "@ChangeDate", new ValuePair {
value1 = System.Data.SqlDbType.VarChar, value2 = moe.ChangeDate
} },
{ "@Rate", new ValuePair {
value1 = System.Data.SqlDbType.VarChar, value2 = moe.Rate
} },
{ "@Operator", new ValuePair {
value1 = SqlDbType.VarChar, value2 = moe.Operator
} }, //ses
{ "@Program", new ValuePair {
value1 = SqlDbType.VarChar, value2 = moe.ProgramID
} },
{ "@PC", new ValuePair {
value1 = SqlDbType.VarChar, value2 = moe.PC
} },
{ "@OperateMode", new ValuePair {
value1 = SqlDbType.VarChar, value2 = moe.ProcessMode
} },
{ "@KeyItem", new ValuePair {
value1 = SqlDbType.VarChar, value2 = moe.Key
} }
};
return(SelectData(dic, sp));
}
private bool Save()
{
string datetime = DateTime.Now.ToString();
mmbe = new M_MakerBrand_Entity();
mmbe.KAICD = loginInfo.CompanyCode;
mmbe.MakerCD = ucMaker.UC_Code;
mmbe.BrandCD = ucBrand.UC_Code;
mmbe.DatasourceMakerCD = uc_DatasourceMaker.UC_Code;
mmbe.InsertOperator = loginInfo.OperatorCode;
mmbe.InsertDateTime = datetime;
lle = new L_Log_Entity();
lle.OperateDate = DateTime.Now.ToString();
lle.Program = "PSKS0102M";
lle.PC = loginInfo.PcName;
lle.InsertOperator = loginInfo.OperatorCode;
lle.OperateMode = "新規";
lle.KeyItem = ucMaker.UC_Code + " " + ucBrand.UC_Name;
mmbe.dt1 = dtTemp;
return(psks0102mbl.M_MakerBrand_Insert_Xml(mmbe, lle));
}
/// <summary>
/// get Log information
/// print log
/// </summary>
private L_Log_Entity Get_L_Log_Entity()
{
L_Log_Entity lle = new L_Log_Entity();
DataTable table = CheckData(1);
string item = table.Rows[0]["PayPlanNO"].ToString();
for (int i = 1; i < table.Rows.Count; i++)
{
item += "," + table.Rows[i]["PayPlanNO"].ToString();
}
lle = new L_Log_Entity
{
InsertOperator = this.InOperatorCD,
PC = this.InPcID,
Program = this.InProgramID,
OperateMode = "",
KeyItem = item
};
return(lle);
}
private L_Log_Entity Get_L_Log_Entity()
{
L_Log_Entity lle = new L_Log_Entity();
DataTable table = CheckData();
string item = txtTargetdate.Text;
for (int i = 0; i < table.Rows.Count; i++)
{
item += "," + table.Rows[i]["CustomerCD"].ToString();
}
lle = new L_Log_Entity
{
InsertOperator = this.InOperatorCD,
PC = this.InPcID,
Program = this.InProgramID,
OperateMode = "",
KeyItem = item
};
return(lle);
}
private L_Log_Entity Get_L_Log_Entity(DataTable dtPrint)
{
L_Log_Entity lle = new L_Log_Entity();
string item = string.Empty;
foreach (DataRow row in dtPrint.Rows)
{
item += "," + row["RackNO"].ToString();
}
lle = new L_Log_Entity
{
InsertOperator = this.InOperatorCD,
PC = this.InPcID,
Program = this.InProgramID,
OperateMode = "",
KeyItem = item
};
return(lle);
}
/// <summary>
/// get Log information
/// print log
/// </summary>
private L_Log_Entity Get_L_Log_Entity()
{
string item = detailControls[0].Text;
for (int i = 1; i <= (int)EIndex.OrderDateTo; i++)
{
item += "," + detailControls[i].Text;
}
if (ChkMikakutei.Checked)
{
item += "," + ChkMikakutei.Text;
}
if (!string.IsNullOrWhiteSpace(CboSoukoName.Text))
{
item += "," + CboSoukoName.SelectedValue.ToString();
}
if (ChkKanbai.Checked)
{
item += "," + ChkKanbai.Text;
}
if (ChkFuyo.Checked)
{
item += "," + ChkFuyo.Text;
}
item += "," + detailControls[(int)EIndex.OrderCD].Text;
L_Log_Entity lle = new L_Log_Entity
{
InsertOperator = this.InOperatorCD,
PC = this.InPcID,
Program = this.InProgramID,
OperateMode = "",
KeyItem = item
};
return(lle);
}
//end
private bool InsertData()
{
DateTime datetime = DateTime.Now;
psks0108ibl = new PSKS0108I_BL();
L_Log_Entity LogData = new L_Log_Entity();
LogData.OperateDate = datetime.ToString("yyyy/MM/dd");
LogData.OperateTime = datetime.ToString("HH:mm");
LogData.InsertOperator = loginInfo.OperatorCode;
LogData.Program = "PSKS0108I";
LogData.PC = loginInfo.PcName;
#region copy file
//String sourcePath = bd.path_108i("S_path", @"\\192.168.0.14\ablesoft\CONPHAS-GENERAL\DATA");
//String targetPath = bd.path_108i("T_Path", @"\\192.168.0.5\Dropbox (Capital Group)\Capital backup\systemdata\inventory\ShopData\108I");
// string fileName = "FreeDAT.mdb";
//string s = System.IO.Path.Combine(sourcePath, fileName);
//string destFile = System.IO.Path.Combine(targetPath, fileName);
string shopFlag = "0";
//if(File.Exists(s))
//{
// System.IO.File.Copy(s, destFile, true);
// shopFlag = "1";
//}
#endregion
bool result = psks0108ibl.T_RONRI_ZAIKO_Insert(LogData, datetime.ToString(), shopFlag);
//bool result = true;
//if (File.Exists(destFile))
// File.Delete(destFile);
return(result);
}//更新処理１
public bool L_Log_Insert(L_Log_Entity lle)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@InsertOperator", new ValuePair {
value1 = SqlDbType.VarChar, value2 = lle.InsertOperator
} },
{ "@Program", new ValuePair {
value1 = SqlDbType.VarChar, value2 = lle.Program
} },
{ "@PC", new ValuePair {
value1 = SqlDbType.VarChar, value2 = lle.PC
} },
{ "@OperateMode", new ValuePair {
value1 = SqlDbType.VarChar, value2 = lle.OperateMode
} },
{ "@KeyItem", new ValuePair {
value1 = SqlDbType.VarChar, value2 = lle.KeyItem
} }
};
return(InsertUpdateDeleteData(dic, "L_Log_Insert"));
}
/// <summary>
/// Button Click For FLag Change
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnChange_Click(object sender, EventArgs e)
{
var btn = (Button)sender;
mme = new M_MultiPorpose_Entity();
lle = new L_Log_Entity();
mme.ID = "108";
//mme.Num1 = "1";
mme.InsertOperator = lle.InsertOperator = loginInfo.OperatorCode;
mme.InsertDateTime = lle.OperateDate = DateTime.Now.ToString();
mme.Program = lle.Program = "PSKS0114C";
lle.PC = loginInfo.PcName;
//lle.OperateMode = "処理開始";
if (btn.Text == "開始")
{
if (lblSKSMode.Text != "処理実行中")
{
lblSKSMode.Text = "処理実行中";
lblSKSMode.BackColor = Color.FromArgb(0, 176, 240);
mme.Num1 = "1";
psks0114cbl.M_MultiPorposeNum1_Update(mme, lle);
}
}
else
{
if (lblSKSMode.Text != "処理停止中")
{
lblSKSMode.Text = "処理停止中";
lblSKSMode.BackColor = Color.Yellow;
mme.Num1 = "0";
psks0114cbl.M_MultiPorposeNum1_Update(mme, lle);
}
}
}
private L_Log_Entity Get_L_Log_Entity()
{
L_Log_Entity lle = new L_Log_Entity();
if (chkRelatedPrinting.Checked == true)
{
chk = 1;
}
else
{
chk = 0;
}
lle = new L_Log_Entity
{
InsertOperator = this.InOperatorCD,
PC = this.InPcID,
Program = this.InProgramID,
OperateMode = "",
KeyItem = txtTargetDate.Text + "," + cboSouko.AccessibilityObject.Name + "," + chk.ToString()
};
return(lle);
}
private L_Log_Entity Get_L_Log_Entity()
{
L_Log_Entity lle = new L_Log_Entity();
if (chkBalancePrint.Checked == true)
{
chk = 1;
}
else
{
chk = 0;
}
lle = new L_Log_Entity
{
InsertOperator = this.InOperatorCD,
PC = this.InPcID,
Program = this.InProgramID,
OperateMode = "",
KeyItem = txtTargetYear.Text + "," + cboStoreAuthorizations.AccessibilityObject.Name + "," + chk.ToString()
};
return(lle);
}
private void UpdateData()
{
if ((DSP_MSG("Q101", string.Empty, string.Empty, string.Empty, string.Empty, string.Empty).Equals("1")))
{
DataTable dtUpdate = new DataTable();
dtUpdate.Columns.Add("OperatorCD");
dtUpdate.Columns.Add("AdminCD");
dtUpdate.Columns.Add("Shijisho");
dtUpdate.Columns.Add("Memo");
dt = dgvPSKS0102S.DataSource as DataTable;
foreach (DataRow dr in dt.Rows)
{
if (dr.RowState == DataRowState.Modified)
{
DataRow row = dtUpdate.NewRow();
row["OperatorCD"] = dr["OperatorCD"];
row["AdminCD"] = dr["AdminCD"];
row["Shijisho"] = dr["Shijisho"];
row["Memo"] = dr["Memo"];
dtUpdate.Rows.Add(row);
}
}
if (dtUpdate.Rows.Count > 0)
{
zaikokanri = new M_Zaiko_Kanri_Entity();
zaikokanri.xml = p102Sbl.DataTableToXml(dtUpdate);
lle = GetLogData();
if (p102Sbl.PSKS0120S_Update(zaikokanri, lle))
{
DSP_MSG("I101", string.Empty, string.Empty, string.Empty, string.Empty, string.Empty);
}
}
}
}
private void DataDelete()
{
gdvPSKS0119M.EndEdit();
adminCD = string.Empty;
if (gdvPSKS0119M.Rows.Count > 0)
{
if (ArradminCD.Count > 0)
{
adminCD = string.Join(",", (string[])ArradminCD.ToArray(Type.GetType("System.String")));
}
if (string.IsNullOrWhiteSpace(adminCD))
{
DSP_MSG("E805", string.Empty, string.Empty, string.Empty, string.Empty, string.Empty); //Please! Check the Checkbox
}
else
{
mzke = new M_Zaiko_Kanri_Entity
{
OperatorCD = loginInfo.OperatorCode,
AdminCD = adminCD,
};
lle = new L_Log_Entity
{
Program = "PSKS0119M",
PC = loginInfo.PcName,
OperateMode = "Delete",
};
if (psks0119mbl.M_Zaiko_RenkanriDelete(mzke, lle))
{
DSP_MSG("I102", string.Empty, string.Empty, string.Empty, string.Empty, string.Empty);
Clear();
txtFilePath.Focus();
}
}
}
}
/// <summary>
/// log insert
/// </summary>
/// <param name="lle"></param>
public void L_Log_Insert(L_Log_Entity lle)
{
L_Log_DL lldl = new L_Log_DL();
lldl.L_Log_Insert(lle);
}
public DataTable CheckExistName1_0303I(T_NyuukinMeisai_Entity NyuukinMeisai_data, L_Log_Entity lle, string twobytes)
{
Dictionary <string, string> dic = new Dictionary <string, string>();
dic.Add("@OperatorCD", lle.InsertOperator);
dic.Add("@date", lle.InsertDateTime);
dic.Add("@Filename", twobytes);
dic.Add("@XML", NyuukinMeisai_data.xml);
return(SelectData(dic, "CheckExistName1_0303I"));
}
