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); }
/// <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); }
/// <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); }
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); }