Web/Finance/roomRecord.ashx.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
namespace Web.Finance
{
    /// <summary>
    /// roomRecord 的摘要说明
    /// </summary>
    public class roomRecord : IHttpHandler
    {

        public void ProcessRequest(HttpContext context)
        {
            context.Response.ContentType = "text/plain";
            string strJson = null;
            Model.tbRoomRecord model = new Model.tbRoomRecord();
            if (context.Request.Form["num"] != null)
                if (!string.IsNullOrEmpty(context.Request.Form["num"].Trim()))
                    model.R_RoomID = context.Request.Form["num"].Trim();


            model.H_Account = "admin";
            DataSet listModel=new DataSet();
            if (!string.IsNullOrEmpty(context.Request.Form["starttime"]) && !string.IsNullOrEmpty(context.Request.Form["endtime"]))
            {
                listModel = new BLL.tbRoomRecord().ChangeSettlementList(Convert.ToDateTime(context.Request.Form["starttime"]), Convert.ToDateTime(context.Request.Form["endtime"]), model, Convert.ToBoolean(context.Request.Form["flag"]));
                for (int i = 0; i < listModel.Tables[0].Rows.Count; i++)
                {
                    DataRow dr = listModel.Tables[0].Rows[i];
                    string strEndTime = "-----";
                    if (!string.IsNullOrEmpty(dr["RR_EndTime"].ToString()))
                    {
                        strEndTime = Convert.ToDateTime(dr["RR_EndTime"]).ToString("yyyy-MM-dd HH:mm:ss");
                    }
                    strJson += "{\"Id\":\"" + dr["R_ID"] + "\",\"RoomID\":\"" + dr["R_RoomID"] + "\",\"Name\":\"" + dr["RT_Name"] + "\",\"UserName\":\"" + dr["RR_Name"]
                        + "\",\"StartTime\":\"" + Convert.ToDateTime(dr["RR_StartTime"]).ToString("yyyy-MM-dd HH:mm:ss") + "\",\"Price\":\"" +
                        dr["R_Price"] + "\",\"Sex\":\"" + dr["RR_Sex"] + "\",\"IDType\":\"" + dr["CT_ID"] + "\",\"IDName\":\"" + dr["CT_Name"] + "\",\"IDNum\":\"" + dr["RR_CredentialsID"] + "\",\"Deposit\":\"" + dr["RR_Deposit"] + "\",\"SettlementPrice\":\""
                        + dr["RR_RealMoney"] + "\",\"EndTime\":\"" + strEndTime + "\",\"Remark\":\"" + dr["RR_Remark"] + "\"},";
                }
            }
            if (!string.IsNullOrEmpty(strJson))
                strJson = strJson.TrimEnd(',');

            strJson = "[" + strJson + "]";

            context.Response.Write(strJson);
        }

        public bool IsReusable
        {
            get
            {
                return false;
            }
        }
    }
}