/// <summary>
/// 出荷入力 代引きチェック
/// </summary>
/// <param name="mse"></param>
/// <returns></returns>
public DataTable M_Carrier_SelectForShukka(M_Carrier_Entity mse)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@CarrierCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.CarrierCD
} },
{ "@ChangeDate", new ValuePair {
value1 = SqlDbType.Date, value2 = mse.ChangeDate
} }
};
return(SelectData(dic, "M_Carrier_SelectForShukka"));
}
//public DataTable M_Carrier_Select(M_Carrier_Entity mke)
//{
// string sp = "M_Carrier_Select";
// Dictionary<string, ValuePair> dic = new Dictionary<string, ValuePair>
// {
// { "@CarrierCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = mke.CarrierCD } },
// { "@ChangeDate", new ValuePair { value1 = SqlDbType.VarChar, value2 = mke.ChangeDate } }
// };
// return SelectData(dic, sp);
//}
public DataTable M_Carrier_Bind(M_Carrier_Entity mke)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@ChangeDate", new ValuePair {
value1 = SqlDbType.Date, value2 = mke.ChangeDate
} },
{ "@DeleteFlg", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = mke.DeleteFlg
} },
};
return(SelectData(dic, "M_Carrier_Bind"));
}
public DataTable M_Carrier_SelectForShukka(M_Carrier_Entity mse)
{
M_Carrier_DL msdl = new M_Carrier_DL();
return(msdl.M_Carrier_SelectForShukka(mse));
}
//public bool M_Carrier_Select(M_Carrier_Entity mce)
//{
// DataTable dt = mdl.M_Carrier_Select(mce);
// if (dt.Rows.Count > 0)
// {
// mce.ChangeDate = dt.Rows[0]["ChangeDate"].ToString();
// mce.CarrierCD = dt.Rows[0]["CarrierCD"].ToString();
// mce.CarrierName = dt.Rows[0]["CarrierName"].ToString();
// mce.CarrierFlg = dt.Rows[0]["CarrierFlg"].ToString();
// mce.YahooCarrierCD = dt.Rows[0]["YahooCarrierCD"].ToString();
// mce.RakutenCarrierCD = dt.Rows[0]["RakutenCarrierCD"].ToString();
// mce.AmazonCarrierCD = dt.Rows[0]["AmazonCarrierCD"].ToString();
// mce.WowmaCarrierCD = dt.Rows[0]["WowmaCarrierCD"].ToString();
// mce.PonpareCarrierCD = dt.Rows[0]["PonpareCarrierCD"].ToString();
// mce.DeleteFlg = dt.Rows[0]["DeleteFlg"].ToString();
// mce.UsedFlg = dt.Rows[0]["UsedFlg"].ToString();
// mce.InsertOperator = dt.Rows[0]["InsertOperator"].ToString();
// mce.InsertDateTime = dt.Rows[0]["InsertDateTime"].ToString();
// mce.UpdateOperator = dt.Rows[0]["UpdateOperator"].ToString();
// mce.UpdateDateTime = dt.Rows[0]["UpdateDateTime"].ToString();
// return true;
// }
// else
// return false;
//}
public DataTable M_Carrier_Bind(M_Carrier_Entity mce)
{
return(mdl.M_Carrier_Bind(mce));
}
