예제 #1
0
        public ReturnValue GetList(int intStart, int intEnd,Drug model)
        {
            string strPageWhere = " Where TB.ROWNO >= @PageStart and TB.ROWNO<=@PageEnd ";
            string strWhere = string.Empty;
            SqlParameter[] parameters = {new SqlParameter("@PageStart", SqlDbType.Int),
                new SqlParameter("@PageEnd", SqlDbType.Int),
                new SqlParameter("@ProvinceCode", SqlDbType.NVarChar,50)};
            parameters[0].Value = intStart;
            parameters[1].Value = intEnd;
            parameters[2].Value = model.ProvinceCode;

            if (model.ChinaName.Length > 0)//ҩƷ����
            {
                strWhere += " And Drug.ChinaName Like '%" + model.ChinaName + "%' ";
            }
            if (model.Type2.Trim() != "999")//��������
            {
                strWhere += " And Drug.Type2 = '" + model.Type2 + "' ";
            }
            if (model.DrugClassCode.Trim() != "999")//ҩƷ����
            {
                strWhere += " And Drug.type2 + right('0'+replace(Convert(Varchar(2),DrugClassCode),'.',''),2)  = '" + model.DrugClassCode + "' ";
            }
            return SqlHelper.Query(GetList_SQL.Replace("@@@", strWhere) + strPageWhere, parameters);
        }
예제 #2
0
 public ReturnValue GetListCount(Drug model)
 {
     string strWhere = string.Empty;
     if (model.ChinaName.Length > 0)//ҩƷ����
     {
         strWhere += " And ChinaName Like '%"+model.ChinaName+"%' ";
     }
     if (model.Type2.Trim() != "999")//��������
     {
         strWhere += " And Type2 = '" + model.Type2 + "' ";
     }
     if (model.DrugClassCode.Trim() != "999")//ҩƷ����
     {
         strWhere += " And type2 + right('0'+replace(Convert(Varchar(2),DrugClassCode),'.',''),2) = '" + model.DrugClassCode + "' ";
     }
     return SqlHelper.Query(GetListCount_SQL.Replace("@@@",strWhere));
 }
예제 #3
0
 /// <summary>
 /// 
 /// </summary>
 /// <returns></returns>
 public ReturnValue GetList(int intPageNum,Drug model)
 {
     int intRowCount = 0;
     int intPageStart = 0;
     int intPageEnd = 0;
     ReturnValue returnV = dal.GetListCount(model);
     if (returnV.ErrorFlag)
     {
         intRowCount = returnV.Count;
     }
     else
     {
         return returnV;
     }
     intPageStart = (intPageNum - 1) * COM.GlobalVal.gloPage + 1;
     intPageEnd = intPageNum * COM.GlobalVal.gloPage;
     returnV = dal.GetList(intPageStart,intPageEnd,model);
     if (returnV.ErrorFlag)
     {
         returnV.Count = intRowCount;
     }
     return returnV;
 }