/// <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); }
private void BtnRefsh_Click_1(object sender, EventArgs e) { QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile); this.dsUnit.Tables["时段设置"].Clear(); query.FillDataSet("时段设置", this.paramwin, this.dsUnit); }
/// <summary> /// 根据部门检索 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void cboDept_TextChanged(object sender, EventArgs e) { string filter = "c.名称 like '%{0}%'"; if (cboDept.Text == "全部") { filter = ""; } else { filter = string.Format(filter, this.cboDept.Text.Replace("'", "''")); } //得到数据源 QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile); DataTable tab = dsUnit.Tables["补助管理"];; if (null == tab) { return; } tab.Clear(); query.FillDataSet(tab.TableName, this.paramwin, ParamManager.setMacroParam(MacroPmType.FW, filter), this.dsUnit); detpList.Items.Clear(); foreach (DataRow dr in tab.Rows) { this.detpList.Items.Add(dr["姓名"] + "(" + dr["卡号"] + ")"); } }
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 DevListBtn_Click(object sender, EventArgs e) { dbGrid.Show(); DevListGrid.Hide(); QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile); this.dsUnit.Tables["compara"].Clear(); query.FillDataSet("compara", this.paramwin, this.dsUnit); }
/// <summary> /// 保存补助记录,修改卡片余额 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnSave_Click_1(object sender, EventArgs e) { if (string.IsNullOrEmpty(txtMoney.Text) || moneyList.Items.Count < 1) { XtraMessageBox.Show("补助金额为空或者卡号为空!", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } #region 循环写入数据 for (int i = 0; i < moneyList.Items.Count; i++) { string[] sArray = moneyList.Items[i].ToString().Split('('); foreach (string j in sArray) { if (j.ToString().Contains(")")) { string[] ssArray = j.ToString().Split(')'); foreach (string h in ssArray) { if (!string.IsNullOrEmpty(h.ToString())) { string CardNo = h.ToString(); NameObjectList ps = new NameObjectList(); ParamManager.MergeParam(ps, this.paramwin); ps["卡号"] = CardNo; #region 查询当前记录 QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile); DataTable tab = dsUnit.Tables["补助信息"]; if (null == tab) { return; } tab.Clear(); query.FillDataSet(tab.TableName, ps, this.dsUnit); #endregion //保存充值记录并且更新卡片余额 DataRow dr = tab.Rows[0]; dr["卡号"] = CardNo; dr["补助充值"] = txtMoney.Text; dr["操作员"] = BindManager.getUser().UserName; NameObjectList ps1 = ParamManager.createParam(dr); ParamManager.MergeParam(ps1, this.paramwin, false); this.Query.ExecuteNonQuery("补助信息", ps1, ps1, ps1); } } } } } #endregion moneyList.Items.Clear(); MessageBox.Show("补助成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.None); }
/// <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> /// <returns></returns> public DataTable User() { //得到数据源 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> /// <returns></returns> public DataTable initDev() { IPHostEntry IpEntry = Dns.GetHostEntry(Dns.GetHostName()); string myip = IpEntry.AddressList[0].ToString(); string filter = "(电脑='{0}' or IP地址='{1}') and 通讯类别='发行器'"; filter = string.Format(filter, Dns.GetHostName(), myip); DataTable tab = this.dsUnit.Tables["发行器"]; tab.Clear(); QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile); query.FillDataSet("发行器", this.paramwin, ParamManager.setMacroParam(MacroPmType.FW, filter), this.dsUnit); return(tab); }
/// <summary> /// 初始化发行器 /// </summary> public void initCmdCard() { IPHostEntry IpEntry = Dns.GetHostEntry(Dns.GetHostName()); string myip = IpEntry.AddressList[0].ToString(); NameObjectList pstrans = new NameObjectList(); ParamManager.MergeParam(pstrans, this.paramwin); pstrans["IP地址"] = myip; //查询数据 QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile); DataTable tab = dsUnit.Tables["设备设置"]; tab.Clear(); query.FillDataSet(tab.TableName, pstrans, this.dsUnit); if (null == tab || tab.Rows.Count < 1) { return; } if (tab.Rows.Count < 1) { MessageBox.Show("请设置发行器"); return; } DataRow dr = this.dsUnit.Tables["设备设置"].Rows[0]; string port = Convert.ToString(dr["串口"]); int baudrate = Convert.ToInt32(dr["波特率"]); Parity parity = Parity.None; int databits = Convert.ToInt32(dr["数据位"]); StopBits stopbits = StopBits.One; switch (Convert.ToString(dr["停止位"])) { case "1.5位": stopbits = StopBits.OnePointFive; break; case "2位": stopbits = StopBits.Two; break; default: stopbits = StopBits.One; break; } CommiTarget target = new CommiTarget(port, baudrate, parity, databits, stopbits); int addrst = Convert.ToInt32(dr["站址"]); bool success = this.cmdCard.SetTarget(target, addrst, this.radic.Checked); if (success) { this.cmdCard.Buzz(true); } }
/// <summary> /// 条件查询 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnCheck_Click(object sender, EventArgs e) { string filter = "a.NAME like '%{0}%' or a.EMPCODE like '%{0}%' or b.名称 like '%{0}%'"; filter = string.Format(filter, this.txtCheck.Text.Replace("'", "''")); //得到数据源 QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile); DataTable tab = this.dbUser.DataSource as DataTable; if (null == tab) { return; } tab.Clear(); query.FillDataSet(tab.TableName, this.paramwin, ParamManager.setMacroParam(MacroPmType.FW, filter), this.ds); }
/// <summary> /// 时间段查询,部门,班制 检索 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnSelect_Click(object sender, EventArgs e) { DataTable tab = this.dbDeptRpt.DataSource as DataTable; if (null == tab) { return; } string filter = "a.日期>=(SELECT convert(datetime,'{0}',121)) and a.日期<=(SELECT convert(datetime, '{1}',121)) and (c.名称 like '%{2}%')"; filter = string.Format(filter, this.cboStart.Text.Replace("'", "''"), this.cboEnd.Text.Replace("'", "''"), this.cboDept.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 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}%') and f.类别 like '%{1}%'"; filter = string.Format(filter, this.tbcardno.Text.Replace("'", "''"), this.cboType.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); }
/// <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); }
/// <summary> /// 条件检索 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void sbtFilter_Click(object sender, EventArgs e) { //获取当前单元名称 DataTable tab = dsUnit.Tables["用户选择"]; if (null == tab) { return; } //数据源 string filter = "姓名 like '%{0}%' or 用户编号 like '%{0}%' or 卡号 like '%{0}%' or 部门名称 like '%{0}%' or 车牌 like '%{0}%' or 车辆类型 like '%{0}%'"; filter = string.Format(filter, this.tbFilter.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> /// 根据餐厅检索 消费时段,菜单,消费机ddd /// </summary> /// <param name="db">GridControl</param> /// <param name="flag">类别标示</param> /// <param name="ID">编号</param> public void CheckByDin(DevExpress.XtraGrid.GridControl db, string flag, string ID) { try { DataTable tab = db.DataSource as DataTable; if (null == tab) { return; } if (string.IsNullOrEmpty(ID)) { return; } string filter = ""; switch (flag) { case "1": filter = "餐厅ID='{0}' order by 星期序号"; break; case "2": filter = "餐厅ID='{0}'"; break; case "4": filter = "a.餐厅ID='{0}'"; break; case "3": filter = "餐厅ID='{0}'"; break; default: break; } filter = string.Format(filter, ID.Replace("'", "''")); QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile); tab.Clear(); query.FillDataSet(tab.TableName, this.paramwin, ParamManager.setMacroParam(MacroPmType.FW, filter), this.ds); } catch (Exception ex) { } }
/// <summary> /// 根据部门查询 /// </summary> public void GetUserByDept(string Num) { try { DataTable tab = this.dbUser.DataSource as DataTable; if (null == tab) { return; } string filter = "DEPARTMENT='{0}'"; filter = string.Format(filter, Num.Replace("'", "''")); QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile); tab.Clear(); query.FillDataSet(tab.TableName, this.paramwin, ParamManager.setMacroParam(MacroPmType.FW, filter), this.ds); } catch (Exception ex) { } }
/// <summary> /// 根据卡号获取当前信息 /// </summary> public DataTable 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["selectcard"]; tab.Clear(); query.FillDataSet(tab.TableName, pstrans, this.dsUnit); if (null == tab || tab.Rows.Count < 1) { return(tab); } status = Convert.ToString(tab.Rows[0]["状态"]); return(tab); }
/// <summary> /// 条件查询 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void BtQuery_Click(object sender, EventArgs e) { string StartDtTime = this.StartDate.Text + " " + this.cboStartTime.Text; string EndDtTime = this.EndDate.Text + " " + this.cboEndTime.Text; //获取当前单元名称 DataTable tab = this.dbGridIn.DataSource as DataTable; if (null == tab) { return; } string filter = ""; filter = " a.日期 between (SELECT convert(datetime,'{0}',121)) and (SELECT convert(datetime,'{1}',121)+1) and a.用户编号 like '%{2}%' and b.name like '%{3}%' and c.卡类 like '%{4}%' and (a.车牌 like '%{5}%' or a.车牌 is null) and a.卡号 like '%{6}%' and p.名称 like '%{7}%'"; filter = string.Format(filter, StartDtTime.Replace("'", "''"), EndDtTime.Replace("'", "''"), txtuserID.Text.Replace("'", "''"), this.txtuserName.Text.Replace("'", "''"), this.CbCardtype.Text.Replace("'", "''"), TxtCarNo.Text.Replace("'", "''"), TxtCardNo.Text.Replace("'", "''"), this.dtDev.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 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> /// <returns></returns> public DataTable initDev() { IPHostEntry IpEntry = Dns.GetHostEntry(Dns.GetHostName()); string myip = IpEntry.AddressList[0].ToString(); NameObjectList pstrans = new NameObjectList(); ParamManager.MergeParam(pstrans, this.paramwin); pstrans["IP地址"] = myip; //查询数据 QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile); DataTable tab = dsUnit.Tables["设备设置"]; tab.Clear(); query.FillDataSet(tab.TableName, pstrans, this.dsUnit); if (null == tab || tab.Rows.Count < 1) { return(tab); } return(tab); }
/// <summary> /// 当前行改变,更改用户编号 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void gridView_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e) { if (flag == 1) { return; } else { flag = 0; } if (gridView.RowCount <= e.FocusedRowHandle || e.FocusedRowHandle < 0) { return; } //设置参数 NameObjectList ps = new NameObjectList(); ParamManager.MergeParam(ps, this.paramwin); ps["卡号"] = textEdit1.Text; QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile); DataTable tab1 = this.dsUnit.Tables["发行"]; if (null == tab1) { return; } tab1.Clear(); query.FillDataSet(tab1.TableName, ps, this.dsUnit); if (blstatus.Text == "") { lbState.Text = "未发行"; } else { lbState.Text = this.blstatus.Text; } }
private void QueryBtn_Click(object sender, EventArgs e) { //设置参数 NameObjectList ps = new NameObjectList(); ParamManager.MergeParam(ps, this.paramwin); string s = Convert.ToDateTime(this.dtpDate.Value).ToString("yyyy-MM-dd").ToString(); ps["dt"] = Convert.ToDateTime(this.dtpDate.Value).ToString("yyyy-MM-dd").ToString(); ps["type"] = this.cbRecordTp.SelectedIndex + 1; //查询数据 QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile); DataTable tab = this.RecordGrid.DataSource as DataTable; if (null == tab) { return; } tab.Clear(); query.FillDataSet(tab.TableName, ps, this.ds); //特殊业务处理 this.lbcount.Text = "总记录: " + Convert.ToString(ds.Tables[0].Rows.Count) + " 条"; }