Exemplo n.º 1
0
        /// <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);
            }
        }
Exemplo n.º 2
0
        /// <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));
        }