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;
}
}
