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