public void AddEateryStatus(string msg) { QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile); DataTable tab = this.dbgrid.DataSource as DataTable; if (null == tab) return; string CardMoney = ""; string CardAddMoney = ""; if (tab.Rows.Count > 0) { CardMoney = tab.Rows[tab.Rows.Count - 1]["�����"].ToString(); CardAddMoney = tab.Rows[tab.Rows.Count - 1]["�������"].ToString(); } if (CardMoney == basefun.valtag(msg, "{�����}") && CardAddMoney == basefun.valtag(msg, "{�ۼƲ������}")) return; if (i == 0) gridViewInfo.DeleteRow(0); DataRow dr = tab.NewRow(); dr["����"] = basefun.valtag(msg, "{����}"); dr["����ʱ��"] = basefun.valtag(msg, "{����ʱ��}"); dr["�����"] = basefun.valtag(msg, "{�����}"); dr["���"] = basefun.valtag(msg, "{���ѽ��}"); dr["״̬"] = basefun.valtag(msg, "{״̬}"); dr["���ѻ���"] = basefun.valtag(msg, "{���ѻ���}"); dr["�������"] = basefun.valtag(msg, "{�ۼƲ������}"); dr["���"] = i + 1; tab.Rows.Add(dr); i++; if (this.gridViewInfo.RowCount > 15) this.gridViewInfo.DeleteRow(this.gridViewInfo.RowCount - 1); }
/// <summary> /// 根据相应条件查询记录 /// </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); }
/// <summary> /// Ĭ�Ϸ�ʽ����ʵ��,����ʼ��ͬ���¼����,��ָ��ID /// </summary> public CmdProtocol() : base() { try { this.query = new QueryDataRes(dbSrc); } catch (Exception ex) { } this.TimeOut = new TimeSpan(200 * 10000); this.TimeFailLimit = new TimeSpan(600 * 10000); this.TimeLimit = new TimeSpan(600 * 10000); this.IsResposeHandle = this.isResponse; }
/// <summary> /// 设备巡检管理构造函数 /// </summary> public DeviceMonitorMgrBak() { this.unitItem = new UnitItem(DataAccRes.AppSettings("WorkConfig"), "设备监控服务"); this.query = new QueryDataRes(this.unitItem.DataSrcFile); //2分钟执行一次 tmService.Interval = 360000; tmService.Elapsed += new ElapsedEventHandler(tmService_Elapsed); tmService.Enabled = true; tmService.Start(); }
/// <summary> /// ʱ��β飬�������û���ţ����� ���� /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnSelect_Click(object sender, EventArgs e) { DataTable tab = this.dbHitCard.DataSource as DataTable; if (null == tab) return; string filter = " a.ʱ��>=(SELECT convert(datetime,'{0}',121)) and a.ʱ��<=(SELECT convert(datetime,'{1}',121)) and(a.���� like'%{2}%' or a.�û���� like '%{2}%'or b.NAME like'%{2}%' or c.���� like '%{2}%' )"; filter = string.Format(filter, this.cboStart.Text.Replace("'", "''"), this.cboEnd.Text.Replace("'", "''"), this.txtCheck.Text.Replace("'", "''")); QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile); tab.Clear(); query.FillDataSet(tab.TableName, this.paramwin, ParamManager.setMacroParam(MacroPmType.FW, filter), this.dsUnit); }
public DataTable getUser() { //�õ�����Դ QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile); this.dsUnit.Tables["������Ա"].Clear(); //ִ�в�ѯ���� NameObjectList ps = new NameObjectList(); ps["ֵ����"] = cbbAccount.Text; query.FillDataSet("������Ա", ps, this.dsUnit); return dsUnit.Tables["������Ա"]; }
/// <summary> /// ��ȡ�������� /// </summary> public void getNewDataByCardNo(string cardno) { NameObjectList pstrans = new NameObjectList(); ParamManager.MergeParam(pstrans, this.paramwin); pstrans["����"] = cardno; //��ѯ���� QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile); DataTable tab = dsUnit.Tables["�����"]; tab.Clear(); query.FillDataSet(tab.TableName, pstrans, this.dsUnit); }
/// <summary> /// ������ѯ �û����,���ţ����������ż��� /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnCheck_Click(object sender, EventArgs e) { DataTable tab = this.dbGrid.DataSource as DataTable; if (null == tab) return; string filter = ""; filter = "(a.�û���� like '{0}'or a.���� like '%{0}%' or b.name like '%{0}%' or e.���� like '%{0}%')"; filter = string.Format(filter, this.tbcardno.Text.Replace("'", "''")); QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile); tab.Clear(); query.FillDataSet(tab.TableName, this.paramwin, ParamManager.setMacroParam(MacroPmType.FW, filter), this.dsUnit); }
/// <summary> /// 根据门岗查询设备 /// </summary> public void GetDEvById(string DoorID) { //获取当前单元名称 DataTable tab = this.dbDev.DataSource as DataTable; if (null == tab) return; string filter = ""; filter = "门岗ID='{0}'"; filter = string.Format(filter, DoorID.Replace("'", "''")); QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile); tab.Clear(); query.FillDataSet(tab.TableName, this.paramwin, ParamManager.setMacroParam(MacroPmType.FW, filter), this.ds); }
private void trvDept_AfterSelect(object sender, TreeViewEventArgs e) { if (null == e.Node) return; //查询明细数据 DataTable tabDetail = this.dsUnit.Tables["组织机构"]; string tag = Convert.ToString(e.Node.Tag); NameObjectList ps = new NameObjectList(); ParamManager.MergeParam(ps, this.paramwin); ParamManager.MergeParam(ps, ParamManager.createParam(tag)); ps["UnitCode"] = basefun.valtag(e.Node.Tag.ToString(), "代码"); if (null != tabDetail) tabDetail.Clear(); QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile); query.FillDataSet("组织机构", ps, this.dsUnit); checkBox1.Checked = Convert.ToBoolean(this.dsUnit.Tables[0].Rows[0]["独立管理"].ToString()); checkBox2.Checked = Convert.ToBoolean(this.dsUnit.Tables[0].Rows[0]["周一"].ToString()); checkBox3.Checked = Convert.ToBoolean(this.dsUnit.Tables[0].Rows[0]["周二"].ToString()); checkBox4.Checked = Convert.ToBoolean(this.dsUnit.Tables[0].Rows[0]["周三"].ToString()); checkBox5.Checked = Convert.ToBoolean(this.dsUnit.Tables[0].Rows[0]["周四"].ToString()); checkBox6.Checked = Convert.ToBoolean(this.dsUnit.Tables[0].Rows[0]["周五"].ToString()); checkBox7.Checked = Convert.ToBoolean(this.dsUnit.Tables[0].Rows[0]["周六"].ToString()); checkBox8.Checked = Convert.ToBoolean(this.dsUnit.Tables[0].Rows[0]["周日"].ToString()); //if (null == tabChanged) // return; //tabDetail = this.dsUnit.Tables["组织机构"]; //TreeNode trnsel, trn; //trn = trnsel = e.Node; //string strdept = ""; //while (null != trnsel) //{ // if (null != trn.FirstNode) // { // trn = trn.FirstNode; // continue; // } // string t = Convert.ToString(trn.Tag); // strdept += " or 部门='" + basefun.valtag(t, "部门") + "'"; // if (trnsel == trn) // break; // if (null != trn.NextNode) // trn = trn.NextNode; // else // trn = trn.Parent; // if (trnsel == trn) // break; //} //if (strdept.Length > 0) // strdept = strdept.Substring(3); //BindManager.UpdateTable(tabDetail, tabChanged, strdept); }
/// <summary> /// 保存 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void BtSave_Click(object sender, EventArgs e) { QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile); bool isSuccess = BindManager.Save(query, this.ds, this.paramwin); if (!isSuccess) { XtraMessageBox.Show("保存失败,请检查数据是否合法!", "保存提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { XtraMessageBox.Show("保存成功!", "保存提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// 条件查询 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnCheck_Click(object sender, EventArgs e) { string StartDtTime = this.cboStartDate.Text + " " + this.cboStartTime.Text; string EndDtTime = this.cboEndDate.Text + " " + this.cboEndTime.Text; //获取当前单元名称 DataTable tab = this.dbGrid.DataSource as DataTable; if (null == tab) return; string filter = ""; filter = "a.接班时间 between '{0}' and '{1}'and a.接班人 like '%{2}%'and a.交班人 like '%{3}%'"; filter = string.Format(filter, StartDtTime.Replace("'", "''"), EndDtTime.Replace("'", "''"), this.cboStartEmp.Text.Replace("'", "''"), this.cboEndEmp.Text.Replace("'", "''")); QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile); tab.Clear(); query.FillDataSet(tab.TableName, this.paramwin, ParamManager.setMacroParam(MacroPmType.FW, filter), this.dsUnit); }
/// <summary> /// 根据条件查询相应的记录 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void BtQuery_Click(object sender, EventArgs e) { NameObjectList ps = new NameObjectList(); ps["StartDate"] = this.dateStart.EditValue; ps["EndDate"] = this.dateEnd.EditValue; ps["Type"] = this.lookType.EditValue; ps["Dept"] = this.lookDept.EditValue; ps["EmployNO"] = (object)this.txtEmployNo.Text; ParamManager.MergeParam(ps, this.paramwin,false); //查询数据 QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile); DataTable tab = this.grdConsumeList.DataSource as DataTable; tab.Clear(); query.FillDataSet(tab.TableName, ps, this.ds); }
public void ProcessRequest(HttpContext context) { if (ThreadManager.IsResetNeed) { CommiManager.GlobalManager.ClearCommand(); ThreadManager.AbortAll(); CommiManager.GlobalManager.ResetClient(); DeviceEatery.ResetQueue(); DeviceDoor.ResetQueue(); DeviceChannel.ResetQueue(); Thread.Sleep(new TimeSpan(0, 5, 0)); return; } if (null == unitItem) { unitItem = new UnitItem(DataAccRes.AppSettings("WorkConfig"), "设备监控服务"); query = new QueryDataRes(unitItem.DataSrcFile); } StreamReader reader = new StreamReader(context.Request.InputStream); NameValueCollection ps = HttpUtility.ParseQueryString(reader.ReadToEnd()); string cmd = ps["cmd"]; string response = ""; cmdtrans.TimeOut = new TimeSpan(0, 0, 0, 0, 600); cmdtrans.TimeFailLimit = new TimeSpan(0, 0, 0, 2); switch (cmd) { //定时巡检数据 case "getrecord": string dtcheck = ps["dtUpdate"]; string depts = ps["depts"]; DateTime dt = Convert.ToDateTime(dtcheck); response = this.getChannelRecord(dt, depts); break; //定时巡检数据 case "getrdregion": string dtrefresh = ps["dtUpdate"]; string regions = ps["regions"]; DateTime dt2 = Convert.ToDateTime(dtrefresh); response = this.getRegionRecord(dt2, regions); break; //定时巡检数据 case "getregionsum": string region = ps["region"]; response = this.getRegionSum(region); break; } context.Response.Write(response); }
/// <summary> /// 消费设备构造函数 /// </summary> public DeviceEatery() : base() { if (null == unitItem) unitItem = new UnitItem(DataAccRes.AppSettings("WorkConfig"), "消费监控"); this.query = new QueryDataRes(unitItem.DataSrcFile); //设置默认超时时间 string inv = DataAccRes.AppSettings("commiTimeout"); if (string.IsNullOrEmpty(inv)) return; int timeout = 0; try { timeout = Convert.ToInt16(inv); } catch { return; } this.waitTime = new TimeSpan(0, 0, 0, 0, timeout / 10 * 35); }
/// <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); }
/// <summary> /// 根据单据类别和部门生成编号 /// </summary> /// <param name="billType">单据类型</param> /// <param name="deptCode">部门</param> /// <returns></returns> static public string GetBillSn(string billType, string deptCode) { if ("" == billType || "" == deptCode) { return(""); } NameObjectList paramList = new NameObjectList(); QueryDataRes query = QueryDataRes.CreateQuerySys(); paramList.Add("单据类型", billType); paramList.Add("部门", deptCode); //没有就创建一个 DataTable tab = query.getTable("单据流水号", paramList); if (tab.Rows.Count < 1 || null == tab.Rows[0]["流水号"]) { return(""); } return(tab.Rows[0]["流水号"].ToString()); }
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); }
/// <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); }
/// <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); }
public static DataSet PrnDataSet(UnitItem unititem, Hashtable itemhash, XmlDocument xmlsys) { DataSet dataset = new DataSet(); QueryDataRes query = new QueryDataRes(unititem.DataSrcFile); NameObjectList paramlist = BuildParamList.BuildParams(xmlsys); DataTable tab = new DataTable(); for (int i = 0; i < unititem.WorkItemList.Length; i++) { string dataname = unititem.WorkItemList[i].DataSrc; if (itemhash["[table]" + dataname] != null) { tab = query.getTable(dataname, paramlist, getStrParams(xmlsys, unititem.WorkItemList[i])); dataset.Tables.Add(tab); } if (itemhash["[dtable]" + dataname] != null) { tab = query.getTable(dataname, paramlist, getStrParams(xmlsys, unititem.WorkItemList[i])); dataset.Tables.Add(tab); } if (itemhash["[mtable]" + dataname] != null) { tab = query.getTable(dataname, paramlist, getStrParams(xmlsys, unititem.WorkItemList[i])); dataset.Tables.Add(tab); } } return dataset; }
protected void Page_Load(object sender, EventArgs e) { if (Session["userid"] == null) { this.Response.Write("<script language=\"javascript\">"); this.Response.Write("alert('您未正常登录,请登录后再使用,谢谢!')"); this.Response.Write("</script>"); this.Response.Redirect("index.htm"); } XmlDocument xmldoc = new XmlDocument(); //读取用户参数 StreamReader streamreader = new StreamReader(this.Request.InputStream, Encoding.UTF8); xmldoc.LoadXml(streamreader.ReadToEnd()); string[] strParams = this.getStrParams(xmldoc); NameObjectList paramlist = BuildParamList.BuildParams(xmldoc); try { string unitName = paramlist["UnitName"].ToString(); if (paramlist["DictSrcFile"]==null) unitItem = new UnitItem(DataAccRes.AppSettings("WorkConfig"), unitName); } catch (Exception ex) { ExceptionManager.Publish(ex); return; } string workItemName = ""; WorkItem workitem = null; QueryDataRes query; if (paramlist["DataSrcFile"]!=null) query = new QueryDataRes(paramlist["DictSrcFile"].ToString()); else query = new QueryDataRes(unitItem.DictColSrcFile); DataSet ds = new DataSet("Dict"); ds.EnforceConstraints = false; //htm页面控件字典或人工指定字典 string itemdatas = paramlist["htmldict"].ToString(); string itemdata = paramlist["htmldict"].ToString(); string itemtable = itemdata; if(itemdatas.IndexOf(";")>-1) { string[] arr = leofun.getArrayFromString(itemdatas,";"); itemdata = arr[0]; itemtable = arr[1]; } if (itemdata != "") { query.FillDataSet(itemdata, paramlist, strParams, ds); } else { for (int i = 0; i < unitItem.WorkItemList.Length; i++) { for (int j = 0; j < unitItem.WorkItemList[i].DictCol.Length; j++) { string dictsrcs = unitItem.WorkItemList[i].DictCol[j].DataSrc; string dictsrc = unitItem.WorkItemList[i].DictCol[j].DataSrc; itemtable = dictsrc; if (dictsrcs == "" || dictsrcs == null) continue; if (dictsrcs.IndexOf(";") > -1) { string[] arr = leofun.getArrayFromString(dictsrcs, ";"); dictsrc = arr[0]; itemtable = arr[1]; } query.FillDataSet(dictsrc, paramlist, strParams, ds); } } } if (ds.Tables.Count > 0 && itemtable != "") ds.Tables[0].TableName = itemtable; XmlDataDocument xmldocData = new XmlDataDocument(ds); this.Response.ContentType = "text/xml; charset=gb2312"; xmldocData.Save(this.Response.Output); }
/// <summary> /// ����ͣ������Ʊ�� /// </summary> private void searchPark() { QueryDataRes query = new QueryDataRes("cardone"); NameObjectList ps = new NameObjectList(); DataTable tab = query.getTable("devlist", ps); if (null == tab || tab.Rows.Count < 1) return; for (int i = 0; i < tab.Rows.Count; i++) { DataRow dr = tab.Rows[i]; string commitype = Convert.ToString(dr["���ʷ�ʽ"]); if ("1" == commitype) commitype = "Ser"; if ("2" == commitype) commitype = "TCP"; if ("Ser" != commitype && "TCP" != commitype) commitype = "UDP"; string port = Convert.ToString(dr["�˿�"]); if ("Ser" == commitype) port = "COM" + port; //����ֶ�˳�����, �豸����, �豸����, IP��ַ, �˿�, ͨѶ���, ͨѶվַ, ��������, Ĭ������, �����ַ string[] ipAddrs = new string[10]; ipAddrs[0] = i.ToString(); ipAddrs[1] = "ͣ������Ʊ��"; ipAddrs[2] = Convert.ToString(dr["����"]); ipAddrs[3] = Convert.ToString(dr["��ַ"]); ipAddrs[4] = port; ipAddrs[5] = commitype; ipAddrs[6] = Convert.ToString(dr["�豸��ַ"]); ipAddrs[7] = ""; ipAddrs[8] = ""; ipAddrs[9] = ""; DataGridViewRow drPark = this.getRow(ipAddrs[3], port, ipAddrs[6]); if (null != drPark) drPark.SetValues(ipAddrs); else this.gdGrid.Rows.Add(ipAddrs); } }
/// <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 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 simpleButton1_Click(object sender, EventArgs e) { if (Convert.ToString(gridView1.GetDataRow(0)["ͣ����IDģʽ"]) != Convert.ToString(gridView1.GetDataRow(0)["�Ž�IDģʽ"]) || Convert.ToString(gridView1.GetDataRow(0)["ͣ����IDģʽ"]) != Convert.ToString(gridView1.GetDataRow(0)["����IDģʽ"]) || Convert.ToString(gridView1.GetDataRow(0)["����IDģʽ"]) != Convert.ToString(gridView1.GetDataRow(0)["�Ž�IDģʽ"])) { MessageBox.Show("IC,IDģʽ����ͬʱʹ�ã�", "ϵͳ��ʾ", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile); bool isSuccess = BindManager.Save(query, this.dsUnit, this.paramwin); if (!isSuccess) MessageBox.Show("����ʧ�ܣ����������Ƿ�Ϸ���", "������ʾ", MessageBoxButtons.OK, MessageBoxIcon.Warning); else MessageBox.Show("����ɹ���", "������ʾ", MessageBoxButtons.OK, MessageBoxIcon.Information); }
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; }
public static XmlDocument makeprint(UnitItem UnitItem,XmlDocument xmlsys,string UserId) { //写入Excel的方法: //定义需要参数。<明细>5,2,10,15; string TemplatePath = HttpContext.Current.Server.MapPath(DataAccRes.AppSettings("TpFilePath")); //存放源文件的文件夹路径。 //初始化XML命名空间 string nsp = "urn:schemas-microsoft-com:office:spreadsheet"; XmlDocument xmldoc = new XmlDocument(); try { xmldoc.Load(TemplatePath + "\\" + UnitItem.FilePrnTp); } catch { string strMSG = "请关闭正在打开的模板文件" + UnitItem.FilePrnTp + "!"; System.Web.HttpContext.Current.Response.Write(" <script language=\"javascript\"> "); System.Web.HttpContext.Current.Response.Write("alert('" + strMSG + "')"); System.Web.HttpContext.Current.Response.Write(" </script> "); return null; } XmlNamespaceManager xmlNsmgl = new XmlNamespaceManager(xmldoc.NameTable); xmlNsmgl.AddNamespace("docpro", nsp); //读出"Cell"节点中的定义值,得到循环数据区位置值 XmlNodeList xmlNodes = xmldoc.DocumentElement.SelectNodes("//docpro:Cell", xmlNsmgl); //修改:<明细>改为#dataitem name,ItemHash存贮dataitem name, 起始(行,列),列数,每页行数 Hashtable ItemHash = PrnDataItems(xmlNodes); //得到模板用到的所有参数 QueryDataRes query = new QueryDataRes(UnitItem.DataSrcFile); NameObjectList paramlist = BuildParamList.BuildParams(xmlsys); XmlNodeList xmlNodesRow = xmldoc.DocumentElement.SelectNodes("//docpro:Row", xmlNsmgl); XmlNodeList xnode = null; User userRight = new User(UserId); SetParamData(xmlNodes,userRight,paramlist); //先处理主表,并将主表记录做为参数记录在paramlist paramlist = SetMasterData(UnitItem,xmlsys,query,xmlNodes, UserId, paramlist); setpageSetup(xmldoc, userRight, paramlist); for (int i = 0; i < UnitItem.WorkItemList.Length; i++) { if (UnitItem.WorkItemList[i].ItemType == WorkItemType.MasterData) continue; string dataname = UnitItem.WorkItemList[i].DataSrc; if (ItemHash["[table]" + dataname] != null || ItemHash["[dtable]" + dataname] != null || ItemHash["[mtable]" + dataname] != null) { DataTable oData = query.getTable(dataname, paramlist, getStrParams(xmlsys, UnitItem.WorkItemList[i])); string[] arrDetail = null; if(ItemHash["[table]" + dataname] != null) arrDetail = leofun.getArrayFromString(ItemHash["[table]" + dataname].ToString(), ","); if (ItemHash["[dtable]" + dataname] != null) arrDetail = leofun.getArrayFromString(ItemHash["[dtable]" + dataname].ToString(), ","); if (ItemHash["[mtable]" + dataname] != null) arrDetail = leofun.getArrayFromString(ItemHash["[mtable]" + dataname].ToString(), ","); int startrow = toInt(arrDetail[0]) - 1; int startcol = toInt(arrDetail[1]); int fldcount = toInt(arrDetail[2]); int prnPageSize = toInt(arrDetail[3]); XmlNode rowboot = xmlNodesRow[startrow].ParentNode; string[] arrfld = null; arrfld = getExcelFields(xmlNodesRow[startrow]); //当为散步分布时,不能取出字段名 for (int m = 0; m < oData.Rows.Count; m++) {if (prnPageSize == 1) continue; XmlNode baknode = xmlNodesRow[startrow].CloneNode(true); xnode = xmlNodesRow[startrow + m].ChildNodes; for (int n = 0; n < fldcount; n++) if (xnode[n].ChildNodes[0] == null) xnode[n].AppendChild(baknode.ChildNodes[n].ChildNodes[0]); } if ((ItemHash["[dtable]" + dataname] != null || ItemHash["[mtable]" + dataname] != null) && oData.Rows.Count>0) SetMTableData(dataname, oData, xmlNodes); else { for (int m = 0; m < oData.Rows.Count; m++) { xnode = xmlNodesRow[startrow + m].ChildNodes; for (int n = 0; n < fldcount; n++) { string fldname = arrfld[n].Replace(dataname+".",""); //处理单表格数据 string valfld=""; if (m>oData.Rows.Count) valfld = (null == oData.Rows[m][fldname]) ? "" : oData.Rows[m][fldname].ToString(); switch (oData.Columns[fldname].DataType.Name) { case "Double": if (valfld != "") valfld = Convert.ToDouble(valfld).ToString("#0.00"); break; case "DateTime": if (valfld == "") break; valfld = Convert.ToDateTime(valfld).ToString("hh:mm"); break; } if (xnode[n] != null && xnode[n].ChildNodes[0] != null) xnode[n].ChildNodes[0].InnerText = valfld; } } } } } return xmldoc; }
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 devices = ps["devices"]; string response = ""; if (string.IsNullOrEmpty(devices)) devices = ""; string[] devid = devices.ToLower().Split(",".ToCharArray(), StringSplitOptions.RemoveEmptyEntries); foreach (string d in devid) { if (hdlDownParam.Contains(d)) devices = devices.Replace(d, ""); } devid = devices.ToLower().Split(",".ToCharArray(), StringSplitOptions.RemoveEmptyEntries); devices = ""; foreach (string d in devid) devices += "," + d; if (!string.IsNullOrEmpty(devices)) devices = devices.Substring(1); //提取记录 "false"==ps["reset"] //重采记录 "true"==ps["reset"] //继续重采记录 "1"==ps["reset"] if ("true" == ps["reset"]) DeviceEatery.ResetPosition("true"); if ("false" == ps["reset"] || string.IsNullOrEmpty(ps["reset"])) DeviceEatery.ResetPosition("false"); else { //继续重采记录 if (string.IsNullOrEmpty(devices)) devices = ""; for (int i = 0; i < devid.Length; i++) DeviceEatery.ResetPosition(devid[i]); } cmdtrans.TimeOut = new TimeSpan(0, 0, 0, 0, 600); cmdtrans.TimeFailLimit = new TimeSpan(0, 0, 0, 2); switch (cmd) { //启动监听 case "monitor": response = "@成功=true"; if (!this.Monitor(devices)) response = "@成功=false"; break; //停止监听 case "halt": response = "@成功=true"; if (!this.Halt(devices)) response = "@成功=false"; break; //定时巡检数据 case "getrecord": string datatype = ps["datatype"]; string dtcheck = ps["dtUpdate"]; DateTime dt = Convert.ToDateTime(dtcheck); response = this.getRecord(dt, devices, datatype); break; //读取记录 case "readrecord": response = this.readRecord(devices); break; //火警开门 case "fireopendoor": this.FireOpenDoor(devices); response = "@成功=true"; break; //搜索使用网络模块设备 case "searchznet": string[] info = CmdUDPznetCom.SearchUDPnet(); foreach (string val in info) response += ";" + val; if (!string.IsNullOrEmpty(response)) response = response.Substring(1); break; //搜索使用门禁模块设备 case "searchdoor": string[] door = CmdUDPznetCom.SearchUDPDoor(); foreach (string val in door) response += ";" + val; if (!string.IsNullOrEmpty(response)) response = response.Substring(1); break; //广播重启门禁设备 case "setipdoor": response = "@成功=false"; try { int st = Convert.ToInt32(ps["station"]); string ipaddr = ps["ipaddr"]; string maskcode = ps["maskcode"]; string gateway = ps["gateway"]; bool suc = false; suc = CmdUDPznetCom.SetTCPIPDoor(st, ipaddr, maskcode, gateway, ""); if (suc) response = "@成功=true"; } catch { } break; } context.Response.Write(response); }
/// <summary> /// 保存卡权限 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void BtSave_Click(object sender, EventArgs e) { CardAll = string.Empty; DoorAll = string.Empty; controlAll = string.Empty; #region 遍历选择的卡 foreach (TreeListNode Card in this.treDept.Nodes) { checkCard(Card); } #endregion #region 遍历选择的门 foreach (TreeListNode Door in this.treDoorAll.Nodes) { checkDoor(Door); } #endregion if (CardAll == string.Empty) { XtraMessageBox.Show("请选择部门或用户","系统提示!"); return; } //卡权限 string[] checkCardAll = CardAll.Split(','); foreach (string c in checkCardAll) { foreach (DataRow dr in this.ds.Tables["门禁权限设置"].Select(" 用户编号 ='"+ c +"'")) { dr.BeginEdit(); dr["权限"] = DoorAll; dr.EndEdit(); } } WhiteList(checkCardAll); 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); } }
private void Frm_Right_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.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(treCardAll_AfterCheckNode); this.treDept.FocusedNodeChanged += new FocusedNodeChangedEventHandler(treDept_FocusedNodeChanged); this.treDept.FocusedNode = this.treDept.Nodes.ParentNode; this.treDoorAll.AfterCheckNode += new NodeEventHandler(treDoorAll_AfterCheckNode); }