/// <summary> /// 単価取得処理 /// </summary> /// <param name="fue"></param> /// <returns></returns> public bool Fnc_UnitPrice(Fnc_UnitPrice_Entity fue) { Function_DL fdl = new Function_DL(); DataTable dt = fdl.Fnc_UnitPrice(fue); if (dt.Rows.Count > 0) { fue.ZeikomiTanka = Z_SetStr(dt.Rows[0]["ZeikomiTanka"]); fue.ZeinukiTanka = Z_SetStr(dt.Rows[0]["ZeinukiTanka"]); fue.Zeiritsu = Z_SetStr(dt.Rows[0]["Zeiritsu"]); fue.Zei = Z_SetStr(dt.Rows[0]["Zei"]); fue.GenkaTanka = Z_SetStr(dt.Rows[0]["GenkaTanka"]); fue.Bikou = dt.Rows[0]["Bikou"].ToString(); return(true); } else { fue.ZeikomiTanka = "0"; fue.ZeinukiTanka = "0"; fue.Zeiritsu = "0"; fue.Zei = "0"; fue.GenkaTanka = "0"; fue.Bikou = ""; return(false); } }
/// <summary> /// 単価取得処理 /// </summary> /// <param name="fue"></param> /// <returns></returns> public DataTable Fnc_UnitPrice(Fnc_UnitPrice_Entity fue) { string sp = "Fnc_UnitPrice"; Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair> { { "@AdminNo", new ValuePair { value1 = SqlDbType.Int, value2 = fue.AdminNo } }, { "@ChangeDate", new ValuePair { value1 = SqlDbType.VarChar, value2 = fue.ChangeDate } }, { "@CustomerCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = fue.CustomerCD } }, { "@StoreCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = fue.StoreCD } }, { "@SaleKbn", new ValuePair { value1 = SqlDbType.TinyInt, value2 = fue.SaleKbn } }, { "@Suryo", new ValuePair { value1 = SqlDbType.Int, value2 = fue.Suryo } } }; return(SelectData(dic, sp)); }