/// <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); }
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 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); }
/// <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 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); }
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("请输入开始时间","系统提示!"); 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); }
/// <summary> /// ���ݿ��Ż�ȡ��ǰ��Ϣ /// </summary> public DataTable 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["selectcard"]; tab.Clear(); query.FillDataSet(tab.TableName, pstrans, this.dsUnit); if (null == tab || tab.Rows.Count < 1) return tab; status = Convert.ToString(tab.Rows[0]["״̬"]); return tab; }
/// <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 btnSave_Click_1(object sender, EventArgs e) { if (string.IsNullOrEmpty(txtMoney.Text) || moneyList.Items.Count < 1) { XtraMessageBox.Show("�������Ϊ�ջ��߿���Ϊ��!", "ϵͳ��ʾ", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } #region ѭ��д������ for (int i = 0; i < moneyList.Items.Count; i++) { string[] sArray = moneyList.Items[i].ToString().Split('('); foreach (string j in sArray) { if (j.ToString().Contains(")")) { string[] ssArray = j.ToString().Split(')'); foreach (string h in ssArray) { if (!string.IsNullOrEmpty(h.ToString())) { string CardNo = h.ToString(); NameObjectList ps = new NameObjectList(); ParamManager.MergeParam(ps, this.paramwin); ps["����"] = CardNo; #region ��ѯ��ǰ��¼ QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile); DataTable tab = dsUnit.Tables["������Ϣ"]; if (null == tab) return; tab.Clear(); query.FillDataSet(tab.TableName, ps, this.dsUnit); #endregion //�����ֵ��¼���Ҹ��¿�Ƭ��� DataRow dr = tab.Rows[0]; dr["����"] = CardNo; dr["������ֵ"] = txtMoney.Text; dr["����Ա"] = BindManager.getUser().UserName; NameObjectList ps1 = ParamManager.createParam(dr); ParamManager.MergeParam(ps1, this.paramwin, false); this.Query.ExecuteNonQuery("������Ϣ", ps1, ps1, ps1); } } } } } #endregion moneyList.Items.Clear(); MessageBox.Show("�����ɹ�", "��ʾ", MessageBoxButtons.OK, MessageBoxIcon.None); }
/// <summary> /// ���ݲ������� ����ʱ��,�˵�,���ѻ�ddd /// </summary> /// <param name="db">GridControl</param> /// <param name="flag">����ʾ</param> /// <param name="ID">���</param> public void CheckByDin(DevExpress.XtraGrid.GridControl db, string flag, string ID) { try { DataTable tab = db.DataSource as DataTable; if (null == tab) return; if (string.IsNullOrEmpty(ID)) return; string filter = ""; switch (flag) { case "1": filter = "����ID='{0}' order by �������"; break; case "2": filter = "����ID='{0}'"; break; case "4": filter = "a.����ID='{0}'"; break; case "3": filter = "����ID='{0}'"; break; default: break; } filter = string.Format(filter, ID.Replace("'", "''")); QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile); tab.Clear(); query.FillDataSet(tab.TableName, this.paramwin, ParamManager.setMacroParam(MacroPmType.FW, filter), this.ds); } catch (Exception ex) { } }
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"); } string[] strsqls = (this.Request.QueryString["sql"] == null) ? null : this.Request.QueryString["sql"].Split(';'); string prnname = this.Request.QueryString["prn"]; string prntype = this.Request.QueryString["prntype"]; string prnpms = this.Request.QueryString["pms"]; string relation = this.Request.QueryString["relation"]; NameObjectList paramlist = new NameObjectList(); string[] parammacro = { "10", "0", "", "", "", "", "", "", "" }; if (prnpms != null) { paramlist = createParam(prnpms); parammacro = createMacro(prnpms); } string[] prndatasrcs = null; if (this.Request.QueryString["datasrc"] != null) prndatasrcs = this.Request.QueryString["datasrc"].Split(';'); if (prntype == null) prntype = "excel"; if (prndatasrcs == null) prndatasrcs = new String[] { "table" }; string strCn = DataAccRes.DefaultDataConnInfo.Value; DataSet ds = new DataSet(); //初始化连接字符串 if (strsqls != null && strsqls.Length > 0) { SqlConnection CN = new SqlConnection(); try { CN.ConnectionString = strCn; CN.Open(); for (int i = 0; i < strsqls.Length; i++) { if (strsqls[i] == "") continue; SqlDataAdapter adp = new SqlDataAdapter(strsqls[i], CN); adp.Fill(ds, prndatasrcs[i]); } CN.Close(); } catch (Exception ex) { if (CN.State == ConnectionState.Open) CN.Close(); this.Response.Write(""); return; } } else if (null != prndatasrcs && prndatasrcs.Length > 0) { QueryDataRes query = null; for (int i = 0; i < prndatasrcs.Length; i++) { if (string.IsNullOrEmpty(prndatasrcs[i])) continue; string[] src = prndatasrcs[i].Split(".".ToCharArray(), StringSplitOptions.RemoveEmptyEntries); if (src.Length < 2) continue; query = new QueryDataRes(src[0]); query.FillDataSet(src[1], paramlist, parammacro, ds); } } if (!ds.Tables.Contains("参数表")) { User user = new User(Convert.ToString(Session["userid"])); string[,] colmap = { { "公司名称", user.Company }, { "部门代码", user.DeptmentCode }, { "部门名称", user.DeptmentName }, { "上级部门", user.DeptSup }, { "单位名称", user.UnitName }, { "用户名称", user.UserName } }; for (int i = 0; i < colmap.GetLength(0); i++) { if (null == paramlist[colmap[i, 0]]) paramlist[colmap[i, 0]] = colmap[i, 1]; } DataTable tabm = new DataTable("参数表"); foreach (string key in paramlist.AllKeys) tabm.Columns.Add(key); DataRow drm = tabm.NewRow(); foreach (string key in paramlist.AllKeys) drm[key] = Convert.ToString(paramlist[key]); tabm.Rows.Add(drm); ds.Tables.Add(tabm); } //表关系:master.col~child.col; if (!string.IsNullOrEmpty(relation)) { string[] relts = relation.Split(";".ToCharArray(), StringSplitOptions.RemoveEmptyEntries); for (int i = 0; i < relts.Length; i++) { string[] rlt = relts[i].Split("~".ToCharArray(), StringSplitOptions.RemoveEmptyEntries); if (rlt.Length < 2) continue; string[] rltm = rlt[0].Split(".".ToCharArray(), StringSplitOptions.RemoveEmptyEntries); string[] rltd = rlt[1].Split(".".ToCharArray(), StringSplitOptions.RemoveEmptyEntries); if (!ds.Tables.Contains(rltm[0]) || !ds.Tables.Contains(rltd[0])) continue; if (!ds.Tables[rltm[0]].Columns.Contains(rltm[1]) || !ds.Tables[rltd[0]].Columns.Contains(rltd[1])) continue; DataTable tabm = ds.Tables[rltm[0]]; DataTable tabd = ds.Tables[rltd[0]]; tabm.ChildRelations.Add(tabm.Columns[rltm[1]], tabd.Columns[rltd[1]]); } } string SourceFile = prnname; string TemplatePath = this.Server.MapPath(DataAccRes.AppSettings("TpFilePath")); //存放源文件的文件夹路径。 string SrcFile = TemplatePath + SourceFile; //源文件名称 string DestFile = "print.XLS"; if (!string.IsNullOrEmpty(SourceFile) && !File.Exists(SrcFile)) { string strMSG = "打印模板 [" + SourceFile + "] 不存在,请联系系统管理员建立打印模板!"; this.Response.Write("<script language=\"javascript\">"); this.Response.Write("alert('" + strMSG + "')"); this.Response.Write("</script>"); return; } switch (prntype) { case "word": PrintWord printdoc = new PrintWord(); printdoc.TemplateFileName = SrcFile; printdoc.DataSource = ds; printdoc.DataBind(); printdoc.RemoveXmlLable(); csPrint.outXML2Word(printdoc.PrintXmlDoc, "print.doc"); break; case "excel": //DataTable tab = (ds.Tables.Count == 0) ? null : ds.Tables[0]; //XmlDocument xmlPrintDoc = csPrintData.makeprint(null, null, SourceFile, DestFile, tab, tab, 0, this.Session["userid"].ToString(), paramlist); if (string.IsNullOrEmpty(SourceFile) || !File.Exists(SrcFile)) { SrcFile = ""; ds.Tables.Remove("参数表"); } PrintExcel printexcel = new PrintExcel(); printexcel.DataSource = ds; printexcel.TemplateFileName = SrcFile; printexcel.DataBind(); csPrintData.outXML2Excel(printexcel.PrintXmlDoc, DestFile); break; case "html": break; } }
/// <summary> /// ��ʼ�������� /// </summary> /// <returns></returns> public DataTable initDev() { IPHostEntry IpEntry = Dns.GetHostEntry(Dns.GetHostName()); string myip = IpEntry.AddressList[0].ToString(); string filter = "(����='{0}' or IP��ַ='{1}') and ͨѶ���='������'"; filter = string.Format(filter, Dns.GetHostName(), myip); DataTable tab = this.dsUnit.Tables["������"]; tab.Clear(); QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile); query.FillDataSet("������", this.paramwin, ParamManager.setMacroParam(MacroPmType.FW, filter), this.dsUnit); return tab; }
private void sbtFilter_Click(object sender, EventArgs e) { //��ȡ��ǰ��Ԫ���� DataTable tab = dsUnit.Tables["�û�ѡ��"]; if (null == tab) return; //����Դ string filter = "���� like '%{0}%' or �û���� like '%{0}%' or ���� like '%{0}%' or �������� like '%{0}%' or ���� like '%{0}%' or �������� like '%{0}%'"; filter = string.Format(filter, this.tbFilter.Text.Replace("'", "''")); QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile); tab.Clear(); query.FillDataSet(tab.TableName, this.paramwin, ParamManager.setMacroParam(MacroPmType.FW, filter), this.dsUnit); flag = 1; }
/// <summary> /// 查询设备清单 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void DevListBtn_Click(object sender, EventArgs e) { dbGrid.Show(); DevListGrid.Hide(); QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile); this.dsUnit.Tables["compara"].Clear(); query.FillDataSet("compara", this.paramwin, this.dsUnit); }
private void BtnRefsh_Click_1(object sender, EventArgs e) { QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile); this.dsUnit.Tables["时段设置"].Clear(); query.FillDataSet("时段设置", this.paramwin, this.dsUnit); }
public DataTable initSet() { 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 tab; return tab; }
protected void Page_Load(object sender, System.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"); } SqlConnection CN = new SqlConnection(); string strsql = ""; string exectype = ""; //try //{ //初始化连接字符串 string strCn = DataAccRes.DefaultDataConnInfo.Value; CN.ConnectionString=strCn; CN.Open(); XmlDocument xmldoc = new XmlDocument(); //读取用户参数 StreamReader streamreader = new StreamReader(this.Request.InputStream, Encoding.UTF8); string strxml = streamreader.ReadToEnd(); if (string.IsNullOrEmpty(strxml)) return; xmldoc.LoadXml(strxml); if(xmldoc==null) return; XmlNodeList cmnodes = xmldoc.SelectNodes("//all/command"); XmlNodeList sqlnodes = xmldoc.SelectNodes("//all/sql"); XmlNodeList prnnodes = xmldoc.SelectNodes("//all/print"); XmlNodeList prnnames = xmldoc.SelectNodes("//all/printname"); if (cmnodes == null || sqlnodes == null) return; strsql = sqlnodes[0].InnerText; string prncmd = ""; string prnname = ""; if (prnnodes != null && prnnodes.Count>0) prncmd = prnnodes[0].InnerText; if (prnnames != null && prnnames.Count > 0) prnname = prnnames[0].InnerText; exectype = cmnodes[0].InnerText; string item = ""; if (exectype == "undefined") exectype = ""; if (exectype.IndexOf("item.") > -1) { item = exectype.Replace("item.", ""); if (Estar.DataAccess.SqlClientDataAccess.SqlQueryDAO.UnitHash.Contains(item)) { Response.Clear(); Response.ContentType = "text/xml; charset=gb2312"; Response.Expires = -1; XmlDataDocument outdoc = new XmlDataDocument(); outdoc.LoadXml(Estar.DataAccess.SqlClientDataAccess.SqlQueryDAO.UnitHash[item].ToString()); outdoc.Save(Response.OutputStream); //Response.End(); return; } } if (exectype == "cache") { Estar.DataAccess.SqlClientDataAccess.SqlQueryDAO.IsCache = true; Estar.Common.Tools.UnitItem.IsCache = true; string xmlstr = "<table>ok</table>"; Response.ContentType = "text/xml"; Response.Expires = -1; Response.Clear(); Response.Write("<?xml version='1.0' encoding='GB2312'?>"); Response.Write(xmlstr); //Response.End(); return; } if (exectype == "nocache") { Estar.DataAccess.SqlClientDataAccess.SqlQueryDAO.IsCache = false; Estar.Common.Tools.UnitItem.IsCache = false; string xmlstr = "<table>ok</table>"; Response.ContentType = "text/xml"; Response.Expires = -1; Response.Clear(); Response.Write("<?xml version='1.0' encoding='GB2312'?>"); Response.Write(xmlstr); //Response.End(); return; } if (exectype == "htmlfiles") { string[] files = Directory.GetFiles(System.Web.HttpContext.Current.Request.MapPath("html")); string strs = ""; for (int i = 0; i < files.Length; i++) { string s1 = files[i].ToLower(); FileInfo fileinfo = new FileInfo(s1); strs = strs + "," + fileinfo.Name; } strs = strs.Substring(1, strs.Length - 1); string xmlstr = "<table>"+strs+"</table>"; Response.ContentType = "text/xml"; Response.Expires = -1; Response.Clear(); Response.Write("<?xml version='1.0' encoding='GB2312'?>"); Response.Write(xmlstr); //Response.End(); return; } if (exectype == "prnfiles") { string[] files = Directory.GetFiles(System.Web.HttpContext.Current.Request.MapPath("DataSource\\ExcelTemplate")); string strs = ""; for (int i = 0; i < files.Length; i++) { string s1 = files[i].ToLower(); FileInfo fileinfo = new FileInfo(s1); strs = strs + "," + fileinfo.Name; } strs = strs.Substring(1, strs.Length - 1); string xmlstr = "<table>" + strs + "</table>"; Response.ContentType = "text/xml"; Response.Expires = -1; Response.Clear(); Response.Write("<?xml version='1.0' encoding='GB2312'?>"); Response.Write(xmlstr); //Response.End(); return; } if (exectype == "iconfiles") { string[] files = Directory.GetFiles(System.Web.HttpContext.Current.Request.MapPath("html\\Images")); string strs = ""; for (int i = 0; i < files.Length; i++) { string s1 = files[i].ToLower(); FileInfo fileinfo = new FileInfo(s1); strs = strs + "," + fileinfo.Name; } strs = strs.Substring(1, strs.Length - 1); string xmlstr = "<table>" + strs + "</table>"; Response.ContentType = "text/xml"; Response.Expires = -1; Response.Clear(); Response.Write("<?xml version='1.0' encoding='GB2312'?>"); Response.Write(xmlstr); //Response.End(); return; } if (exectype == "1") { strsql = strsql.Replace("\r\n", " "); SqlCommand command = new SqlCommand(strsql, CN); command.ExecuteNonQuery(); if (CN.State == ConnectionState.Open) CN.Close(); string xmlstr = "<table>ok</table>"; Response.ContentType = "text/xml"; Response.Expires = -1; Response.Clear(); Response.Write("<?xml version='1.0' encoding='GB2312'?>"); Response.Write(xmlstr); //Response.End(); return; } if (exectype == "xml") { strsql = sqlnodes[0].InnerXml; SqlCommand command = new SqlCommand(strsql, CN); command.ExecuteNonQuery(); if (CN.State == ConnectionState.Open) CN.Close(); string xmlstr = "<table>ok</table>"; Response.ContentType = "text/xml"; Response.Expires = -1; Response.Clear(); Response.Write("<?xml version='1.0' encoding='GB2312'?>"); Response.Write(xmlstr); //Response.End(); return; } DataSet ds = new DataSet(); SqlDataAdapter adp; if (strsql.ToLower().IndexOf("select ") < 0 && strsql.ToLower().IndexOf("exec ") < 0 && strsql.ToLower().IndexOf("execute ") < 0) { //按数据源方式 QueryDataRes query = new QueryDataRes(); NameObjectList paramlist = null; query.FillDataSet(strsql, paramlist, ds); if(ds.Tables!=null && ds.Tables.Count>0) ds.Tables[0].TableName = "table"; } else { adp = new SqlDataAdapter(strsql, CN); adp.Fill(ds,"table"); } if (prncmd == "prn") { string SourceFile = prnname; string TemplatePath = this.Server.MapPath(DataAccRes.AppSettings("TpFilePath")); //存放源文件的文件夹路径。 string SrcFile = TemplatePath + "\\" + SourceFile; //源文件名称 string DestFile = "print.XLS"; if (!File.Exists(SrcFile) == true) { if (!File.Exists(SrcFile) == true) { string strMSG = "打印模板 [" + SourceFile + "] 不存在,请联系系统管理员建立打印模板!"; this.Response.Write("<script language=\"javascript\">"); this.Response.Write("alert('" + strMSG + "')"); this.Response.Write("</script>"); return; } } DataTable tab = ds.Tables[0]; XmlDocument xmlPrintDoc = csPrintData.makeprint(null, null, SourceFile, DestFile, tab, tab, 0, this.Session["userid"].ToString(), null); //csPrintData.outXML2ExcelDown(xmlPrintDoc, SourceFile,null); //csPrintData.outXML2Excel(xmlPrintDoc, SourceFile); //System.Web.HttpContext.Current.Response.Write("<script language='javascript'>window.open('" + xmlPrintDoc + "')</script>"); return; } string colnames = ""; string datatypes = ""; string datalens = ""; for (int i = 0; i < ds.Tables[0].Columns.Count; i++) { colnames = colnames + "," + ds.Tables[0].Columns[i].ColumnName; datatypes = datatypes + "," + ds.Tables[0].Columns[i].DataType.ToString(); datalens = datalens + "," + ds.Tables[0].Columns[i].MaxLength.ToString(); } string tablename = ds.Tables[0].TableName; colnames = colnames.Substring(1, colnames.Length - 1); datatypes = datatypes.Substring(1, datatypes.Length - 1); datalens = datalens.Substring(1, datalens.Length - 1); DataTable tbl = ds.Tables.Add("xstructs"); DataColumn col0 = tbl.Columns.Add("name"); DataColumn col1 = tbl.Columns.Add("datatype"); DataColumn col2 = tbl.Columns.Add("len"); DataRow row = ds.Tables["xstructs"].NewRow(); row["name"] = colnames; row["datatype"] = datatypes.Replace("System.", ""); row["len"] = datalens; ds.Tables["xstructs"].Rows.Add(row); Response.Clear(); Response.ContentType = "text/xml; charset=gb2312"; Response.Expires = -1; XmlDataDocument outdoc1 = new XmlDataDocument(ds); outdoc1.Save(Response.OutputStream); if (item != "" && Estar.DataAccess.SqlClientDataAccess.SqlQueryDAO.IsCache == true) { Estar.DataAccess.SqlClientDataAccess.SqlQueryDAO.UnitHash.Add(item, outdoc1.InnerXml); } //Response.Write("<?xml version='1.0' encoding='GB2312'?>"); //Response.Write(ds.GetXml().ToString()); //Response.End(); if (CN.State == ConnectionState.Open) CN.Close(); //} //catch (Exception ex) //{ // if (CN.State == ConnectionState.Open) CN.Close(); // this.Response.Write(""); // NameValueCollection errInfo = new NameValueCollection(); // errInfo["数据源"] = strsql; // errInfo["操作类型"] = exectype; // ExceptionManager.Publish(ex, errInfo); //} //finally //{ }
private void QueryBtn_Click(object sender, EventArgs e) { //设置参数 NameObjectList ps = new NameObjectList(); ParamManager.MergeParam(ps, this.paramwin); string s = Convert.ToDateTime(this.dtpDate.Value).ToString("yyyy-MM-dd").ToString(); ps["dt"] = Convert.ToDateTime(this.dtpDate.Value).ToString("yyyy-MM-dd").ToString(); ps["type"] = this.cbRecordTp.SelectedIndex + 1; //查询数据 QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile); DataTable tab = this.RecordGrid.DataSource as DataTable; if (null == tab) return; tab.Clear(); query.FillDataSet(tab.TableName, ps, this.ds); //特殊业务处理 this.lbcount.Text = "总记录: " + Convert.ToString(ds.Tables[0].Rows.Count) + " 条"; }
/// <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); }
protected void Page_Load(object sender, System.EventArgs e) { // 在此处放置用户代码以初始化页面 XmlDocument xmldoc=new XmlDocument(); //读取用户参数 StreamReader streamreader=new StreamReader(this.Request.InputStream,Encoding.UTF8); xmldoc.LoadXml(streamreader.ReadToEnd()); NameObjectList[] paramlist=BuildParamList.BuildParamsList(xmldoc); try { string unitName=paramlist[0]["UnitName"].ToString(); unitItem = new UnitItem(this.MapPath(DataAccRes.AppSettings("WorkConfig")), unitName); } catch ( Exception ex ) { ExceptionManager.Publish( ex ); return; } QueryDataRes query=new QueryDataRes(unitItem.DataSrcFile); DataSet ds=new DataSet(unitItem.UnitName); ds.EnforceConstraints=false; string itemdata=paramlist[0]["DataItem"].ToString(); string[] dataItemList=itemdata.Split(",".ToCharArray()); for(int i=0;i<dataItemList.Length;i++) { if(""==dataItemList[i]) continue; for(int j=0;j<paramlist.Length;j++) { DataTable tab = query.getTable(dataItemList[i], paramlist[j]); ds.Merge(tab); } } //增加行光标列 for (int i = 0; i < ds.Tables.Count; i++) { DataTable tab = ds.Tables[i]; if (null != tab && !tab.Columns.Contains("RowNum")) tab.Columns.Add("RowNum", Type.GetType("System.Int32")); for (int j = 0; null != tab && j < tab.Rows.Count; j++) tab.Rows[j]["RowNum"] = j + 1; } //数字是0的,改为空值显示 for (int s = 0; s < ds.Tables.Count; s++) { DataTable tab = ds.Tables[s]; if (null == tab) continue; for (int i = 0; i < tab.Columns.Count; i++) { DataColumn col = tab.Columns[i]; if ("RowNum" == col.ColumnName) continue; if ("Decimal" != col.DataType.Name && "Double" != col.DataType.Name && "Int16" != col.DataType.Name && "Int32" != col.DataType.Name && "Int64" != col.DataType.Name && "Single" != col.DataType.Name && "UInt16" != col.DataType.Name && "UInt32" != col.DataType.Name && "UInt64" != col.DataType.Name) continue; for (int j = 0; j < tab.Rows.Count; j++) { if (null == tab.Rows[j][i] || DBNull.Value == tab.Rows[j][i]) continue; decimal num = Convert.ToDecimal(tab.Rows[j][i]); if (0 == num) tab.Rows[j][i] = DBNull.Value; } } } this.xmldocSchema.LoadXml(ds.GetXmlSchema()); XmlNamespaceManager xmlNsMgl=new XmlNamespaceManager(this.xmldocSchema.NameTable); XmlNode xmlRootEle=this.xmldocSchema.DocumentElement; for(int i=0;i<xmlRootEle.Attributes.Count;i++) { string strPrefix=xmlRootEle.Attributes[i].Prefix; string strLocalName=xmlRootEle.Attributes[i].LocalName; string strURI=xmlRootEle.Attributes[i].Value; if("xmlns"==strLocalName) xmlNsMgl.AddNamespace(string.Empty,strURI); if("xmlns"!=strPrefix) continue; xmlNsMgl.AddNamespace(strLocalName,strURI); } this._xmlNsMglSchema=xmlNsMgl; this.setSchema(ds); QueryDataRes dictQuery=new QueryDataRes(unitItem.DictColSrcFile); WorkItem workitem=null; for(int i=0;i<unitItem.WorkItemList.Length;i++) if(unitItem.WorkItemList[i].ItemName==paramlist[0]["WorkItem"].ToString()) { workitem=unitItem.WorkItemList[i]; break; } for(int i=0;i<workitem.DictCol.Length;i++) { DictColumn dictcol=workitem.DictCol[i]; if (dictcol.DataSrc.Trim().Length > 0) { bool isContinue = false; for (int k = 0; k < i; k++) if (dictcol.DataSrc == workitem.DictCol[k].DataSrc) { isContinue = true; break; } if (isContinue) continue; dictQuery.FillDataSet(dictcol.DataSrc, paramlist, this._dictds); } } XmlDataDocument xmldocData=new XmlDataDocument(ds); this.setFormatXmlLand(xmldocData,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 cboDept_TextChanged(object sender, EventArgs e) { string filter = "c.���� like '%{0}%'"; if (cboDept.Text == "ȫ��") filter = ""; else { filter = string.Format(filter, this.cboDept.Text.Replace("'", "''")); } //�õ�����Դ QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile); DataTable tab = dsUnit.Tables["��������"]; ; if (null == tab) return; tab.Clear(); query.FillDataSet(tab.TableName, this.paramwin, ParamManager.setMacroParam(MacroPmType.FW, filter), this.dsUnit); detpList.Items.Clear(); foreach (DataRow dr in tab.Rows) { this.detpList.Items.Add(dr["����"] + "(" + dr["����"] + ")"); } }
/// <summary> /// ��ǰ�иı�,�����û���� /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void gridView_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e) { if (flag == 1) return; else flag = 0; if (gridView.RowCount <= e.FocusedRowHandle || e.FocusedRowHandle < 0) return; //���ò��� NameObjectList ps = new NameObjectList(); ParamManager.MergeParam(ps, this.paramwin); ps["����"] = textEdit1.Text; QueryDataRes query = new QueryDataRes(this.unitItem.DataSrcFile); DataTable tab1 = this.dsUnit.Tables["����"]; if (null == tab1) return; tab1.Clear(); query.FillDataSet(tab1.TableName, ps, this.dsUnit); if (blstatus.Text == "") lbState.Text = "δ����"; else lbState.Text = this.blstatus.Text; }