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