private void FrmRemotGate_Load(object sender, EventArgs e) { this.paramwin = BindManager.getSystemParam(); NameObjectList pstrans = BindManager.getTransParam(); ParamManager.MergeParam(this.paramwin, pstrans); unitName = pstrans["name"].ToString();//单元 this.Text = RemotGroup.Text = unitName; //获取当前单元名称 Dictionary<string, string> dict = new Dictionary<string, string>(); dict.Add("远程控制记录", "@db=remote_control"); dict.Add("入、出场记录历史查询", "@db=park_stall"); //dict.Add("非法开闸记录", "@db=InvalidOpenGate"); //数据源 string datasource = dict[this.unitName]; this.dbGrid.Tag = datasource; unitItem = new UnitItem(DataAccRes.AppSettings("WorkConfig"), unitName); //绑定数据 BindManager bg = new BindManager(this); ds = bg.BuildDataset(this.unitItem, this.paramwin); bg.BindFld(this, ds); //特殊业务处理 int count = this.dbGrid.Rows.Count - 1; if (count < 0) { count = 0; } //this.lblCount.Text = "总计 " + Convert.ToString(count) + " 条"; }
private void FrmTable_Load(object sender, EventArgs e) { //读取业务单元和传递参数 this.paramwin = BindManager.getSystemParam(); NameObjectList pstrans = BindManager.getTransParam(); ParamManager.MergeParam(this.paramwin, pstrans); unitName = pstrans["name"].ToString();//单元 this.Text = this.CountRecordGroup.Text = unitName; //获取当前单元名称 Dictionary<string, string> dict = new Dictionary<string, string>(); dict.Add("入场车流量统计表", "@db=入场车流量统计"); dict.Add("出场车流量统计表", "@db=出场车流量统计"); dict.Add("停车场收费统计表", "@db=停车场收费统计"); dict.Add("收费员收费统计表", "@db=收费员收费统计"); dict.Add("远程控制记录统计表", "@db=stateremote"); //数据源 string datasource = dict[this.unitName]; this.RecordGrid.Tag = datasource; NameObjectList ps = new NameObjectList(); ParamManager.MergeParam(ps, this.paramwin); ps["dt"] = this.dtpDate.Value; ps["type"] = this.cbRecordTp.SelectedIndex + 1; ps["操作员"] = null; unitItem = new UnitItem(DataAccRes.AppSettings("WorkConfig"), unitName); //绑定数据 BindManager bg = new BindManager(this); ds = bg.BuildDataset(this.unitItem, ps); bg.BindFld(this, ds); //特殊业务处理 this.lbcount.Text = "总记录: " + Convert.ToString(ds.Tables[0].Rows.Count) + " 条"; }
/// <summary> /// 改写BasePage起点定位单元规则,不继承父类规则 /// </summary> /// <param name="e"></param> override protected void OnInit(EventArgs e) { // // CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。 // if (Session["userid"] == null) { this.Response.Write("<script language=\"javascript\">"); this.Response.Write("alert('您未正常登录,请登录后再使用,谢谢!')"); this.Response.Write("</script>"); this.Response.Redirect("default.htm"); } this.PgInitRequestParams(); this.PgUnitName = BuildParamList.getValue(this.PgParamXmlDoc, "UnitName"); UnitItem parentUnit = new UnitItem(DataAccRes.AppSettings("WorkConfig"), this.PgUnitName); AppendItem appendItem = parentUnit.GetAppendItem( BuildParamList.getValue(this.PgParamXmlDoc,"AppendItem")); if (null != appendItem && (null == appendItem.UnitName || "" == appendItem.UnitName.Trim())) { this.PgUnitItem = new UnitItem(); WorkItem workitem = new WorkItem(); this.PgUnitItem.UnitName = appendItem.ItemName; this.PgUnitItem.DataSrcFile = parentUnit.DataSrcFile; this.PgUnitItem.DictColSrcFile = parentUnit.DictColSrcFile; workitem.ItemName = appendItem.ItemName; workitem.DataSrc = appendItem.DataSrc; workitem.ItemType = WorkItemType.MasterData; workitem.AliasList = new System.Collections.Specialized.NameValueCollection(); workitem.DictCol = new DictColumn[0]; workitem.Validities = new Validity[0]; this.PgUnitItem.WorkItemList = new WorkItem[1]; this.PgUnitItem.WorkItemList[0] = workitem; string strXmlItem = "<Item name='{0}' relation='D' linkcol='' dataitem='{1}'/>"; strXmlItem = string.Format(strXmlItem, workitem.ItemName, workitem.DataSrc); this.PgUnitItem.UnitNode.InnerXml = strXmlItem; } else if (null != appendItem) { this.PgUnitItem = new UnitItem(DataAccRes.AppSettings("WorkConfig"), appendItem.UnitName); this.PgUnitName = appendItem.UnitName; BuildParamList.setValue(this.PgParamXmlDoc, ParamRangeType.Page, ParamUseType.Data, "UnitName", appendItem.UnitName); } else if (null == appendItem) { this.PgUnitItem = parentUnit; this.PgUnitName = parentUnit.UnitName; } this.PgQuery = new QueryDataRes(this.PgUnitItem.DataSrcFile); this.PgDictQuery = new QueryDataRes(this.PgUnitItem.DictColSrcFile); this.PgWorkItemList = this.PgUnitItem.WorkItemList; this.PgUserRight = new Estar.Business.UserRight.User(this.Session["userid"].ToString()); //动态创建控件 this.PgWfInit(e); InitializeComponent(); //base.OnInit(e); }
/// <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(); }
private void FrmTest_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.ds = bg.BuildDataset(this.unitItem, this.paramwin); bg.BindFld(this, this.ds); }
private void FrmCardParam_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); }
private void FrmSysUsers_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); DataTable tab = dsUnit.Tables["新单位树全集"]; XunFan(tab); }
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); }
private void FrmCarStallSet_Load(object sender, EventArgs e) { this.paramwin = BindManager.getSystemParam(); NameObjectList pstrans = BindManager.getTransParam(); ParamManager.MergeParam(this.paramwin, pstrans); unitName = pstrans["name"].ToString();//单元 this.Text = unitName; //获取当前单元名称 Dictionary<string, string> dict = new Dictionary<string, string>(); dict.Add("车位组设置", "@db=车位组设置"); dict.Add("时段设置", "@db=时段设置"); if (unitName == "车位组设置") { panel3.Visible = false; this.panel4.Dock = System.Windows.Forms.DockStyle.Top; this.panel5.Dock = System.Windows.Forms.DockStyle.Top; } else if (unitName == "时段设置") { panel4.Visible = false; this.panel3.Dock = System.Windows.Forms.DockStyle.Top; this.panel5.Dock = System.Windows.Forms.DockStyle.Top; } //数据源 string datasource = dict[this.unitName]; this.dbGrid.Tag = datasource; unitItem = new UnitItem(DataAccRes.AppSettings("WorkConfig"), unitName); //绑定数据 BindManager bg = new BindManager(this); ds = bg.BuildDataset(this.unitItem, this.paramwin); bg.BindFld(this, ds); //列名显示 if (datasource == "@db=车位组设置") { string cols = "车组编号 100,名称 301, 数量 150, 备注 205"; bg.SetGridCols(this.dbGrid, cols); } if (datasource == "@db=时段设置") { string cols = "时段编号 80,时段名称 85, 开始时间1 85,截止时间1 85,开始时间2 85,截止时间2 85,"; cols += "开始日期 83,截止日期 83,星期六 50,星期日 50"; bg.SetGridCols(this.dbGrid, cols); } }
/// <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); }
private void FrmCheckWorkList_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); NameObjectList ps = new NameObjectList(); ParamManager.MergeParam(ps, this.paramwin); this.dateStart.EditValue = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm"); this.dateEnd.EditValue = System.DateTime.Now.AddDays(1).ToString("yyyy-MM-dd HH:mm"); ps["StartDate"] = this.dateStart.EditValue.ToString(); ps["EndDate"] = this.dateEnd.EditValue.ToString(); ds = bg.BuildDataset(this.unitItem, ps); InitLookUp(); }
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; }
/// <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; } string dataStart= this.dateStart.Text.Trim(); string dataEnd = this.dateEnd.Text.Trim(); string where = " 时间 >= '" + dataStart + "' and 时间 <= '" + dataEnd + "' "; if (this.lookDoor.EditValue != null && this.lookDoor.EditValue.ToString() != "全部") { where += " and 门编号='" + this.lookDoor.EditValue.ToString() + "'"; } this.paramwin = BindManager.getSystemParam(); NameObjectList ps = new NameObjectList(); ps["StartDate"] = this.dateStart.EditValue.ToString(); ps["EndDate"] = this.dateEnd.EditValue.ToString(); ParamManager.MergeParam(ps, this.paramwin, false); this.unitItem = new UnitItem(DataAccRes.AppSettings("WorkConfig"), unitName); this.ds = this.bindMgr.BuildDataset(this.unitItem,ps); DataTable dt = this.ds.Tables["刷卡记录"].Clone(); DataTable dtReport = FunShare.GetTable(dt, this.ds.Tables["刷卡记录"].Select(where)); Report.viwReports View = new viwReports(); View.ReportName = "刷卡报表"; View.dt = dt; 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); }
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(); }
/// <summary> /// 根据窗口类型返回URL;应用于主窗口的附加功能 /// </summary> /// <param name="winType">窗口类型</param> /// <returns>打开工作单元附加功能窗口的URL</returns> private string getUrlByWinType(UnitItem unitItem, string winType, string strAppendName) { string ls_workurl=""; switch(winType.ToLower()) { //当前单元的明细内容 case "detail": string strTp = unitItem.FileEditTp; if(null==strTp || string.Empty==strTp) break; else ls_workurl="wfIndepend.aspx"; break; //当前单元的附加项内容 case "appenditem": AppendItem appendItem = unitItem.GetAppendItem(strAppendName); //取得appenditem的url,如果为HTML,则返回HTML路径 if (appendItem.HTMLURL == "") { switch (appendItem.FunType) { case AppendFunType.Browse: ls_workurl = @"wfSimpAppend.aspx?"; break; case AppendFunType.Import: ls_workurl = @"wfSimpAppend.aspx?"; break; case AppendFunType.Report: break; default: ls_workurl = @appendItem.HTMLURL + "?"; break; } } else { ls_workurl = @appendItem.HTMLURL+"?"; } ls_workurl +=appendItem.DialogHeight+","+appendItem.DialogWidth; break; //其他弹出窗口 case "chart": ls_workurl="wfChartModal.aspx"; break; case "print": string prnmode = DataAccRes.AppSettings("prnmode"); if (prnmode!=null) { if (prnmode.ToLower() == "inline") ls_workurl = "frmprint.aspx"; else ls_workurl = "frmprint.aspx?100,200"; } else ls_workurl = "frmprint.aspx?100,200"; break; //单独打开的单元 case "newwinitem": ls_workurl = @"wfSimpAppend.aspx?"; break; default: ls_workurl=string.Empty;break; } return ls_workurl; }
/// <summary> /// �����豸���캯�� /// </summary> public DeviceEatery() : base() { this.unitItem = new UnitItem(DataAccRes.AppSettings("WorkConfig"), "���Ѽ��"); this.query = new QueryDataRes(this.unitItem.DataSrcFile); }
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> /// <param name="devid">�豸ID��Ϊ������������豸��¼λ�ã���������Ϊ1��û�������</param> public static void ResetPosition(string devid) { bool isreset = false; if ("true" == devid) isreset = true; if ("true" == devid || "false" == devid) devid = ""; if (recordpos.ContainsKey(devid)) return; UnitItem unitItem = null; QueryDataRes query = null; if (isreset || !string.IsNullOrEmpty(devid)) { unitItem = new UnitItem(DataAccRes.AppSettings("WorkConfig"), "���Ѽ��"); query = new QueryDataRes(unitItem.DataSrcFile); } NameObjectList ps = new NameObjectList(); if (isreset) query.ExecuteNonQuery("��¼ָ��", ps, ps, ps); if (string.IsNullOrEmpty(devid)) { recordpos.Clear(); return; } ps["���ѻ�"] = devid; DataTable tab = query.getTable("��¼ָ��", ps); if (null == tab || tab.Rows.Count < 1) return; recordpos.Add(devid, Convert.ToInt32(tab.Rows[0]["��¼λ��"])); }
private void FrmQueryManage_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; LoadCardTyep(); LoadDev(); }
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 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; }
private void FrmCarParkInfo_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); DataTable tab = initDev(); if (null == tab || tab.Rows.Count < 1) XtraMessageBox.Show("�����÷�����", "ϵͳ��ʾ", MessageBoxButtons.OK, MessageBoxIcon.Warning); }
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; }
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); }
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); }
private void FrmRestaurant_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); //�����IJ��� DataTable tab = this.ds.Tables["����ά��"]; this.bindMgr.BindTrv(this.TreeDin, tab, "����", "id", "PID", "@ID={ID},@PID={PID},@���={���},@����={����}"); this.TreeDin.ExpandAll(); LoadTypeandCOM(); this.txtDinName.EditValueChanged += new EventHandler(txtEditValueChanged); }
private void FrmCarOutTotal_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); //������ unitItem = new UnitItem(DataAccRes.AppSettings("WorkConfig"), unitName); //������ BindManager bg = new BindManager(this); NameObjectList ps = new NameObjectList(); ParamManager.MergeParam(ps, this.paramwin); this.dateStart.EditValue = System.DateTime.Now.ToString("yyyy-MM-dd"); ps["dt"] = this.dateStart.EditValue.ToString(); ps["type"] = null; ds = bg.BuildDataset(this.unitItem, ps); InitLookUp(); }
UnitItem unitItem = null; //单元项目 protected void Page_Load(object sender, System.EventArgs e) { //检验当前系统参数及用户id是否有效 if (null == this.Session["sysparam"] || null==this.Session["userid"]) return; string strWinType=""; string strAppendName = ""; XmlDocument xmldoc=new XmlDocument(); WorkUnitType worktype=WorkUnitType.OtherItem; string strWorkUnit=""; //UnitItem unitItem = null; //单元项目 //读取用户参数 StreamReader streamreader=new StreamReader(this.Request.InputStream,Encoding.UTF8); string strxml = streamreader.ReadToEnd(); if (string.IsNullOrEmpty(strxml)) return; xmldoc.PreserveWhitespace = false; //取单元名称参数,否则无效 try { xmldoc.LoadXml(strxml); strWorkUnit = BuildParamList.getValue(xmldoc, "UnitName"); strWinType = BuildParamList.getValue(xmldoc, "WinType"); strAppendName = BuildParamList.getValue(xmldoc, "AppendItem"); if (string.IsNullOrEmpty(strWorkUnit)) return; unitItem = new UnitItem(DataAccRes.AppSettings("WorkConfig"), strWorkUnit); worktype = unitItem.UnitType; } catch (Exception ex) { ExceptionManager.Publish(ex); return; } //更新系统参数:自定义/临时系统参数每次都清空 XmlDocument xmldocSys = new XmlDocument(); xmldocSys.LoadXml(this.Session["sysparam"].ToString()); XmlNode xnLDSys = xmldocSys.SelectSingleNode("/*/PL[@t='S']/L[@t='D']"); XmlNodeList xnlist = xnLDSys.ParentNode.SelectNodes("L[@t='C' or @t='T']"); for (int i = xnlist.Count - 1; i > -1; i--) xnlist[i].ParentNode.RemoveChild(xnlist[i]); //新的系统参数 XmlNode xnSystem = xmldoc.SelectSingleNode("/*/PL[@t='S']"); if (null != xnSystem) { XmlNode xnL = xnSystem.SelectSingleNode("L[@t='D']"); XmlNode xntemp = xmldocSys.CreateElement("Temp"); xntemp = xmldocSys.DocumentElement.AppendChild(xntemp); foreach (XmlNode xnP in xnL.ChildNodes) { string key = xnP.Attributes["n"].Value; if (BuildParamList.IsSensitivity(key)) continue; XmlNode xnPT = xnSystem.SelectSingleNode(string.Format("L[@t='C' or @t='T']/P[@n='{0}']", key)); if (null != xnPT) continue; XmlNode xnSys = xnLDSys.SelectSingleNode("P[@n='" + key + "']"); if (null != xnSys) xnSys.ParentNode.RemoveChild(xnSys); xntemp.InnerXml = xnP.OuterXml; xnLDSys.AppendChild(xntemp.FirstChild); } xntemp.ParentNode.RemoveChild(xntemp); //把自定义/临时局部参数加入系统参数 xnlist = xnSystem.SelectNodes("L[@t='C' or @t='T']"); for (int i = xnlist.Count - 1; i > -1; i--) xnLDSys.ParentNode.AppendChild(xnlist[i]); } //通过session传递 if(xnSystem!=null) xmldoc.DocumentElement.RemoveChild(xnSystem); this.Session["sysparam"] = xmldocSys.OuterXml; this.Session.Remove(BuildParamList.SessionNameTrans); //xmldoc.InnerXml=xmldoc.InnerXml.Replace("
", ""); this.Session[BuildParamList.SessionNameTrans] = xmldoc.OuterXml; //返回用户需要跳转的URL;首先根据单元类型确定URL,再根据窗口类型确定URL, string ls_workurl=this.getUrlByWorkType(worktype); string ls_winurl = this.getUrlByWinType(unitItem, strWinType, strAppendName); string strURL=(string.Empty==ls_winurl)?ls_workurl:ls_winurl; this.Response.Write(leofun.Escape(strURL)); }
private void FrmEateryMonitor_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); //�����IJ��� DataTable tab = this.ds.Tables["������"]; this.bindMgr.BindTrv(this.trvEateryStall, tab, "����", "ID", "PID", "@ID={ID},@PID={PID}"); this.trvEateryStall.ExpandAll(); this.tabStateEatery = this.ds.Tables["����Ѳ��״̬"]; }
protected void Page_Load(object sender, System.EventArgs e) { // 在此处放置用户代码以初始化页面 //读取用户参数 string strCommand = "",strDataItem=""; StreamReader streamreader=new StreamReader(this.Request.InputStream,Encoding.UTF8); //if (streamreader.ReadToEnd() == "") return; //try //{ this.xmlDocParam.LoadXml(streamreader.ReadToEnd()); //} //catch //{ // return; //} this.paramlist=BuildParamList.BuildParams(this.xmlDocParam); try { if (null==this.paramlist["UnitName"]) return; if (null==this.paramlist["Command"]) return; string unitName=this.paramlist["UnitName"].ToString(); strCommand = this.paramlist["Command"].ToString(); if (null==this.paramlist["DataItem"]) strDataItem = ""; else strDataItem = this.paramlist["DataItem"].ToString(); unitItem = new UnitItem(DataAccRes.AppSettings("WorkConfig"), unitName); //unitItem = new UnitItem(paramlist, unitName); } catch ( Exception ex ) { ExceptionManager.Publish( ex ); return; } string workItemName=""; if (null != paramlist["WorkItem"]) workItemName=paramlist["WorkItem"].ToString(); for (int i = 0; i < unitItem.WorkItemList.Length; i++) if (workItemName == unitItem.WorkItemList[i].ItemName) { workitem = unitItem.WorkItemList[i]; break; } if (workitem==null) { string strResult = leofun.setvaltag("", "成功", "false"); this.Response.Write(leofun.Escape(strResult)); return; } query = new QueryDataRes(unitItem.DataSrcFile); if (unitItem.DataSrcFile == unitItem.DictColSrcFile) dictQuery = query; else dictQuery = new QueryDataRes(unitItem.DictColSrcFile); switch (strCommand.ToLower()) { case "query": this.QueryData(strDataItem); break; case "queryincserialwatch": //this.QueryIncSerialWatch(); break; case "cmd_cmd": this.ExcutCmd(strDataItem); break; case "cmd_cmdbits": //首先执行命令,然后根据数据库表记录的需要备份文件列表,把列表传送给目地服务器,目地服务器调用后台智能传输服务备份文件。 //WSBits 是WebService对象,调用远程方法 this.ExcutCmd(strDataItem); QueryDataRes querySys = QueryDataRes.CreateQuerySys(); NameObjectList paramBits = new NameObjectList(); string struri = this.Request.Url.AbsoluteUri; paramBits["地址"] = struri.Substring(0, struri.IndexOf(this.Request.Url.LocalPath)); DataTable tabTrans = querySys.getTable("后台文件归档", paramBits); WSBits bitsTrans = new WSBits(); if (bitsTrans.AddFileList(tabTrans)) querySys.ExecuteDelete("后台文件归档", paramBits); break; case "switchmodel": bool bSucc = false; string strResult = ""; if (null != paramlist["WorkItem"] && "SetModel" == paramlist["WorkItem"].ToString()) bSucc = DataAccRes.SwitchModelConfig(strDataItem); else bSucc = DataAccRes.SwitchDefaultModel(); if (bSucc) strResult = leofun.setvaltag("", "成功", "true"); else { strResult = leofun.setvaltag("", "成功", "false"); strResult = leofun.setvaltag(strResult, "提示", "执行命令失败,请查找原因再重试!"); } this.Response.Write(leofun.Escape(strResult)); break; default: break; } }