public bool T_AmazonYoteiDate_Delete(T_AmazonYoteiDate_Entity amazonyoteidate)
{
Dictionary <string, string> dic = new Dictionary <string, string>();
dic.Add("@OperatorCD", amazonyoteidate.OperatorCD);
return(InsertUpdateDeleteData(dic, "T_AmazonYoteiDate_Delete"));
}
public DataTable T_AmazonYoteiDate_Select(T_AmazonYoteiDate_Entity amazonyoteidate)
{
Dictionary <string, string> dic = new Dictionary <string, string>();
dic.Add("@OperatorCD", amazonyoteidate.OperatorCD);
dic.Add("@estimated_ship_date", amazonyoteidate.estimated_ship_date);
return(SelectData(dic, "T_AmazonYoteiDate_Select"));
}
public bool T_AmazonYoteiDate_Update(T_AmazonYoteiDate_Entity amazonyoteidate)
{
Dictionary <string, string> dic = new Dictionary <string, string>();
dic.Add("@OperatorCD", amazonyoteidate.OperatorCD);
dic.Add("@SEQ", amazonyoteidate.SEQ);
dic.Add("@amazon_order_id", amazonyoteidate.amazon_order_id);
dic.Add("@sku", amazonyoteidate.sku);
return(InsertUpdateDeleteData(dic, "T_AmazonYoteiDate_Update"));
}
// <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 DataTable PETC0306I_Select(T_AmazonYoteiDate_Entity tmie)
{
return(AmazonYoteidateDL.T_AmazonYoteiDate_Select(tmie));
}
public bool PETC0306I_Update(T_AmazonYoteiDate_Entity tmie)
{
return(AmazonYoteidateDL.T_AmazonYoteiDate_Update(tmie));
}
public bool PETC0306I_Insert(T_AmazonYoteiDate_Entity tmie)
{
return(AmazonYoteidateDL.T_AmazonYoteiDate_Insert(tmie));
}
public bool PETC0306I_DELETE(T_AmazonYoteiDate_Entity tmie)
{
return(AmazonYoteidateDL.T_AmazonYoteiDate_Delete(tmie));
}