C# DataManager.QueryDataRes类代码示例

OStack程序员社区-中国程序员成长平台 › 门户 › 编程› c#›C#教程

原作者: [db:作者] 来自: [db:来源] 收藏邀请

本文整理汇总了C#中Estar.Business.DataManager.QueryDataRes类的典型用法代码示例。如果您正苦于以下问题：C# QueryDataRes类的具体用法？C# QueryDataRes怎么用？C# QueryDataRes使用的例子？那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。

QueryDataRes类属于Estar.Business.DataManager命名空间，在下文中一共展示了QueryDataRes类的20个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的C#代码示例。

示例1: BtQuery_Click

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

开发者ID:BillyWu，项目名称:Granitypark，代码行数:37，代码来源:FrmCosumeMac.cs

示例2: AddEateryStatus

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

开发者ID:BillyWu，项目名称:Granitypark，代码行数:28，代码来源:FrmEateryMonitor.cs

示例3: CmdProtocol

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

开发者ID:BillyWu，项目名称:Granitypark，代码行数:13，代码来源:CmdProtocol.cs

示例4: DeviceMonitorMgrBak

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

开发者ID:thisisvoa，项目名称:GranityApp2.5，代码行数:14，代码来源:DeviceMonitorMgrBak.cs

示例5: btnSelect_Click

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

开发者ID:BillyWu，项目名称:Granitypark，代码行数:16，代码来源:FrmHitCardRpt.cs

示例6: getUser

 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["������Ա"];
 }

开发者ID:BillyWu，项目名称:Granitypark，代码行数:11，代码来源:FrmLogin.cs

示例7: getNewDataByCardNo

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

开发者ID:BillyWu，项目名称:Granitypark，代码行数:14，代码来源:FrmCardCheck.cs

示例8: btnCheck_Click

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

开发者ID:BillyWu，项目名称:Granitypark，代码行数:16，代码来源:FrmCardDelayRpt.cs

示例9: GetDEvById

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

开发者ID:BillyWu，项目名称:Granitypark，代码行数:15，代码来源:FrmParkStallSet.cs

示例10: trvDept_AfterSelect

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

开发者ID:BillyWu，项目名称:Granitypark，代码行数:52，代码来源:FrmDepart.cs

示例11: BtSave_Click

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

开发者ID:BillyWu，项目名称:Granitypark，代码行数:18，代码来源:FrmCashRegisterII.cs

示例12: btnCheck_Click

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

开发者ID:BillyWu，项目名称:Granitypark，代码行数:19，代码来源:FrmOper.cs

示例13: BtQuery_Click

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

开发者ID:BillyWu，项目名称:Granitypark，代码行数:20，代码来源:FrmAddReduceMoney.cs

示例14: ProcessRequest

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

开发者ID:thisisvoa，项目名称:GranityApp2.5，代码行数:48，代码来源:hdlWorkerMonitor.cs

示例15: DeviceEatery

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

开发者ID:thisisvoa，项目名称:GranityApp2.5，代码行数:21，代码来源:DeviceEatery.cs

示例16: BtQuery_Click

        /// <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("�����뿪ʼʱ��", "ϵͳ��ʾ��", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            if (this.cboDoorName.Text == string.Empty)
            {
                XtraMessageBox.Show("��ѡ�����Ա", "ϵͳ��ʾ��", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }

            if (this.lookDate.EditValue == null)
            {
                XtraMessageBox.Show("��ѡ����", "ϵͳ��ʾ��", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            NameObjectList pstrans = new NameObjectList();
            ParamManager.MergeParam(pstrans, this.paramwin);
            pstrans["dt"] = this.dateStart.EditValue.ToString();
            pstrans["type"] = this.lookDate.EditValue.ToString();
            pstrans["UserName"] = Convert.ToString(this.cboDoorName.Text);
            //��ѯ����
            QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile);
            BindManager bg = new BindManager(this);
            ds = bg.BuildDataset(this.unitItem, pstrans);
            //if (ds.Tables["�շ�Ա�շ�ͳ��"].Rows.Count < 1 || ds.Tables["�շ�Ա�շ�ͳ��"] == null)
            //{
            //    XtraMessageBox.Show("û�����ݣ�", "ϵͳ��ʾ��", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            //    this.groReport.Controls.Clear();
            //    return;
            //}
            Granity.granityMgr.Report.viwReports View = new Granity.granityMgr.Report.viwReports();
            View.ReportName = "�շ�Ա�շ�ͳ��";
            View.ds = ds;
            View.StartTime = this.dateStart.Text.Trim();
            View.EndTime = "";
            View.Activate();
            View.Dock = DockStyle.Fill;
            this.groReport.Controls.Clear();
            this.groReport.Controls.Add(View);
        }

开发者ID:BillyWu，项目名称:Granitypark，代码行数:48，代码来源:FrmOperatorTotal.cs

示例17: Page_Load

 protected void Page_Load(object sender, EventArgs e)
 {
     XmlDocument xmldoc = new XmlDocument();
     //读取用户参数
     StreamReader streamreader = new StreamReader(this.Request.InputStream, Encoding.UTF8);
     try
     {
         xmldoc.LoadXml(streamreader.ReadToEnd());
     }
     catch { };
     string[] strParams = this.getStrParams(xmldoc);
     NameObjectList paramlist = BuildParamList.BuildParams(xmldoc);
     string unitName = BuildParamList.getValue(xmldoc, "UnitName");
     if (unitName == "") return;
     string workItemName = BuildParamList.getValue(xmldoc, "WorkItem");
     //得出workItemName对应的InitFilter=strParams[8]和PageSize=strParams[0]
     //for (int i = 0; i < unitItem.WorkItemList.Length; i++)
     //    if (workItemName == unitItem.WorkItemList[i].ItemName)
     //    {
     //        workitem = unitItem.WorkItemList[i];
     //        strParams[8] = unitItem.WorkItemList[i].InitFilter;
     //        if ("" != unitItem.WorkItemList[i].PageSize)
     //            strParams[0] = unitItem.WorkItemList[i].PageSize;
     //        break;
     //    }
     QueryDataRes query = new QueryDataRes(paramlist["DataSrcFile"].ToString());
     
     DataSet ds = new DataSet(unitName);
     ds.EnforceConstraints = false;
     string itemdata = paramlist["FilterData"].ToString();
     string[] dataItemList = itemdata.Split(",".ToCharArray());
     for (int i = 0; i < dataItemList.Length; i++)
     {
         if ("" == dataItemList[i]) continue;
         query.FillDataSet(dataItemList[i], paramlist, strParams, ds);
     }
     XmlDataDocument xmldocData = new XmlDataDocument(ds);
     this.Response.ContentType = "text/xml; charset=gb2312";
     xmldocData.Save(this.Response.Output);
 }

开发者ID:thisisvoa，项目名称:GranityApp2.5，代码行数:40，代码来源:frSelect.aspx.cs

示例18: BtQuery_Click

 /// <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("请输入开始时间", "系统提示！", MessageBoxButtons.OK, MessageBoxIcon.Warning);
         return;
     }
     if (this.lookDate.EditValue == null)
     {
         XtraMessageBox.Show("请选择表报", "系统提示！", MessageBoxButtons.OK, MessageBoxIcon.Warning);
         return;
     }
     NameObjectList pstrans = new NameObjectList();
     ParamManager.MergeParam(pstrans, this.paramwin);
     pstrans["dt"] = this.dateStart.EditValue.ToString();
     pstrans["type"] = this.lookDate.EditValue.ToString();
     //查询数据
     QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile);
     BindManager bg = new BindManager(this);
     ds = bg.BuildDataset(this.unitItem, pstrans);
     //if (ds.Tables["入场车流量统计"] == null || ds.Tables["入场车流量统计"].Rows.Count < 1)
     //{
     //    XtraMessageBox.Show("没有数据！", "系统提示！", MessageBoxButtons.OK, MessageBoxIcon.Warning);
     //    this.groReport.Controls.Clear();
     //    return;
     //}
     Granity.granityMgr.Report.viwReports View = new Granity.granityMgr.Report.viwReports();
     View.ReportName = "入场车流量统计表";
     View.ds = ds;
     View.StartTime = this.dateStart.Text.Trim();
     View.EndTime = "";
     View.Activate();
     View.Dock = DockStyle.Fill;
     this.groReport.Controls.Clear();
     this.groReport.Controls.Add(View);
 }

开发者ID:BillyWu，项目名称:Granitypark，代码行数:41，代码来源:FrmIntVehicleNumberTotal.cs

示例19: BtQuery_Click

        /// <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();
               //查询数据
               QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile);
               DataTable tab = this.grdConsumeList.DataSource as DataTable;
               if (null == tab) return;
               tab.Clear();
               query.FillDataSet(tab.TableName, pstrans, this.ds);
        }

开发者ID:BillyWu，项目名称:Granitypark，代码行数:29，代码来源:FrmConsumeRecord.cs

示例20: SetMasterData

        private static NameObjectList SetMasterData(UnitItem unititem,XmlDocument xmlsys,QueryDataRes query,XmlNodeList xmlNodes, string userid, NameObjectList paramlist)
        {
            for (int m = 0; m < unititem.WorkItemList.Length; m++)
            {
                if (unititem.WorkItemList[m].ItemType != WorkItemType.MasterData) continue;
                string dataname = unititem.WorkItemList[m].DataSrc;
                DataTable MData = query.getTable(dataname, paramlist, getStrParams(xmlsys, unititem.WorkItemList[m]));

                for (int n = 0; n < MData.Columns.Count; n++)
                {
                    string strM = MData.Columns[n].ColumnName;
                    paramlist.Add(strM, MData.Rows[0][strM].ToString());
                }

                for (int i = 0; i < xmlNodes.Count; i++)
                {
                    for (int j = 0; j < MData.Columns.Count; j++)
                    {
                        string strM = MData.Columns[j].ColumnName;
                        if (xmlNodes[i].InnerText==dataname + "." + strM)
                        {
                            if (MData.Rows[0][strM] == null) continue;
                            xmlNodes[i].ChildNodes[0].InnerText = MData.Rows[0][strM].ToString(); ;
                        }
                    }
                }

            }

            return paramlist;

        }

开发者ID:thisisvoa，项目名称:GranityApp2.5，代码行数:32，代码来源:csPrintData.cs

注：本文中的Estar.Business.DataManager.QueryDataRes类示例整理自Github/MSDocs等源码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。

鲜花

握手

雷人

路过

鸡蛋

该文章已有0人参与评论

请发表评论

全部评论

专题导读

More+

10-27 六六分期app的软件客服如何联系？(六六分期

11-06 可心卡盟:win10系统火狐flash插件崩溃怎么

11-06 亲亲特价:怎么删除回收站图标

11-06 济南大学虚拟社区:鲁大师节能降温的具体办

11-06 xlueops.exe:无线网络安装向导

11-06 女斗合众国:win7系统cf与主机连接不稳定怎

11-06 0xc000022-[cf烟雾头]cf怎么调烟雾头

11-06 qizideyouhuo:应用程序无法正常启动0xc0000

11-06 ipz-185:win7系统vcf文件怎么打开

11-06 傻哥蹦迪:win10系统s4怎么打开usb调试

11-06 八神浩树gtaste:回收站清空了怎么恢复

11-06 妖尾之黑色守护:win10系统电脑没有1440x900

11-06 校园至尊魔王小说:win7系统浏览网页时字体

11-06 女斗合众国:win10系统访问共享文件夹提示请

11-06 tokyo hot n0654:恢复win7系统默认字体一招

11-06 雨酷仙境:设置win7系统转移临时文件夹腾出

11-06 阿穆纳伊之杖:win7系统开始菜单在右边还原

11-06 tunespotting:win10系统火狐flash插件总是

11-06 甘尔葛分析师：计谋网站seo关键词暴涨有什

11-06 蔡贵霖: 计谋网站seo关键词暴涨有什么秘密

11-06 博益网首页:ao3网页版进入不了解决方法

11-06 漏斗子专栏: 网站数据分析小白易懂精华篇

11-06 见证双虹怎么做:win7系统开启telnet命令的

11-06 颾狐蝶蜋:系统资源不足无法完成请求的服务

11-06 国光中学校歌:提交网站到alexa查询详细步骤

11-06 西安有情天:静态网页和动态网页的区别

11-06 红木雅尚斋:外部链接构造对网站的好处

11-06 前官礼遇：防止域名劫持–增强域安全性的10

11-06 密传二转答案: 中文分词算法有哪些

11-06 金泉家园邮编:百度快照劫持的表现及应对方

C# Forms.Button类代码示例发布时间：2022-05-24

C# Messages.ServerMessage类代码示例发布时间：2022-05-24

剪的笔顺,诠释剪的笔画,认识剪的部首

1 六六分期app的软件客服如何联系？(六六分期

六六分期app的软件客服如何联系？不知道吗？加qq群【895510560】即可！标题：六六分期

阅读：19128|2023-10-27

2 可心卡盟:win10系统火狐flash插件崩溃怎么

今天小编告诉大家如何处理win10系统火狐flash插件总是崩溃的问题，可能很多用户都不知

阅读：9972|2022-11-06

3 亲亲特价:怎么删除回收站图标

今天小编告诉大家如何对win10系统删除桌面回收站图标进行设置，可能很多用户都不知道

阅读：8317|2022-11-06

4 济南大学虚拟社区:鲁大师节能降温的具体办

今天小编告诉大家如何对win10系统电脑设置节能降温的设置方法，想必大家都遇到过需要

阅读：8686|2022-11-06

5 xlueops.exe:无线网络安装向导

我们在使用xp系统的过程中,经常需要对xp系统无线网络安装向导设置进行设置，可能很多

阅读：8626|2022-11-06

6 女斗合众国:win7系统cf与主机连接不稳定怎

今天小编告诉大家如何处理win7系统玩cf老是与主机连接不稳定的问题，可能很多用户都不

阅读：9643|2022-11-06

7 0xc000022-[cf烟雾头]cf怎么调烟雾头

电脑对日常生活的重要性小编就不多说了，可是一旦碰到win7系统设置cf烟雾头的问题，很

阅读：8611|2022-11-06

8 qizideyouhuo:应用程序无法正常启动0xc0000

我们在日常使用电脑的时候，有的小伙伴们可能在打开应用的时候会遇见提示应用程序无法

阅读：7991|2022-11-06

9 ipz-185:win7系统vcf文件怎么打开

今天小编告诉大家如何对win7系统打开vcf文件进行设置，可能很多用户都不知道怎么对win

阅读：8641|2022-11-06

10 傻哥蹦迪:win10系统s4怎么打开usb调试

今天小编告诉大家如何对win10系统s4开启USB调试模式进行设置，可能很多用户都不知道怎

阅读：7527|2022-11-06

客服电话

电子邮件

C# DataManager.QueryDataRes类代码示例

示例1: BtQuery_Click

示例2: AddEateryStatus

示例3: CmdProtocol

示例4: DeviceMonitorMgrBak

示例5: btnSelect_Click

示例6: getUser

示例7: getNewDataByCardNo

示例8: btnCheck_Click

示例9: GetDEvById

示例10: trvDept_AfterSelect

示例11: BtSave_Click

示例12: btnCheck_Click

示例13: BtQuery_Click

示例14: ProcessRequest

示例15: DeviceEatery

示例16: BtQuery_Click

示例17: Page_Load

示例18: BtQuery_Click

示例19: BtQuery_Click

示例20: SetMasterData

请发表评论

全部评论

上一篇：

下一篇：

krishnaik06/Machine-Learning-in-90-days

美元符号为什么是“$”

Mekolaos/Aternos-On-Discord: A Discord B

Matlab练习1

FNNDSC/matlab: Matlab Projects and Snipp

剪的笔顺,诠释剪的笔画,认识剪的部首

六六分期app的软件客服如何联系？(六六分期

florent37/ViewAnimator: A fluent Android

florent37/Shrine-MaterialDesign2: implem

CVE-2020-36276

SimpleSoftwareIO/simple-sms: Send and re

关于我们

产品与服务

解决方案

139-2527-9053