C# Components.QueryParam类代码示例

 /// <summary>
 /// 根据用户登陆名,获取用户资料
 /// </summary>
 /// <param name="u_LoginName">用户名</param>
 /// <returns>用户实体类</returns>
 public static sys_UserTable Get_sys_UserTable(string u_LoginName)
 {
     QueryParam qp = new QueryParam();
     qp.Where = string.Format(" Where U_LoginName='{0}' ",u_LoginName);
     int rInt = 0;
     return BusinessFacade.sys_UserList(qp,out rInt)[0] as sys_UserTable;
 }

        private void InitDropDown()
        {
            int gp_pid = 0;
            sys_GroupTable gp = BusinessFacade.sys_GroupDisp(UserData.GetUserDate.U_GroupID);
            //当前不为检测站，就取得当前单位父节点
            if (gp.Type != 2)
            {
                gp = BusinessFacade.sys_GroupDisp(gp.G_ParentID);

            }
            gp_pid = gp.GroupID;

            QueryParam qp = new QueryParam();
            qp.Where = "Where G_ParentID = " + gp_pid + " And Type = 1";
            int _Count = 0;
            ArrayList gplst = BusinessFacade.sys_GroupList(qp, out _Count);

            ListItem empty = new ListItem("请选择检定地点", "0");
            DropDownList1.Items.Add(empty);

            if (_Count > 0)
            {
                ListItem li = null;
                foreach (sys_GroupTable item in gplst)
                {
                    li = new ListItem(item.G_CName, item.GroupID.ToString());
                    DropDownList1.Items.Add(li);
                }
            }
        }

        private void OnStart()
        {
            QueryParam qp = new QueryParam();
            qp.Orderfld = " M_Applicationid,M_OrderLevel ";
            qp.OrderType = 0;
            qp.Where = Common.ApplicationID != 0 ? string.Format("Where M_Close=0 and M_ParentID=0 and M_ApplicationID ={0}", Common.ApplicationID) : "Where M_Close=0 and M_ParentID=0 ";
            int RecordCount = 0;
            ArrayList lst = BusinessFacade.sys_ModuleList(qp, out RecordCount);
            int i = 1;
            foreach (sys_ModuleTable var in lst)
            {
                ArrayList lst2 = BusinessFacade.GetPermissionModuleSub(var.ModuleID);
                if (lst2.Count > 0)
                {
                    if (i == 1)
                        sb_FramesetRows.Append("21,*");
                    else
                        sb_FramesetRows.Append(",21,0");

                    sb_HTMLSrc.AppendFormat("<frame name={0}menubarbutton_{1}{0} target={0}pagemain{0} scrolling={0}no{0} noresize src={0}Menu1_Button.aspx?APCatalogueID={1}&OrderNo={2}&APCatCName={3}{0}>{4}<frame name={0}menubar_{1}{0} target={0}pagemain{0} scrolling={0}auto{0} noresize src={0}Menu1_Disp.aspx?ModuleID={5}&OrderNo={2}{0} STYLE={0}border-width:1; border-bottom-style:solid{0}>{4}", "\"", var.ModuleID, i, var.M_CName, "\n",var.ModuleID);

                    i++;
                }
            }
        }

 private void BindDataList()
 {
     QueryParam qp = new QueryParam();
     int RecordCount = 0;
     List<CommandAssembleEntity> lst = BusinessFacadeShanliTech_HLD_Business.CommandAssembleList(qp, out RecordCount);
     List<CommandAssembleEntity> distList = new List<CommandAssembleEntity>();
     if (RecordCount > 0)
     {
         CommandAssembleEntity cae = null;
         foreach (CommandAssembleEntity item in lst)
         {
             cae = distList.Find(x => { return item.DeviceModel.Equals(x.DeviceModel); });
             if (cae == null || cae.ID <= 0)
             {
                 distList.Add(item);
             }
             else
             {
                 continue;
             }
         }
     }
     GridView1.DataSource = distList;
     GridView1.DataBind();
 }

        private void BindData()
        {
            if (Common.GetOnlineCountType == OnlineCountType.DataBase)
            {
                QueryParam qp = new QueryParam();
                qp.PageIndex = AspNetPager1.CurrentPageIndex;
                qp.PageSize = AspNetPager1.PageSize;
                int RecordCount = 0;
                ArrayList lst = BusinessFacade.sys_OnlineList(qp, out RecordCount);

                GridView1.DataSource = CountOnlineList(lst);
                GridView1.DataBind();
                this.AspNetPager1.RecordCount = RecordCount;
            }
            else
            {
                AspNetPager1.RecordCount = FrameWorkPermission.UserOnlineList.AllCount;
                ArrayList lst = new ArrayList();
                for (int i = AspNetPager1.StartRecordIndex; i <= AspNetPager1.EndRecordIndex; i++)
                {
                    lst.Add(FrameWorkPermission.UserOnlineList.GetList[i - 1]);
                }
                GridView1.DataSource = lst;
                GridView1.DataBind();
            }
        }

        protected void Button1_Click(object sender, EventArgs e)
        {
            FrameWorkPermission.CheckPermissionVoid(PopedomType.Orderby);
            string ItemsList = (string)Common.sink(OrderByListItems.UniqueID, MethodType.Post, 100000, 1, DataType.Str);
            if (ItemsList.Length > 0)
            {
                int RecordCount = 0;
                ArrayList lst = new ArrayList();
                QueryParam qp = new QueryParam();

                string[] ItemsLists = ItemsList.Split(',');
                for (int i = 0; i < ItemsLists.Length; i++)
                {
                    BusinessFacade.Update_Table_Fileds("sys_Module", string.Format("M_OrderLevel='{0}{1}'", Common.FillZero(i.ToString(), 2), "00"), string.Format("ModuleID={0}", ItemsLists[i]));
                    qp.Orderfld = "M_OrderLevel ";
                    qp.OrderType = 0;
                    qp.Where = string.Format("Where M_ParentID={0}", ItemsLists[i]);
                    RecordCount = 0;
                    lst = BusinessFacade.sys_ModuleList(qp, out RecordCount);
                    if (lst.Count > 0)
                    {
                        RecordCount = 1;
                        foreach (sys_ModuleTable var in lst)
                        {
                            BusinessFacade.Update_Table_Fileds("sys_Module", string.Format("M_OrderLevel='{0}{1}'", Common.FillZero(i.ToString(), 2), Common.FillZero(RecordCount.ToString(), 2)), string.Format("ModuleID={0}", var.ModuleID));
                            RecordCount++;
                        }
                    }
                }
            }

            EventMessage.MessageBox(1, "�����ɹ�", string.Format("����{0}ģ��ɹ�!",AppName), Icon_Type.OK, Common.GetHomeBaseUrl(string.Format("ModuleList.aspx?S_ID={0}&AppName={1}",S_ID,AppName)));
        }

 public string GetSubCount(string F_Key)
 {
     QueryParam qp = new QueryParam();
     qp.Where = string.Format("Where V_F_Key='{0}'", Common.inSQL(F_Key));
     int RecordCount = 0;
     BusinessFacade.sys_FieldValueList(qp, out RecordCount);
     return RecordCount.ToString();
 }

        private void OnStart()
        {
            sys_GroupTable gt = BusinessFacade.sys_GroupDisp(GroupID);
            this.G_CName.Text = gt.G_CName;

            this.Address_Input.Text = gt.Address;
            this.CertificateNumber_Input.Text = gt.CertificateNumber;
            this.Fax_Input.Text = gt.Fax;
            this.Tel_Input.Text = gt.Tel;
            this.EmailAddress_Input.Text = gt.EmailAddress;
            this.ZipCode_Input.Text = gt.ZipCode;
            this.G_Type_DropDown.SelectedValue = gt.Type.ToString();
            
            if (gt.G_ParentID == 0)
                G_ParentID_Txt.Text = "部门列表";
            else
                G_ParentID_Txt.Text = BusinessFacade.sys_GroupDisp(gt.G_ParentID).G_CName;
            CatListTitle.Text = string.Format("<a href='GroupList.aspx'>部门列表</a>{0}", BusinessFacade.GetGroupTitle(GroupID));
            //判断是否删除
            if (CMD == "Delete")
            {
                FrameWorkPermission.CheckPermissionVoid(PopedomType.Delete);
                
                //删除子分类
                DeleteCat(GroupID);
                //删除当前分类
                BusinessFacade.Update_Table_Fileds("sys_Group", "G_Delete=1", string.Format("GroupID={0}", GroupID));
                





                if (gt.G_ParentID!=0)
                {
                    //更新父类子类数
                    BusinessFacade.Update_Table_Fileds("sys_Group", "G_ChildCount=G_ChildCount-1", string.Format("GroupID={0}", gt.G_ParentID));
                    //更新父类子类排序  
                    int RecordCount = 0;
                    QueryParam qp = new QueryParam();
                    qp.Where = string.Format("Where G_ParentID={0} and G_Delete=0",gt.G_ParentID);
                    qp.Orderfld = "G_Level,G_ShowOrder";
                    qp.OrderType = 0;
                    ArrayList lst = BusinessFacade.sys_GroupList(qp,out RecordCount);
                    RecordCount = 1;
                    foreach (sys_GroupTable var in lst)
                    {
                        BusinessFacade.Update_Table_Fileds("sys_Group", string.Format("G_ShowOrder={0}", RecordCount), string.Format("GroupID={0}", var.GroupID));
                        RecordCount++;
                    }

                }
                EventMessage.MessageBox(1, "操作成功", string.Format("删除部门({0})成功!",gt.G_CName), Icon_Type.OK, Common.GetHomeBaseUrl("GroupList.aspx"),Common.BuildJs);

            }
        }

 private void BindDataList()
 {
     QueryParam qp = new QueryParam();
     qp.Where = string.Format("Where DeviceNum = '{0}' And DeviceModel = '{1}' And FunctionCode = '{2}'", _Device.DeviceNum, _Device.DeviceModel, _Function.FunctionCode);
     qp.OrderType = 1;
     int RecordCount = 0;
     List<Device_Permition_DataEntity> lst = BusinessFacadeShanliTech_HLD_Business.Device_Permition_DataList(qp, out RecordCount);
     GridView1.DataSource = lst;
     GridView1.DataBind();
 }

 public int GetCatCount(int ApplicationID)
 {
     QueryParam qp = new QueryParam();
     qp.Orderfld = " M_OrderLevel ";
     qp.OrderType = 0;
     qp.Where = string.Format("Where M_ApplicationID ={0} and M_ParentID=0 ", ApplicationID);
     int RecordCount = 0;
     ArrayList lst = BusinessFacade.sys_ModuleList(qp, out RecordCount);
     return RecordCount;
 }

 /// <summary>
 /// 返回sys_ApplicationsTable实体类的ArrayList对象
 /// </summary>
 /// <param name="qp">查询类</param>
 /// <param name="RecordCount">返回记录总数</param>
 /// <returns>sys_ApplicationsTable实体类的ArrayList对象</returns>
 public static ArrayList sys_ApplicationsList(QueryParam qp, out int RecordCount)
 {
     qp.TableName = "sys_Applications";
     qp.ReturnFields = "*";
     if (qp.Orderfld == null)
     {
         qp.Orderfld = "ApplicationID";
     }
     return DataProvider.Instance().sys_ApplicationsList(qp, out RecordCount);
 }

 /// <summary>
 /// �����˵�
 /// </summary>
 private void BindMenu()
 {
     QueryParam qp = new QueryParam();
     qp.Orderfld = " M_Applicationid,M_OrderLevel ";
     qp.OrderType = 0;
     qp.Where = Common.ApplicationID != 0 ? string.Format("Where M_Close=0 and M_ParentID=0 and M_ApplicationID ={0}", Common.ApplicationID) : "Where M_Close=0 and M_ParentID=0 ";
     int RecordCount = 0;
     ArrayList lst = BusinessFacade.sys_ModuleList(qp, out RecordCount);
     LeftMenu.DataSource = lst;
     LeftMenu.DataBind();
 }

 /// <summary>
 /// 绑定数据
 /// </summary>
 private void OnDisp()
 {
     QueryParam qp = new QueryParam();
     qp.Orderfld = " M_Applicationid,M_OrderLevel ";
     qp.OrderType = 0;
     qp.Where = string.Format("Where M_Close=0 and M_ParentID=0 and M_ApplicationID ={0}", ApplicationID);
     int RecordCount = 0;
     ArrayList lst = BusinessFacade.sys_ModuleList(qp, out RecordCount);
     Module_Main.DataSource = lst;
     Module_Main.DataBind();
 }

 /// <summary>
 /// 绑定数据
 /// </summary>
 private void BindDataList()
 {
     QueryParam qp = new QueryParam();
     qp.Where = string.Format("Where DeviceModel = '{0}'", DeviceModel);
     qp.Orderfld = Orderfld;
     qp.OrderType = OrderType;
     int RecordCount = 0;
     List<CommandAssembleEntity> lst = BusinessFacadeShanliTech_HLD_Business.CommandAssembleList(qp, out RecordCount);
     GridView1.DataSource = lst;
     GridView1.DataBind();
 }

 private void ListBind()
 {
     QueryParam qp = new QueryParam();
     qp.OrderType = 0;
     qp.PageIndex = Pager.CurrentPageIndex;
     qp.PageSize = Pager.PageSize;
     int RecordCount = 0;
     ArrayList lst = BusinessFacade.sys_ApplicationsList(qp, out RecordCount);
     GridView1.DataSource = lst;
     GridView1.DataBind();
     this.Pager.RecordCount = RecordCount;
 }