/// <summary> /// プレゼント判断Function /// </summary> /// <param name="fre"></param> /// <returns></returns> public DataTable Fnc_Present(Fnc_Present_Entity fre) { string sp = "Fnc_Present"; Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair> { { "@AdminNO", new ValuePair { value1 = SqlDbType.Int, value2 = fre.AdminNO } }, { "@ChangeDate", new ValuePair { value1 = SqlDbType.VarChar, value2 = fre.ChangeDate } }, { "@StoreCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = fre.StoreCD } } }; return(SelectData(dic, sp)); }
public bool Fnc_Present(Fnc_Present_Entity fpe) { Function_DL fdl = new Function_DL(); DataTable dt = fdl.Fnc_Present(fpe); if (dt.Rows.Count > 0) { fpe.outPresentCD1 = dt.Rows[0]["PresentCD1"].ToString(); fpe.outPresentCD2 = dt.Rows[0]["PresentCD2"].ToString(); fpe.outPresentCD3 = dt.Rows[0]["PresentCD3"].ToString(); fpe.outPresentCD4 = dt.Rows[0]["PresentCD4"].ToString(); fpe.outPresentCD5 = dt.Rows[0]["PresentCD5"].ToString(); return(true); } else { return(false); } }