/// <summary> /// 获得一个房间的商品费用 /// </summary> /// <param name="statuid"></param> /// <returns></returns> public string GetGoodsFh(Model.occu_infor model) { DataTable dt = bllga.GetGoodsFh(model.room_number, "and CONVERT(varchar(100), ga.ga_date,23)='" + day + "'"); if (dt != null) { string s = dt.Rows[0][0].ToString(); if (s != "") { return(dt.Rows[0][0].ToString()); } else { return("0"); } } return("0"); }
/// <summary> /// 获得一个房间的商品费用 /// </summary> /// <param name="statuid"></param> /// <returns></returns> public string GetGoodsFh(Model.occu_infor model) { DataTable dt = bllga.GetGoodsFh(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"); }