温馨提示:代码在线浏览功能只能做为源码浏览参考,如果想更进一步了解该代码请下载:酒店管理系统(ExtJs)源码
当前文件:
MyHotelManager/HotelBLL/MoneyInfoBLL.cs,打开代码结构图
MyHotelManager/HotelBLL/MoneyInfoBLL.cs,打开代码结构图1using System; 2
using System.Collections.Generic; 3
using System.Text; 4
using System.Data; 5
using HotelDAL; 6
7
namespace HotelBLL 8
{ 9
public class MoneyInfoBLL 10
{ 11
12
MoneyInfoDAO mid = new MoneyInfoDAO(); 13
14
15
/// <summary> 16
/// 查账(全查,根据时间查询都可以) 17
/// </summary> 18
/// <param name="BeginTime"></param> 19
/// <param name="EndTime"></param> 20
/// <returns></returns> 21
public string SerachMoney(string BeginTime, string EndTime) 22
{ 23
JSONHelper jsonHelp = new JSONHelper(); 24
jsonHelp.success = true; 25
DataSet ds = mid.SerachMoney(BeginTime, EndTime); 26
foreach (DataRow dr in ds.Tables[0].Rows) 27
{ 28
jsonHelp.AddItem("MoneyInfoId", dr["MoneyInfoId"].ToString()); 29
jsonHelp.AddItem("OpenTime", dr["OpenTime"].ToString()); 30
jsonHelp.AddItem("RoomNumber", dr["RoomNumber"].ToString()); 31
jsonHelp.AddItem("GuestNumber", dr["GuestNumber"].ToString()); 32
jsonHelp.AddItem("GuestName", dr["GuestName"].ToString()); 33
jsonHelp.AddItem("MoneyDate", dr["MoneyDate"].ToString()); 34
jsonHelp.AddItem("DetailsMoney", dr["DetailsMoney"].ToString()); 35
jsonHelp.ItemOk(); 36
} 37
string str = jsonHelp.ToString(); 38
return str; 39
} 40
} 41
} 42





}