• 设为首页
  • 点击收藏
  • 手机版
    手机扫一扫访问
    迪恩网络手机版
  • 关注官方公众号
    微信扫一扫关注
    迪恩网络公众号

C# DataManager.QueryDataRes类代码示例

原作者: [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人参与评论

请发表评论

全部评论

专题导读
上一篇:
C# Forms.Button类代码示例发布时间:2022-05-24
下一篇:
C# Messages.ServerMessage类代码示例发布时间:2022-05-24
热门推荐
阅读排行榜

扫描微信二维码

查看手机版网站

随时了解更新最新资讯

139-2527-9053

在线客服(服务时间 9:00~18:00)

在线QQ客服
地址:深圳市南山区西丽大学城创智工业园
电邮:jeky_zhao#qq.com
移动电话:139-2527-9053

Powered by 互联科技 X3.4© 2001-2213 极客世界.|Sitemap