Пример #1
0
        /// <summary>
        /// 获得一个房间的房费用
        /// </summary>
        /// <param name="statuid"></param>
        /// <returns></returns>
        public string GetGoodsFF(Model.occu_infor model)
        {
            DataTable dt = bllga.GetGoodsFh1(model.room_number, "and DATEDIFF(second ,'" + day + "',ga_date)>0 and DATEDIFF(second ,'" + day + "',ga_date)<86400");

            if (dt != null)
            {
                string s = dt.Rows[0][0].ToString();
                if (s != "")
                {
                    return(Convert.ToDouble(dt.Rows[0][0]).ToString("0.##"));
                }
                else
                {
                    return("0");
                }
            }
            return("0");
        }