Exemplo n.º 1
0
        private static void QueryTData(HttpContext context)
        {
            string adddate  = context.Request.Params["adddate"].ToString();
            string username = Common.CookieHelper.GetCookieValue("username");
            string pageNum  = context.Request.Params["pageNum"].ToString();
            string pageSize = context.Request.Params["pageSize"].ToString();
            //AddDate='" + adddate + "' and
            string strwhere   = "IsDel=0 and  Uname='" + username + "'";
            string strorder   = "AddDate ASC";
            int    startIndex = Convert.ToInt32(pageNum);
            int    endIndex   = Convert.ToInt32(pageSize);

            // RuRo.BLL.QueryRecoder bll = new BLL.QueryRecoder();
            RuRo.BLL.SZY.QueryRecoder bll_QueryRecoder = new BLL.SZY.QueryRecoder();
            // DataSet ds = bll.GetListByPage(strwhere,strorder,startIndex,endIndex);
            DataSet ds = bll_QueryRecoder.GetQueryRecoderTrue_bll(endIndex, startIndex, strwhere, strorder); //按照页码获取列表
            List <Model.QueryRecoder>   list = bll_QueryRecoder.DataTableToList(ds.Tables[0]);               //转换为List
            Dictionary <string, string> dic  = new Dictionary <string, string>();
            //List<Model.QueryRecoder> list = bll.GetModelList("IsDel=0 and AddDate!='" + adddate + "' and Uname='" + username + "' order by AddDate DESC");
            string kk = FreezerProUtility.Fp_Common.FpJsonHelper.ObjectToJsonStr(list);

            dic.Add("Qdata", kk);                                                                                              //添加到DIC
            int count = bll_QueryRecoder.GetRecordCount("IsDel=0 and AddDate='" + adddate + "' and Uname='" + username + "'"); //获取表的总记录数

            dic.Add("total", count.ToString());                                                                                //添加到DIC
            string mes = FreezerProUtility.Fp_Common.FpJsonHelper.ObjectToJsonStr(dic);

            context.Response.Write(mes);
        }
Exemplo n.º 2
0
        /// <summary>
        /// 上传到freezerpro临床检验数据
        /// </summary>
        /// <param name="context"></param>
        private void PostData(HttpContext context)
        {
            // string code = context.Request.Params["code"].Trim();
            //string codeType = context.Request.Params["codeType"].Trim();
            string strRecoder = context.Request.Params["Recoder"];
            string username   = Common.CookieHelper.GetCookieValue("username").Trim();

            BLL.SZY.QueryRecoder bll = new BLL.SZY.QueryRecoder();
            string result            = bll.PostData(strRecoder, username);

            context.Response.Write(result);
        }
Exemplo n.º 3
0
 /// <summary>
 /// �ϴ���freezerpro�ٴ���������
 /// </summary>
 /// <param name="context"></param>
 private void PostData(HttpContext context)
 {
     // string code = context.Request.Params["code"].Trim();
     //string codeType = context.Request.Params["codeType"].Trim();
     string strRecoder = context.Request.Params["Recoder"];
     string username = Common.CookieHelper.GetCookieValue("username").Trim();
     BLL.SZY.QueryRecoder bll = new BLL.SZY.QueryRecoder();
     string result = bll.PostData(strRecoder, username);
     context.Response.Write(result);
 }
Exemplo n.º 4
0
 private static void QueryTData(HttpContext context)
 {
     string adddate = context.Request.Params["adddate"].ToString();
     string username = Common.CookieHelper.GetCookieValue("username");
     string pageNum = context.Request.Params["pageNum"].ToString();
     string pageSize = context.Request.Params["pageSize"].ToString();
     //AddDate='" + adddate + "' and
     string strwhere = "IsDel=0 and  Uname='" + username + "'";
     string strorder = "AddDate ASC";
     int startIndex = Convert.ToInt32(pageNum);
     int endIndex = Convert.ToInt32(pageSize);
     // RuRo.BLL.QueryRecoder bll = new BLL.QueryRecoder();
     RuRo.BLL.SZY.QueryRecoder bll_QueryRecoder = new BLL.SZY.QueryRecoder();
     // DataSet ds = bll.GetListByPage(strwhere,strorder,startIndex,endIndex);
     DataSet ds = bll_QueryRecoder.GetQueryRecoderTrue_bll(endIndex, startIndex, strwhere, strorder);//����ҳ���ȡ�б�
     List<Model.QueryRecoder> list = bll_QueryRecoder.DataTableToList(ds.Tables[0]);//ת��ΪList
     Dictionary<string, string> dic = new Dictionary<string, string>();
     //List<Model.QueryRecoder> list = bll.GetModelList("IsDel=0 and AddDate!='" + adddate + "' and Uname='" + username + "' order by AddDate DESC");
     string kk = FreezerProUtility.Fp_Common.FpJsonHelper.ObjectToJsonStr(list);
     dic.Add("Qdata", kk);//��ӵ�DIC
     int count = bll_QueryRecoder.GetRecordCount("IsDel=0 and AddDate='" + adddate + "' and Uname='" + username + "'");//��ȡ����ܼ�¼��
     dic.Add("total", count.ToString());//��ӵ�DIC
     string mes = FreezerProUtility.Fp_Common.FpJsonHelper.ObjectToJsonStr(dic);
     context.Response.Write(mes);
 }