public bool JuchuuTorikomiAPI_Insert_Update(D_APIRireki_Entity mre) { Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair> { { "@Num1", new ValuePair { value1 = SqlDbType.Int, value2 = mre.ShowMode } }, { "@Operator", new ValuePair { value1 = SqlDbType.VarChar, value2 = mre.Operator } }, { "@Program", new ValuePair { value1 = SqlDbType.VarChar, value2 = mre.ProgramID } }, { "@PC", new ValuePair { value1 = SqlDbType.VarChar, value2 = mre.PC } }, { "@OperateMode", new ValuePair { value1 = SqlDbType.VarChar, value2 = null } }, { "@KeyItem", new ValuePair { value1 = SqlDbType.VarChar, value2 = mre.Key } } }; return(InsertUpdateDeleteData(dic, "D_APIRireki_Insert_Update")); }
private void btnStop_Click(object sender, EventArgs e) { lblKakuteiMode.Text = "処理停止中"; lblKakuteiMode.BackColor = Color.FromArgb(255, 255, 0); showmode = 0; mre = GetPCAP0208IEnity(); pcapbl.JuchuuTorikomiAPI_Insert_Update(mre); }
public bool D_APIDetail_YahooList(D_APIRireki_Entity d_API, DataTable dtorder) { var dt = dtorder.DataSet.Tables[2].Copy(); //foreach (DataRow dr in dtorder.Rows) //{ // dt.ImportRow(dr); //} return(D_API_DL.D_APIDetail_YahooList(d_API, DataTableToXml(dt))); }
public bool D_APIDetail_YahooList(D_APIRireki_Entity apiRireki, string yahooorder) { string sp = "D_APIDetail_YahooList"; Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair> { { "@JuChuuXml", new ValuePair { value1 = SqlDbType.NVarChar, value2 = yahooorder } } }; UseTransaction = true; return(InsertUpdateDeleteData(dic, sp)); }
private D_APIRireki_Entity GetPCAP0208IEnity() { mre = new D_APIRireki_Entity { ShowMode = showmode.ToString(), Operator = InOperatorCD, ProgramID = InProgramID, PC = InPcID, Key = showmode.ToString(), APIKey = ApiKey.ToString(), State = state.ToString() }; return(mre); }
public bool JuchuuTorikomiAPI_D_APIControl_Insert_Update(D_APIRireki_Entity mre) { Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair> { { "@APIKey", new ValuePair { value1 = SqlDbType.Int, value2 = mre.APIKey } }, { "@Operator", new ValuePair { value1 = SqlDbType.VarChar, value2 = mre.Operator } }, { "@State", new ValuePair { value1 = SqlDbType.VarChar, value2 = mre.State } } }; return(InsertUpdateDeleteData(dic, "D_APIControl_Insert_Update")); }
private void CheckBox25_CheckedChanged(object sender, EventArgs e) { ApiKey = 25; if (CheckBox25.Checked == true) { lblStop25.Text = "STOP"; lblStop25.ForeColor = Color.Red; showmode = 1; mre = GetPCAP0208IEnity(); pcapbl.JuchuuTorikomiAPI_D_APIControl_Insert_Update(mre); } else { lblStop25.Text = ""; showmode = 0; mre = GetPCAP0208IEnity(); pcapbl.JuchuuTorikomiAPI_D_APIControl_Insert_Update(mre); } }
public bool JuchuuTorikomiAPI_D_APIControl_Insert_Update(D_APIRireki_Entity mre) { return(pcapdl.JuchuuTorikomiAPI_D_APIControl_Insert_Update(mre)); }
public bool D_APIRireki_D_YahooCount_Insert(D_APIRireki_Entity apiRireki, D_YahooCount_Entity yahooCount) { Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair> { { "@StoreCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = apiRireki.StoreCD } }, { "@APIKey", new ValuePair { value1 = SqlDbType.TinyInt, value2 = apiRireki.APIKey } }, { "@Status", new ValuePair { value1 = SqlDbType.TinyInt, value2 = yahooCount.Status.Equals("OK") ? "1": "0" } }, { "@Count_NewOrder", new ValuePair { value1 = SqlDbType.Int, value2 = yahooCount.Count_NewOrder } }, { "@Count_NewReserve", new ValuePair { value1 = SqlDbType.Int, value2 = yahooCount.Count_NewReserve } }, { "@Count_WaitPayment", new ValuePair { value1 = SqlDbType.Int, value2 = yahooCount.Count_WaitPayment } }, { "@Count_WaitShipping", new ValuePair { value1 = SqlDbType.Int, value2 = yahooCount.Count_WaitShipping } }, { "@Count_Shipping", new ValuePair { value1 = SqlDbType.Int, value2 = yahooCount.Count_Shipping } }, { "@Count_Reserve", new ValuePair { value1 = SqlDbType.Int, value2 = yahooCount.Count_Reserve } }, { "@Count_Holding", new ValuePair { value1 = SqlDbType.Int, value2 = yahooCount.Count_Holding } }, { "@Count_WaitDone", new ValuePair { value1 = SqlDbType.Int, value2 = yahooCount.Count_WaitDone } }, { "@Count_Suspect", new ValuePair { value1 = SqlDbType.Int, value2 = yahooCount.Count_Suspect } }, { "@Count_SettleError", new ValuePair { value1 = SqlDbType.Int, value2 = yahooCount.Count_SettleError } }, { "@Count_Refund", new ValuePair { value1 = SqlDbType.Int, value2 = yahooCount.Count_Refund } }, { "@Count_AutoDone", new ValuePair { value1 = SqlDbType.Int, value2 = yahooCount.Count_AutoDone } }, { "@Count_AutoWorking", new ValuePair { value1 = SqlDbType.Int, value2 = yahooCount.Count_AutoWorking } }, { "@Count_Release", new ValuePair { value1 = SqlDbType.Int, value2 = yahooCount.Count_Release } }, { "@Count_NoPayNumber", new ValuePair { value1 = SqlDbType.Int, value2 = yahooCount.Count_NoPayNumber } } }; UseTransaction = true; return(InsertUpdateDeleteData(dic, "D_APIRireki_YahooCount_Insert")); }
public bool D_APIRireki_D_YahooCount_Insert(D_APIRireki_Entity apiRireki, D_YahooCount_Entity yahooCount) { return(D_API_DL.D_APIRireki_D_YahooCount_Insert(apiRireki, yahooCount)); }