DAl、BLL与一般处理程序

• DAL层

#region 获取任务列表信息
        public DataSet GetTaskList(string strWhere)
        {
            var strSql = new StringBuilder();
            strSql.Append(
                @" SELECT * from dbo.Chart_Parameter");
            if (strWhere.Trim() != "")
            {
                strSql.Append(" WHERE " + strWhere);
            }
            //strSql.Append(" ORDER BY CreatedTime DESC");
            return DbHelperSQL.Query(strSql.ToString());
        }
        #endregion

        #region MD5值 MD5Code
        public DataSet GetMD5Code(string strWhere_TerminalCode, string strWhere)
        {
            //var strSql = new StringBuilder();
            //strSql.Append(
            //    @" SELECT * from dbo.Chart_TaskLists");
            //if (strWhere.Trim() != "")
            //{
            //    strSql.Append(" WHERE " + strWhere);
            //}
            //strSql.Append(" ORDER BY CreateTime DESC");
            //return DbHelperSQL.Query(strSql.ToString());

            var strSql = new StringBuilder();
            strSql.Append(@"select * from
                        Sys_BindingInfor");// 条件语句 where  CarAlias = '1000'and TerminalCode != ''
            if (strWhere_TerminalCode.Trim() != "")
            {
                strSql.Append(" WHERE " + strWhere_TerminalCode);// 条件语句 where  CarAlias = '1000'and TerminalCode != ''
            }
            string terminalCode = string.Empty;
            DataSet ds = DbHelperSQLService.Query(strSql.ToString());

            if(null != ds && ds.Tables[0].Rows.Count > 0)
            {
                terminalCode = ds.Tables[0].Rows[0]["TerminalCode"].ToString();
            }

            var strSql2 = new StringBuilder();
            strSql2.Append(@"select MD5Value,MIN(TravelTime) as startTime,MAX(TravelTime) as endTime ,DBCFileName from RTL_" + terminalCode);// 条件语句 where TravelTime between '2013-03-29' and '2013-04-1'and MD5Value != ''
            strSql2.Append(@" left join Tr_DBCRelationalTB on RTL_" + terminalCode+".MD5Value=Tr_DBCRelationalTB.MD5Code");
            if (strWhere.Trim() != "")
            {
                strSql2.Append(" WHERE " + strWhere);
            }
            strSql2.Append(@"group by MD5Value,DBCFileName");
            return DbHelperSQLService.Query(strSql2.ToString());
        }
        #endregion

 

 

• BLL层

#region 任务列表信息查询
        public string GetTaskList()
        {
            DataSet ds = null;
            HttpContext currentContext = HttpContext.Current;

            string strWhere = string.Empty;
            //访问DAL层GetTaskList()
            ds = dal.GetTaskList(strWhere);

            if (ds != null && ds.Tables[0].Rows.Count > 0)
            {
                return new GridPager().GetJsonFromDataTable(ds.Tables[0], ds.Tables[0].Rows.Count);//GetJsonFromDataTable()
            }

            return null;
        }
        #endregion

        #region 任务列表信息查询
        public string GetMD5Code()
        {
            DataSet ds = null;
            HttpContext currentContext = HttpContext.Current;

            string name = currentContext.Request["name"];//参数名
            string time1 = currentContext.Request["time1"];//时间
            string time2 = currentContext.Request["time2"];//时间
            //string MD5CodeType = currentContext.Request["MD5CodeType"];//MD5Code值不为空
            /**/
            string strWhere_TerminalCode = string.Empty;//SQL查询条件
            string strWhere = string.Empty;//SQL查询条件
            if ( !string.IsNullOrEmpty(name) || !string.IsNullOrEmpty(time1) || !string.IsNullOrEmpty(time2))
            {
                //判断是否是“车辆（CarAlias）”
                if (!string.IsNullOrEmpty(name))
                {
                    if (string.IsNullOrEmpty(strWhere_TerminalCode))
                    {
                        strWhere_TerminalCode = "CarAlias='" + name + "' and TerminalCode != ''";
                    }
                }

                if (!string.IsNullOrEmpty(time1) || !string.IsNullOrEmpty(time2))
                {
                    if (string.IsNullOrEmpty(strWhere))
                    {
                        strWhere = " TravelTime >= '" + time1 + "'" + " and " + " TravelTime <= '" + time2 + "'" + " and MD5Value != '' " + "and MD5Code != ''";
                    }
                }

                ds = dal.GetMD5Code(strWhere_TerminalCode,strWhere);
            }
           
            if (ds != null && ds.Tables[0].Rows.Count > 0)
            {
                return new GridPager().GetJsonFromDataTable(ds.Tables[0], ds.Tables[0].Rows.Count);
            }
            return null;

            /*
            string strWhere = string.Empty;
            //访问DAL层GetMD5Code()
            ds = dal.GetMD5Code(strWhere);

            if (ds != null && ds.Tables[0].Rows.Count > 0)
            {
                return new GridPager().GetJsonFromDataTable(ds.Tables[0], ds.Tables[0].Rows.Count);//GetJsonFromDataTable()
            }

            return null;
            */
        }
        #endregion

 

• 一般处理程序

ChartTask.BLL.Chart_Parameter obj = new Chart_Parameter();
            context.Response.ContentType = "text/plain";
            //context.Response.Write("Hello World");

            string action = context.Request["action"];
            if (!String.IsNullOrEmpty(action))
            {
                switch (action)
                {
                    //任务列表
                    case "TaskList":
                        context.Response.Write(obj.GetTaskList());
                        break;
                    //MD5值
                    case "MD5Code":
                        context.Response.Write(obj.GetMD5Code());
                        break;
                   
                    default:
                        break;
                }
            }