private void FrmCardMakeS_Load(object sender, EventArgs e) { //初始化参数和单元 this.paramwin = BindManager.getSystemParam(); NameObjectList pstrans = BindManager.getTransParam(); ParamManager.MergeParam(this.paramwin, pstrans); this.unitItem = new UnitItem(DataAccRes.AppSettings("WorkConfig"), unitName); //绑定数据 this.bindMgr = new BindManager(this); this.dsUnit = this.bindMgr.BuildDataset(this.unitItem, this.paramwin); this.bindMgr.BindFld(this, dsUnit); this.Query = new QueryDataRes(this.unitItem.DataSrcFile); ///检测发行器 /// bindMgr.SetGridCols(this.dbUser, "姓名,卡号,部门名称"); DataTable taboption = initSet(); if (null == taboption || taboption.Rows.Count < 1) { XtraMessageBox.Show("请设置发行器", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); } lblMessage.Text = ""; ShowType(); tabCardApp.SelectedTabPageIndex = 2; }
private void FrmFeePara_Load(object sender, EventArgs e) { if (string.IsNullOrEmpty(this.deviceName)) { //读取业务单元和传递参数 this.paramwin = BindManager.getSystemParam(); NameObjectList pstrans = BindManager.getTransParam(); ParamManager.MergeParam(this.paramwin, pstrans); unitName = pstrans["name"].ToString();//单元 unitItem = new UnitItem(DataAccRes.AppSettings("WorkConfig"), unitName); //绑定数据 BindManager bg = new BindManager(this); this.dsUnit = bg.BuildDataset(this.unitItem, this.paramwin); bg.BindFld(this, this.dsUnit); if (unitName == "停车场收费标准") { lbDeviceInfo.Visible = false; this.DownBtn.Visible = false; QueryBtn.Visible = false; BtnClose.Visible = false; } } else { this.cbodev.Visible = false; this.btnsave.Visible = false; this.lbDeviceInfo.Text = " " + this.deviceName + "(" + this.deviceID + ")"; } }
private void FrmDoorMonitor_Load(object sender, EventArgs e) { //初始化参数和单元 this.paramwin = BindManager.getSystemParam(); NameObjectList pstrans = BindManager.getTransParam(); ParamManager.MergeParam(this.paramwin, pstrans); this.unitItem = new UnitItem(DataAccRes.AppSettings("WorkConfig"), unitName); //绑定数据 this.bindMgr = new BindManager(this); this.paramwin["code"] = DBNull.Value; this.ds = this.bindMgr.BuildDataset(this.unitItem, this.paramwin); this.Query = new QueryDataRes(this.unitItem.DataSrcFile); this.bindMgr.BindFld(this, ds); //对树的操作 DataTable tab = this.ds.Tables["门禁监控"]; this.bindMgr.BindTrv(this.trvDoorStall, tab, "名称", "ID", "PID", "@ID={ID},@PID={PID}"); this.trvDoorStall.ExpandAll(); this.tabStateDoor = this.ds.Tables["门禁巡检状态"]; if (gridViewInfo.RowCount > 0) { gridViewInfo.DeleteRow(0); } }
/// <summary> /// 窗口初始化 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void ParkStallSetFrm_Load(object sender, EventArgs e) { //初始化参数和单元 this.paramwin = BindManager.getSystemParam(); NameObjectList pstrans = BindManager.getTransParam(); ParamManager.MergeParam(this.paramwin, pstrans); this.unitItem = new UnitItem(DataAccRes.AppSettings("WorkConfig"), unitName); //绑定数据 this.bindMgr = new BindManager(this); this.paramwin["code"] = DBNull.Value; this.ds = this.bindMgr.BuildDataset(this.unitItem, this.paramwin); this.Query = new QueryDataRes(this.unitItem.DataSrcFile); this.bindMgr.BindFld(this, ds); //对树的操作 DataTable tab = this.ds.Tables["停车场管理"]; this.bindMgr.BindTrv(this.trvParkStall, tab, "名称", "id", "PID", "@ID={ID},@PID={PID},@编号={编号},@站址={站址}"); this.trvParkStall.ExpandAll(); tab.ColumnChanged += new DataColumnChangeEventHandler(tab_ColumnChanged); if (this.trvParkStall.Nodes.Count > 0) { this.trvParkStall.FocusedNode = this.trvParkStall.Nodes[0]; } this.grpParam.Hide(); this.grpFee.Dock = DockStyle.Fill; this.grpParam.Dock = DockStyle.Fill; // //初始化收费参数编辑控件事件 this.setTextChanged(this.tabFeeStd); this.setCheckedChanged(this.grpbAccept); this.setCheckedChanged(this.grpbCardType); this.setCheckedChanged(this.grpbChannel); this.plCarType.Dock = DockStyle.Fill; //加载串口 string[] Com = { "COM1", "COM2", "COM3", "COM4", "COM5", "COM6", "COM7", "COM8", "COM9", "COM10" }; LoadComBox("串口", Com); //加载波特率 string[] BTL = { "4800", "9600", "19200", "38400", "56000" }; LoadComBox("波特率", BTL); //加载数据位 string[] DataW = { "5", "6", "7", "8" }; LoadComBox("数据位", DataW); //加载停止位 string[] DopW = { "1", "2" }; LoadComBox("停止位", DopW); //加载停止位 string[] DK = { "30000", "60000" }; LoadComBox("端口", DK); //加载通讯类别 string[] type = { "TCP/IP(局域网)", "UDP/IP(局域网)", "串口" }; LoadComBox("通讯类别", type); this.TxtStalname.EditValueChanged += new EventHandler(txtEditValueChanged); this.AllNoTxt.EditValueChanged += new EventHandler(txtEditValueChanged); this.RetainStaTxt.EditValueChanged += new EventHandler(txtEditValueChanged); this.ComIpTxt.EditValueChanged += new EventHandler(txtEditValueChanged); }
/// <summary> /// 根据数据表创建参数列表 /// </summary> /// <param name="tab">数据表</param> /// <returns>返回参数列表</returns> public static NameObjectList[] createParam(DataTable tab, DataRowState state) { if (null == tab || tab.Rows.Count < 1) { return(new NameObjectList[0]); } List <NameObjectList> psList = new List <NameObjectList>(); DataView dvsub = new DataView(tab, "", "", DataViewRowState.ModifiedCurrent | DataViewRowState.Added | DataViewRowState.Deleted); DataColumnCollection cols = tab.Columns; int len = cols.Count; for (int i = 0; i < dvsub.Count; i++) { if (state != dvsub[i].Row.RowState) { continue; } DataRowView drv = dvsub[i]; NameObjectList ps = new NameObjectList(); for (int c = 0; c < len; c++) { ps[cols[c].ColumnName] = drv[c]; } psList.Add(ps); } return(psList.ToArray()); }
private void FrmLogin_Load(object sender, EventArgs e) { FormFactory dbhelp = new FormFactory(); if (!dbhelp.ConnectionResult("value", "Granity.granityMgr", "select * from 用户信息表")) { FrmDBDatabase db = new FrmDBDatabase(); db.ShowDialog(); if (!db.Success) { return; } } try { //读取业务单元和传递参数 this.paramwin = BindManager.getSystemParam(); NameObjectList pstrans = BindManager.getTransParam(); ParamManager.MergeParam(this.paramwin, pstrans); unitItem = new UnitItem(DataAccRes.AppSettings("WorkConfig"), unitName); //绑定数据 BindManager bg = new BindManager(this); this.dsUnit = bg.BuildDataset(this.unitItem, this.paramwin); this.Query = new QueryDataRes(this.unitItem.DataSrcFile); bg.BindFld(this, this.dsUnit); setSystemTime(); } catch { this.Close(); } }
/// <summary> /// 退还押金 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btBack_Click(object sender, EventArgs e) { string province = this.cbbProvince.Text; if (!string.IsNullOrEmpty(province)) { province = regUperCase.Replace(province, ""); } string carnum = this.tbCarnum.Text; if (!string.IsNullOrEmpty(carnum)) { carnum = province + carnum; } this.tag = basefun.setvaltag(this.tag, "{车牌号码}", carnum); //押金处理 NameObjectList ps = ParamManager.createParam(this.tag); //ps["操作类别"] = "退费"; ps["操作类别"] = "不退费再入场"; this.tag = basefun.setvaltag(this.tag, "{收费操作}", "不退费再入场"); ParamManager.MergeParam(ps, BindManager.getSystemParam(), false); this.Query.ExecuteNonQuery("押金处理", ps, ps, ps); this.DialogResult = DialogResult.Yes; this.Close(); }
private void FrmCardUpdate_Load(object sender, EventArgs e) { //读取业务单元和传递参数 this.paramwin = BindManager.getSystemParam(); NameObjectList pstrans = BindManager.getTransParam(); ParamManager.MergeParam(this.paramwin, pstrans); unitItem = new UnitItem(DataAccRes.AppSettings("WorkConfig"), unitName); //绑定数据 BindManager bg = new BindManager(this); this.dsUnit = bg.BuildDataset(this.unitItem, this.paramwin); bg.BindFld(this, this.dsUnit); this.Query = new QueryDataRes(this.unitItem.DataSrcFile); bg.SetGridCols(this.dbUser, "姓名,卡号,部门名称"); DataTable tab = initDev(); if (null == tab || tab.Rows.Count < 1) { XtraMessageBox.Show("请设置发行器", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); } ShowType(); this.cboDTime.Text = DateTime.Now.ToString("yyyy-MM-dd"); this.cboETime.Text = DateTime.Now.ToString("yyyy-MM-dd");; this.cboPTime.Text = DateTime.Now.ToString("yyyy-MM-dd");; }
/// <summary> /// 设置通讯设备 /// </summary> /// <param name="devid">设备ID</param> /// <param name="target">通讯目标</param> /// <param name="station">站址</param> public override void SetDevice(CommiManager mgr, CommiTarget target, string devid, int station) { if (null == mgr || string.IsNullOrEmpty(devid) || null == target || station < 1) { return; } this.commimgr = mgr; this.target = target; this.devid = devid; this.station = station; NameObjectList ps = new NameObjectList(); ps["分组ID"] = devid; DataTable tab = this.query.getTable("门禁设备", ps); if (null == tab || tab.Rows.Count < 1) { return; } object val = tab.Rows[0]["记录位置"]; if (null == val || DBNull.Value == val) { val = 0; } this.posRecord = Convert.ToInt32(val); val = tab.Rows[0]["控制器类型"]; this.devtype = Convert.ToString(val); if (string.IsNullOrEmpty(this.devtype)) { this.devtype = "考勤机"; } }
private void FormUpDownWork_Load(object sender, EventArgs e) { //初始化参数和单元 this.paramwin = BindManager.getSystemParam(); NameObjectList pstrans = BindManager.getTransParam(); ParamManager.MergeParam(this.paramwin, pstrans); this.unitItem = new UnitItem(DataAccRes.AppSettings("WorkConfig"), unitName); //绑定数据 BindManager bg = new BindManager(this); this.dsUnit = bg.BuildDataset(this.unitItem, this.paramwin); bg.BindFld(this, this.dsUnit); DataTable tab = this.dsUnit.Tables["接班人员"]; if (null == tab || tab.Rows.Count < 1) { return; } DataTable tabUser = this.dsUnit.Tables["用户信息"]; foreach (DataRow dr in tabUser.Rows) { this.ccbNextUser.Items.Add(Convert.ToString(dr["帐号"])); } tbUserName.Text = BindManager.getUser().UserAccounts; }
private void FrmDevSet_Load(object sender, EventArgs e) { //初始化参数和单元 this.paramwin = BindManager.getSystemParam(); NameObjectList pstrans = BindManager.getTransParam(); ParamManager.MergeParam(this.paramwin, pstrans); this.unitItem = new UnitItem(DataAccRes.AppSettings("WorkConfig"), unitName); //绑定数据 BindManager bg = new BindManager(this); this.dsUnit = bg.BuildDataset(this.unitItem, this.paramwin); bg.BindFld(this, this.dsUnit); //加载串口 string[] Com = { "COM1", "COM2", "COM3", "COM4", "COM5", "COM6", "COM7", "COM8", "COM9", "COM10" }; LoadComBox("串口", Com); //加载波特率 string[] BTL = { "4800", "9600", "19200", "38400", "56000" }; LoadComBox("波特率", BTL); //加载数据位 string[] DataW = { "5", "6", "7", "8" }; LoadComBox("数据位", DataW); //加载停止位 string[] DopW = { "1", "2" }; LoadComBox("停止位", DopW); }
/// <summary> /// 导航树节点改变 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void treeUser_FocusedNodeChanged(object sender, FocusedNodeChangedEventArgs e) { if (null == e || null == e.Node) { return; } int rowIndex = 0; string id = basefun.valtag(Convert.ToString(e.Node.Tag), "ID"); DataTable tab = this.ds.Tables["orgtreegroup"]; BindingManagerBase bindMgrbase = this.BindingContext[tab]; NameObjectList ps = new NameObjectList(); rowIndex = 0; foreach (DataRow dr in tab.Rows) { if (DataRowState.Deleted != dr.RowState && dr["id"].ToString() == id) { bindMgrbase.Position = rowIndex; ps["部门"] = Convert.ToString(dr["部门"]); break; } rowIndex++; } tab = this.dbUser.DataSource as DataTable; if (null == tab) { return; } tab.Clear(); this.Query.FillDataSet(tab.TableName, ps, tab.DataSet); }
private void FrmDownTime_Load(object sender, EventArgs e) { //初始化参数和单元 this.paramwin = BindManager.getSystemParam(); NameObjectList pstrans = BindManager.getTransParam(); ParamManager.MergeParam(this.paramwin, pstrans); this.unitItem = new UnitItem(DataAccRes.AppSettings("WorkConfig"), "时段设置"); this.Text = this.unitItem.UnitName; //绑定数据 BindManager bg = new BindManager(this); this.dsUnit = bg.BuildDataset(this.unitItem, this.paramwin); if (this.dsUnit.Tables.Contains("时段设置")) { DataTable tab = this.dsUnit.Tables["时段设置"]; if (tab.Columns.Contains("选择")) { tab.Columns.Remove("选择"); } tab.Columns.Add("选择", typeof(bool)); } bg.BindFld(this, this.dsUnit); //显示指定字段 //string cols = "选择 40,timeid 编号 40,timename 时段名称 90,timesec1s 起始时间1 90,timesec1e 截止时间1 90,timesec2s 起始时间2 90,timesec2e 截止时间2 90,"; //cols += "date1 起始日期 80,date2 截止日期 80,satrest 星期六 50,sunrest 星期天 50"; //bg.SetGridCols(this.gdValList, cols); foreach (DataGridViewColumn c in this.gdValList.Columns) { c.ReadOnly = !("选择" == c.Name); } this.lbDeviceInfo.Text = " " + this.deviceName + "(" + this.deviceID + ")"; }
/// <summary> /// 清空记录,重置记录位置 /// </summary> private void ClearRecord() { //清空记录 CmdProtocol cmdP = new CmdProtocol(false); setTimeout(cmdP); cmdP.IsResposeHandle = isResponse; string tag = "@设备地址=" + Convert.ToString(this.station); cmdP.setCommand("门禁", "清空记录", tag); this.commimgr.SendCommand(this.target, cmdP); if (!cmdP.EventWh.WaitOne(this.waitTime, false)) { return; } string msg = cmdP.ResponseFormat; if ("true" == basefun.valtag(msg, "Success")) { this.posRecord = 0; NameObjectList pspos = new NameObjectList(); pspos["控制器"] = this.devid; try { Monitor.Enter(objquery); this.query.ExecuteNonQuery("重置记录位置", pspos, pspos, pspos); } finally { Monitor.PulseAll(objquery); Monitor.Exit(objquery); } } }
private void FrmReadRecord_Load(object sender, EventArgs e) { this.UnitItem = new UnitItem(DataAccRes.AppSettings("WorkConfig"), "收费站"); //初始化下拉框字典 this.Query = new QueryDataRes(this.UnitItem.DataSrcFile); this.paramSystem = BindManager.getSystemParam(); DataSet ds = new DataSet("卡片类型"); this.Query.FillDataSet("卡片类型", this.paramSystem, ds); this.Query.FillDataSet("卡片类型", this.paramSystem, ds); DataRow dr = ds.Tables["卡片类型"].NewRow(); ds.Tables["卡片类型"].Rows.InsertAt(dr, 0); dr = ds.Tables["卡片类型"].NewRow(); ds.Tables["卡片类型"].Rows.InsertAt(dr, 0); DataGridViewComboBoxColumn col = this.gdRecord.Columns["卡类"] as DataGridViewComboBoxColumn; col.ValueType = typeof(int); col.DataSource = ds.Tables["卡片类型"]; col.DisplayMember = "卡类"; col.ValueMember = "编号"; col = this.gdRecord.Columns["车型"] as DataGridViewComboBoxColumn; col.ValueType = typeof(int); col.DataSource = ds.Tables["车型"]; col.DisplayMember = "车类"; col.ValueMember = "编号"; lbDevInfo.Text = this.DeviceName + "(" + this.DeviceID + ")"; }
/// <summary> /// 加载控制参数 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void DownComBtn_Click(object sender, EventArgs e) { int[] indexlist = this.getCheckedList(); if (indexlist.Length < 1) { MessageBox.Show("请选择一个设备", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } DataTable tab = this.dbGrid.DataSource as DataTable; DataRow drtarget = tab.Rows[indexlist[0]]; UnitItem unitPark = new UnitItem(DataAccRes.AppSettings("WorkConfig"), "设备控制维护"); BindManager bg = new BindManager(this); NameObjectList ps = new NameObjectList(); ps["code"] = drtarget["编号"]; DataSet ds = bg.BuildDataset(unitPark, ps); FrmCommPara win = new FrmCommPara(); win.DataSource = ds; win.Query = new QueryDataRes(unitPark.DataSrcFile); win.Position = 0; win.Target = this.getTarget(drtarget); win.FunType = "通讯"; win.ShowDialog(this); }
private void FrmRight_Load(object sender, EventArgs e) { //初始化参数和单元 this.paramwin = BindManager.getSystemParam(); NameObjectList pstrans = BindManager.getTransParam(); ParamManager.MergeParam(this.paramwin, pstrans); this.unitItem = new UnitItem(DataAccRes.AppSettings("WorkConfig"), unitName); //绑定数据0 this.bindMgr = new BindManager(this); this.paramwin["code"] = DBNull.Value; this.ds = this.bindMgr.BuildDataset(this.unitItem, this.paramwin); this.Query = new QueryDataRes(this.unitItem.DataSrcFile); DataTable tabEquipment = this.ds.Tables["停车场设备信息"]; this.bindMgr.BindTrv(this.treEquipmentAll, tabEquipment, "名称", "id", "PID", "@ID={ID},@PID={PID},@编号={编号}"); this.treEquipmentAll.ExpandAll(); DataTable tabDept = this.ds.Tables["停车场卡"]; this.bindMgr.BindTrv(this.treDept, tabDept, "名称", "id", "PID", "@ID={ID},@PID={PID},@用户编号={用户编号},@卡号={卡号}"); this.treDept.ExpandAll(); this.treDept.AfterCheckNode += new NodeEventHandler(treDept_AfterCheckNode); this.treDept.FocusedNodeChanged += new FocusedNodeChangedEventHandler(treDept_FocusedNodeChanged); this.treDept.FocusedNode = this.treDept.Nodes.ParentNode; this.treEquipmentAll.AfterCheckNode += new NodeEventHandler(treEquipmentAll_AfterCheckNode); }
private void FrmDorUsers_Load(object sender, EventArgs e) { //初始化参数和单元 this.paramwin = BindManager.getSystemParam(); NameObjectList pstrans = BindManager.getTransParam(); ParamManager.MergeParam(this.paramwin, pstrans); this.unitItem = new UnitItem(DataAccRes.AppSettings("WorkConfig"), unitName); //绑定数据0 this.bindMgr = new BindManager(this); this.paramwin["code"] = DBNull.Value; this.ds = this.bindMgr.BuildDataset(this.unitItem, this.paramwin); this.Query = new QueryDataRes(this.unitItem.DataSrcFile); DataTable tabDor = this.ds.Tables["门禁分组"]; this.bindMgr.BindTrv(this.treDoorAll, tabDor, "名称", "id", "PID", "@ID={ID},@PID={PID},@编号={编号},@站址={站址}"); this.treDoorAll.FocusedNodeChanged += new DevExpress.XtraTreeList.FocusedNodeChangedEventHandler(treDoorAll_FocusedNodeChanged); this.treDoorAll.FocusedNode = null; this.treDoorAll.AfterCheckNode += new NodeEventHandler(treDoorAll_AfterCheckNode); this.treDoorAll.ExpandAll(); DataTable tabDept = this.ds.Tables["部门用户信息"]; this.bindMgr.BindTrv(this.treDeptUser, tabDept, "名称", "id", "PID", "@ID={ID},@PID={PID},@用户编号={用户编号},@站址={站址}"); this.treDeptUser.ExpandAll(); }
private void Uc_DoorControlBaseinfo_Load(object sender, EventArgs e) { //初始化参数和单元 this.paramwin = BindManager.getSystemParam(); NameObjectList pstrans = BindManager.getTransParam(); ParamManager.MergeParam(this.paramwin, pstrans); this.unitItem = new UnitItem(DataAccRes.AppSettings("WorkConfig"), unitName); //绑定数据 this.bindMgr = new BindManager(this); this.paramwin["code"] = DBNull.Value; this.ds = this.bindMgr.BuildDataset(this.unitItem, this.paramwin); this.Query = new QueryDataRes(this.unitItem.DataSrcFile); this.bindMgr.BindFld(this, ds); // this.bindMgr.BindFld(this, ds, true); //对树的操作 DataTable tab = this.ds.Tables["门禁管理"]; this.bindMgr.BindTrv(this.TreeGroup, tab, "名称", "id", "PID", "@ID={ID},@PID={PID},@编号={编号},@站址={站址}"); this.TreeGroup.ExpandAll(); this.txtDoorName.EditValueChanged += new EventHandler(txtEditValueChanged); this.txtGroupName.EditValueChanged += new EventHandler(txtEditValueChanged); this.txtControlDor.EditValueChanged += new EventHandler(txtEditValueChanged); BandCheckChangeEventargs(this.xtraTabExtendPara); GetEffTime(); }
/// <summary> /// This method returns a sorted <see cref="List{Slide}"/> with the whole /// slideshow. /// </summary> /// <returns>A sorted <see cref="List{Slide}"/> with all slides from the whole /// slideshow.</returns> private NameObjectList <Slide> GetSlides() { NameObjectList <Slide> slides = new NameObjectList <Slide>(); this.ParseNodeForSlides(ref slides, this); return(slides); }
private void FrmDepart_Load(object sender, EventArgs e) { //读取业务单元和传递参数 this.paramwin = BindManager.getSystemParam(); NameObjectList pstrans = BindManager.getTransParam(); ParamManager.MergeParam(this.paramwin, pstrans); unitName = pstrans["name"].ToString();//单元 //获取当前单元名称 Dictionary <string, string> dict = new Dictionary <string, string>(); dict.Add("组织机构管理", "@db=组织机构"); //数据源 string datasource = dict[this.unitName]; NameObjectList ps = new NameObjectList(); ParamManager.MergeParam(ps, this.paramwin); ps["UnitCode"] = "10"; unitItem = new UnitItem(DataAccRes.AppSettings("WorkConfig"), unitName); //绑定数据 BindManager bg = new BindManager(this); dsUnit = bg.BuildDataset(this.unitItem, ps); bg.BindFld(this, dsUnit); //对树的操作 bg.BindTrv(this.trvDept, this.dsUnit.Tables["组织机构"], "名称", "ID", "PID", "@名称={名称},@代码={代码},@序号={序号},@ParentCode={ParentCode},@独立管理={独立管理},@分类={分类},@性质={性质},@部门主管={部门主管},@部门职责={部门职责},@班次代码={班次代码},@班次名称={班次名称},@周一={周},@周二={周二},@周三={周三},@周四={周四},@周五={周五},@周六={周六},@周日={周日},@level={level}"); this.trvDept.ExpandAll(); }
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["Dept"] = this.lookDept.EditValue; pstrans["EmployNO"] = (object)this.txtEmployName.Text; //查询数据 QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile); BindManager bg = new BindManager(this); ds = bg.BuildDataset(this.unitItem, pstrans); Granity.granityMgr.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); }
/// <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["StartTime"] = this.dateStart.EditValue.ToString(); pstrans["EndTime"] = this.dateEnd.EditValue.ToString(); pstrans["CardType"] = this.CbCardtype.EditValue != null?this.CbCardtype.EditValue.ToString() : string.Empty; pstrans["CarNo"] = this.TxtCarNo.Text.Trim(); pstrans["UsrNo"] = this.txtuserID.Text.Trim(); pstrans["Name"] = this.txtuserName.Text.Trim(); pstrans["CardNo"] = this.TxtCardNo.Text.Trim(); //查询数据 QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile); BindManager bg = new BindManager(this); DataSet ds = bg.BuildDataset(this.unitItem, pstrans); bg.BindFld(this, ds); }
/// <summary> /// 窗口初始化 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void ParkStallSetFrm_Load(object sender, EventArgs e) { //初始化参数和单元 this.paramwin = BindManager.getSystemParam(); NameObjectList pstrans = BindManager.getTransParam(); ParamManager.MergeParam(this.paramwin, pstrans); this.unitItem = new UnitItem(DataAccRes.AppSettings("WorkConfig"), unitName); //绑定数据 this.bindMgr = new BindManager(this); this.paramwin["code"] = DBNull.Value; this.ds = this.bindMgr.BuildDataset(this.unitItem, this.paramwin); this.Query = new QueryDataRes(this.unitItem.DataSrcFile); this.bindMgr.BindFld(this, ds); //对树的操作 DataTable tab = this.ds.Tables["停车场管理"]; this.bindMgr.BindTrv(this.trvParkStall, tab, "名称", "ID", "PID", "@ID={ID},@PID={PID},@编号={编号},@站址={站址}"); this.trvParkStall.ExpandAll(); tab.ColumnChanged += new DataColumnChangeEventHandler(tab_ColumnChanged); if (this.trvParkStall.Nodes.Count > 0) { this.trvParkStall.SelectedNode = this.trvParkStall.Nodes[0]; } this.panGrpParam.Hide(); this.panGrpFee.Dock = DockStyle.Fill; this.panGrpParam.Dock = DockStyle.Fill; //初始化收费参数编辑控件事件 this.setTextChanged(this.tabFeeStd); this.setCheckedChanged(this.grpbAccept); this.setCheckedChanged(this.grpbCardType); this.setCheckedChanged(this.grpbChannel); }
/// <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 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); }
private void FrmParkDeposit_Load(object sender, EventArgs e) { this.setContainerTagValue(this.grpInfo, this.tag, "pm"); //直接通讯获取停车费用 if (this.addrst < 0 || null == this.target) { return; } string cardnum = basefun.valtag(this.tag, "卡号"); string cardtype = basefun.valtag(this.tag, "卡类"); string cartype = basefun.valtag(this.tag, "车型"); string dtparkin = basefun.valtag(this.tag, "入场时间"); if (string.IsNullOrEmpty(cardtype) || string.IsNullOrEmpty(cartype) || string.IsNullOrEmpty(dtparkin)) { return; } string data = ""; NameObjectList ps = ParamManager.createParam(this.tag); foreach (string key in ps.AllKeys) { data = basefun.setvaltag(data, "{" + key + "}", Convert.ToString(ps[key])); } data = basefun.setvaltag(data, "设备地址", Convert.ToString(this.addrst)); data = basefun.setvaltag(data, "{设备地址}", Convert.ToString(this.addrst)); string dtparkout = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); data = basefun.setvaltag(data, "{出场时间}", dtparkout); data = basefun.setvaltag(data, "{出入场时间}", dtparkout); data = basefun.setvaltag(data, "{开闸方式}", "00"); this.tag = data; CmdProtocol cmdP = new CmdProtocol(false); cmdP.setCommand("停车场", "计算收费金额", data); CommiManager.GlobalManager.SendCommand(this.target, cmdP); if (!cmdP.EventWh.WaitOne(2000, false)) { return; } string money = basefun.valtag(cmdP.ResponseFormat, "{收费金额}"); if (string.IsNullOrEmpty(money)) { return; } this.tbPkmoney.Text = money; this.tag = basefun.setvaltag(this.tag, "{收费金额}", money); string cardmoney = basefun.valtag(this.tag, "{卡片余额}"); try { money = Convert.ToString(Convert.ToDecimal(money) - Convert.ToDecimal(cardmoney)); this.tbPkfee.Text = money; this.tag = basefun.setvaltag(this.tag, "{收费}", money); } catch { } }
/// <summary> /// 利用参数数组分别按照新增,更新,删除的类别来更新数据;保证事务的一致性 /// 在执行更新时,按照删除,更新,新增的顺序执行,以避免并发冲突问题 /// </summary> /// <param name="item">要提交的数据项目</param> /// <param name="paramsIns">提交的新增参数</param> /// <param name="paramsUpt">提交的更新参数</param> /// <param name="paramsDel">提交的删除参数</param> /// <param name="strParams">附加字符串数组参数</param> /// <returns>操作是否成功</returns> public bool ExecuteNonQuery(string item, NameObjectList paramsIns, NameObjectList paramsUpt, NameObjectList paramsDel, string[] strParams) { if ("" == item || null == paramsIns || null == paramsUpt || null == paramsDel) { return(false); } return(this._QueryDAO.ExecuteNonQuery(item, paramsIns, paramsUpt, paramsDel, strParams)); }
/// <summary> /// 利用参数按照"delete"项来删除数据 /// </summary> /// <param name="item">要提交的数据项目</param> /// <param name="parameters">提交的参数</param> /// <param name="strParams">约定??num为自定义变量,通过传递的定符串替代之</param> /// <returns>操作是否成功</returns> public bool ExecuteDelete(string item, NameObjectList parameters, string[] strParams) { if (item == "" || parameters == null) { return(false); } return(this._QueryDAO.ExecuteDelete(item, parameters, strParams)); }
/// <summary> /// 更新大字段内容,一次只能更新一条记录,大字段使用stream类型传递 /// </summary> /// <param name="item">数据项目名称</param> /// <param name="paramlist">字段参数列表,大字段使用stream类型传递</param> /// <returns>更新是否成功</returns> public bool WriteSingleStream(string item, NameObjectList paramlist) { if (item == "" || paramlist == null) { return(false); } return(this._QueryDAO.WriteSingleStream(item, paramlist)); }
/////////////////////////////////////////////////////////////////////////////// // Eventhandler // /////////////////////////////////////////////////////////////////////////////// #region EVENTS /////////////////////////////////////////////////////////////////////////////// // Eventhandler for UI, Menu, Buttons, Toolbars etc. // /////////////////////////////////////////////////////////////////////////////// #region WINDOWSEVENTHANDLER #endregion //WINDOWSEVENTHANDLER /////////////////////////////////////////////////////////////////////////////// // Eventhandler for Custom Defined Events // /////////////////////////////////////////////////////////////////////////////// #region CUSTOMEVENTHANDLER #endregion //CUSTOMEVENTHANDLER #endregion //EVENTS /////////////////////////////////////////////////////////////////////////////// // Methods and Eventhandling for Background tasks // /////////////////////////////////////////////////////////////////////////////// #region BACKGROUNDWORKER #endregion //BACKGROUNDWORKER /////////////////////////////////////////////////////////////////////////////// // Methods for doing main class job // /////////////////////////////////////////////////////////////////////////////// #region METHODS /// <summary> /// This method returns a sorted <see cref="List{Slide}"/> with the whole /// slideshow. /// </summary> /// <returns>A sorted <see cref="List{Slide}"/> with all slides from the whole /// slideshow.</returns> private NameObjectList<Slide> GetSlides() { NameObjectList<Slide> slides = new NameObjectList<Slide>(); this.ParseNodeForSlides(ref slides, this); return slides; }
/// <summary> /// This method iterates recursively through the tree to return only the slides /// contained in the tree. /// </summary> /// <param name="slides">Ref. The output <see cref="NameObjectList{Slide}"/> of slides.</param> /// <param name="node">The <see cref="TreeNode"/> to parse.</param> private void ParseNodeForSlides(ref NameObjectList<Slide> slides, TreeNode node) { // Check all child nodes foreach (TreeNode subNode in node.Nodes) { // If a slide is contained, add it to the list Slide slide = ((SlideshowTreeNode)subNode).Slide; if (slide != null) { slides.Add(slide.Name, slide); } // Iterate recursively this.ParseNodeForSlides(ref slides, subNode); } }