C# DataManager.QueryDataRes类代码示例

        /// <summary>
        /// 根据相应条件查询记录
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void BtQuery_Click(object sender, EventArgs e)
        {
            if (this.dateStart.Text == string.Empty)
            {
                XtraMessageBox.Show("请输入开始时间", "系统提示！");
                return;
            }
            if (this.dateEnd.Text == string.Empty)
            {
                XtraMessageBox.Show("请输入结束时间", "系统提示！");
                return;
            }

            NameObjectList pstrans = new NameObjectList();
            ParamManager.MergeParam(pstrans, this.paramwin);
            pstrans["StartDate"] = this.dateStart.EditValue.ToString();
            pstrans["EndDate"] = this.dateEnd.EditValue.ToString();
            pstrans["CommMac"] = this.lookCommMac.Text != null ? this.lookCommMac.Text.ToString() : null;
            //查询数据
            QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile);
            BindManager bg = new BindManager(this);
            ds = bg.BuildDataset(this.unitItem, pstrans);
            Report.viwReports View = new Granity.granityMgr.Report.viwReports();
            View.ReportName = "消费机收入汇总";
            View.ds = ds;
            View.StartTime = this.dateStart.Text.Trim();
            View.EndTime = this.dateEnd.Text.Trim();
            View.Activate();
            View.Dock = DockStyle.Fill;
            this.groReport.Controls.Clear();
            this.groReport.Controls.Add(View);
        }

 public void AddEateryStatus(string msg)
 {
     QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile);
     DataTable tab = this.dbgrid.DataSource as DataTable;
     if (null == tab) return;
     string CardMoney = "";
     string CardAddMoney = "";
     if (tab.Rows.Count > 0)
     {
         CardMoney = tab.Rows[tab.Rows.Count - 1]["�����"].ToString();
         CardAddMoney = tab.Rows[tab.Rows.Count - 1]["�������"].ToString();
     }
     if (CardMoney == basefun.valtag(msg, "{�����}") && CardAddMoney == basefun.valtag(msg, "{�ۼƲ������}")) return;
     if (i == 0) gridViewInfo.DeleteRow(0);
     DataRow dr = tab.NewRow();
     dr["����"] = basefun.valtag(msg, "{����}");
     dr["����ʱ��"] = basefun.valtag(msg, "{����ʱ��}");
     dr["�����"] = basefun.valtag(msg, "{�����}");
     dr["���"] = basefun.valtag(msg, "{���ѽ��}");
     dr["״̬"] = basefun.valtag(msg, "{״̬}");
     dr["���ѻ���"] = basefun.valtag(msg, "{���ѻ���}");
     dr["�������"] = basefun.valtag(msg, "{�ۼƲ������}");
     dr["���"] = i + 1;
     tab.Rows.Add(dr);
     i++;
     if (this.gridViewInfo.RowCount > 15)
         this.gridViewInfo.DeleteRow(this.gridViewInfo.RowCount - 1);
 }

 /// <summary>
 /// Ĭ�Ϸ�ʽ����ʵ��,����ʼ��ͬ���¼����,��ָ��ID
 /// </summary>
 public CmdProtocol()
     : base()
 {
     try { this.query = new QueryDataRes(dbSrc); }
     catch (Exception ex) { }
     this.TimeOut = new TimeSpan(200 * 10000);
     this.TimeFailLimit = new TimeSpan(600 * 10000);
     this.TimeLimit = new TimeSpan(600 * 10000);
     this.IsResposeHandle = this.isResponse;
 }

        /// <summary>
        /// 设备巡检管理构造函数
        /// </summary>
        public DeviceMonitorMgrBak()
        {
            this.unitItem = new UnitItem(DataAccRes.AppSettings("WorkConfig"), "设备监控服务");
            this.query = new QueryDataRes(this.unitItem.DataSrcFile);

            //2分钟执行一次
            tmService.Interval = 360000;
            tmService.Elapsed += new ElapsedEventHandler(tmService_Elapsed);
            tmService.Enabled = true;
            tmService.Start();
        }

        /// <summary>
        /// ʱ��β飬�������û���ţ����� ����
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnSelect_Click(object sender, EventArgs e)
        {
            DataTable tab = this.dbHitCard.DataSource as DataTable;
            if (null == tab) return;

            string filter = " a.ʱ��>=(SELECT convert(datetime,'{0}',121)) and a.ʱ��<=(SELECT convert(datetime,'{1}',121)) and(a.���� like'%{2}%' or a.�û���� like '%{2}%'or b.NAME like'%{2}%' or c.���� like '%{2}%' )";
            filter = string.Format(filter, this.cboStart.Text.Replace("'", "''"), this.cboEnd.Text.Replace("'", "''"), this.txtCheck.Text.Replace("'", "''"));
            QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile);
            tab.Clear();
            query.FillDataSet(tab.TableName, this.paramwin, ParamManager.setMacroParam(MacroPmType.FW, filter), this.dsUnit);
        }

 public DataTable getUser()
 {
     //�õ�����Դ
     QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile);
     this.dsUnit.Tables["������Ա"].Clear();
     //ִ�в�ѯ����
     NameObjectList ps = new NameObjectList();
     ps["ֵ����"] = cbbAccount.Text;
     query.FillDataSet("������Ա", ps, this.dsUnit);
     return dsUnit.Tables["������Ա"];
 }

 /// <summary>
 /// ��ȡ��������
 /// </summary>
 public void getNewDataByCardNo(string cardno)
 {
     NameObjectList pstrans = new NameObjectList();
     ParamManager.MergeParam(pstrans, this.paramwin);
     pstrans["����"] = cardno;
     //��ѯ����
     QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile);
     DataTable tab = dsUnit.Tables["�����"];
     tab.Clear();
     query.FillDataSet(tab.TableName, pstrans, this.dsUnit);
 }

 /// <summary>
 /// ������ѯ �û����,���ţ����������ż���
 /// </summary>
 /// <param name="sender"></param>
 /// <param name="e"></param>
 private void btnCheck_Click(object sender, EventArgs e)
 {
     DataTable tab = this.dbGrid.DataSource as DataTable;
     if (null == tab) return;
     string filter = "";
     filter = "(a.�û���� like '{0}'or a.���� like '%{0}%' or b.name like '%{0}%' or e.���� like '%{0}%')";
     filter = string.Format(filter, this.tbcardno.Text.Replace("'", "''"));
     QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile);
     tab.Clear();
     query.FillDataSet(tab.TableName, this.paramwin, ParamManager.setMacroParam(MacroPmType.FW, filter), this.dsUnit);
 }

 /// <summary>
 /// 根据门岗查询设备
 /// </summary>
 public void GetDEvById(string DoorID)
 {
     //获取当前单元名称
     DataTable tab = this.dbDev.DataSource as DataTable;
     if (null == tab) return;
     string filter = "";
     filter = "门岗ID='{0}'";
     filter = string.Format(filter, DoorID.Replace("'", "''"));
     QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile);
     tab.Clear();
     query.FillDataSet(tab.TableName, this.paramwin, ParamManager.setMacroParam(MacroPmType.FW, filter), this.ds);
 }

        private void trvDept_AfterSelect(object sender, TreeViewEventArgs e)
        {
            if (null == e.Node)
                return;
            //查询明细数据
            DataTable tabDetail = this.dsUnit.Tables["组织机构"];
            string tag = Convert.ToString(e.Node.Tag);
            NameObjectList ps = new NameObjectList();
            ParamManager.MergeParam(ps, this.paramwin);
            ParamManager.MergeParam(ps, ParamManager.createParam(tag));
            ps["UnitCode"] = basefun.valtag(e.Node.Tag.ToString(), "代码");
            if (null != tabDetail) tabDetail.Clear();
            QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile);
            query.FillDataSet("组织机构", ps, this.dsUnit);
            checkBox1.Checked = Convert.ToBoolean(this.dsUnit.Tables[0].Rows[0]["独立管理"].ToString());
            checkBox2.Checked = Convert.ToBoolean(this.dsUnit.Tables[0].Rows[0]["周一"].ToString());
            checkBox3.Checked = Convert.ToBoolean(this.dsUnit.Tables[0].Rows[0]["周二"].ToString());
            checkBox4.Checked = Convert.ToBoolean(this.dsUnit.Tables[0].Rows[0]["周三"].ToString());
            checkBox5.Checked = Convert.ToBoolean(this.dsUnit.Tables[0].Rows[0]["周四"].ToString());
            checkBox6.Checked = Convert.ToBoolean(this.dsUnit.Tables[0].Rows[0]["周五"].ToString());
            checkBox7.Checked = Convert.ToBoolean(this.dsUnit.Tables[0].Rows[0]["周六"].ToString());
            checkBox8.Checked = Convert.ToBoolean(this.dsUnit.Tables[0].Rows[0]["周日"].ToString());
            //if (null == tabChanged)
            //    return;

            //tabDetail = this.dsUnit.Tables["组织机构"];

            //TreeNode trnsel, trn;
            //trn = trnsel = e.Node;
            //string strdept = "";
            //while (null != trnsel)
            //{
            //    if (null != trn.FirstNode)
            //    {
            //        trn = trn.FirstNode;
            //        continue;
            //    }
            //    string t = Convert.ToString(trn.Tag);
            //    strdept += " or 部门='" + basefun.valtag(t, "部门") + "'";
            //    if (trnsel == trn)
            //        break;
            //    if (null != trn.NextNode)
            //        trn = trn.NextNode;
            //    else
            //        trn = trn.Parent;
            //    if (trnsel == trn)
            //        break;
            //}
            //if (strdept.Length > 0)
            //    strdept = strdept.Substring(3);
            //BindManager.UpdateTable(tabDetail, tabChanged, strdept);
        }

 /// <summary>
 /// 保存
 /// </summary>
 /// <param name="sender"></param>
 /// <param name="e"></param>
 private void BtSave_Click(object sender, EventArgs e)
 {
     QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile);
     bool isSuccess = BindManager.Save(query, this.ds, this.paramwin);
     if (!isSuccess)
     {
         XtraMessageBox.Show("保存失败，请检查数据是否合法！", "保存提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
     }
     else
     {
         XtraMessageBox.Show("保存成功！", "保存提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
     }
 }

 /// <summary>
 /// 条件查询
 /// </summary>
 /// <param name="sender"></param>
 /// <param name="e"></param>
 private void btnCheck_Click(object sender, EventArgs e)
 {
     string StartDtTime = this.cboStartDate.Text + " " + this.cboStartTime.Text;
     string EndDtTime = this.cboEndDate.Text + " " + this.cboEndTime.Text;
     //获取当前单元名称
     DataTable tab = this.dbGrid.DataSource as DataTable;
     if (null == tab) return;
     string filter = "";
     filter = "a.接班时间 between '{0}' and '{1}'and a.接班人 like '%{2}%'and a.交班人 like '%{3}%'";
     filter = string.Format(filter, StartDtTime.Replace("'", "''"), EndDtTime.Replace("'", "''"), this.cboStartEmp.Text.Replace("'", "''"), this.cboEndEmp.Text.Replace("'", "''"));
     QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile);
     tab.Clear();
     query.FillDataSet(tab.TableName, this.paramwin, ParamManager.setMacroParam(MacroPmType.FW, filter), this.dsUnit);
 }

 /// <summary>
 /// 根据条件查询相应的记录
 /// </summary>
 /// <param name="sender"></param>
 /// <param name="e"></param>
 private void BtQuery_Click(object sender, EventArgs e)
 {
     NameObjectList ps = new NameObjectList();
     ps["StartDate"] = this.dateStart.EditValue;
     ps["EndDate"] = this.dateEnd.EditValue;
     ps["Type"] = this.lookType.EditValue;
     ps["Dept"] = this.lookDept.EditValue;
     ps["EmployNO"] = (object)this.txtEmployNo.Text;
     ParamManager.MergeParam(ps, this.paramwin,false);
     //查询数据
     QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile);
     DataTable tab = this.grdConsumeList.DataSource as DataTable;
     tab.Clear();
     query.FillDataSet(tab.TableName, ps, this.ds);
 }

 public void ProcessRequest(HttpContext context)
 {
     if (ThreadManager.IsResetNeed)
     {
         CommiManager.GlobalManager.ClearCommand();
         ThreadManager.AbortAll();
         CommiManager.GlobalManager.ResetClient();
         DeviceEatery.ResetQueue();
         DeviceDoor.ResetQueue();
         DeviceChannel.ResetQueue();
         Thread.Sleep(new TimeSpan(0, 5, 0));
         return;
     }
     if (null == unitItem)
     {
         unitItem = new UnitItem(DataAccRes.AppSettings("WorkConfig"), "设备监控服务");
         query = new QueryDataRes(unitItem.DataSrcFile);
     }
     StreamReader reader = new StreamReader(context.Request.InputStream);
     NameValueCollection ps = HttpUtility.ParseQueryString(reader.ReadToEnd());
     string cmd = ps["cmd"];
     string response = "";
     cmdtrans.TimeOut = new TimeSpan(0, 0, 0, 0, 600);
     cmdtrans.TimeFailLimit = new TimeSpan(0, 0, 0, 2);
     switch (cmd)
     {
         //定时巡检数据
         case "getrecord":
             string dtcheck = ps["dtUpdate"];
             string depts = ps["depts"];
             DateTime dt = Convert.ToDateTime(dtcheck);
             response = this.getChannelRecord(dt, depts);
             break;
         //定时巡检数据
         case "getrdregion":
             string dtrefresh = ps["dtUpdate"];
             string regions = ps["regions"];
             DateTime dt2 = Convert.ToDateTime(dtrefresh);
             response = this.getRegionRecord(dt2, regions);
             break;
         //定时巡检数据
         case "getregionsum":
             string region = ps["region"];
             response = this.getRegionSum(region);
             break;
     }
     context.Response.Write(response);
 }

 /// <summary>
 /// 消费设备构造函数
 /// </summary>
 public DeviceEatery()
     : base()
 {
     if (null == unitItem)
         unitItem = new UnitItem(DataAccRes.AppSettings("WorkConfig"), "消费监控");
     this.query = new QueryDataRes(unitItem.DataSrcFile);
     //设置默认超时时间
     string inv = DataAccRes.AppSettings("commiTimeout");
     if (string.IsNullOrEmpty(inv))
         return;
     int timeout = 0;
     try
     {
         timeout = Convert.ToInt16(inv);
     }
     catch { return; }
     this.waitTime = new TimeSpan(0, 0, 0, 0, timeout / 10 * 35);
 }