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