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