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