protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
string eformsn = Request["eformsn"];
if (Wis.Toolkit.Validator.IsInt(eformsn))
{
Response.Write("<script language='javascript'>alert ('编号错误!');window.close();</script>");
return;
}
Wis.Toolkit.DataProvider dataProvider = new Wis.Toolkit.DataProvider(Website.Setting.MeetingConnectionString);
dataProvider.Open();
string commandText = string.Format("Select * from wd_75 where eformsn = {0}", eformsn);
System.Data.DataTable dt = dataProvider.ExecuteDataset(commandText).Tables[0];
if (dt == null)
{
Response.Write("<script language='javascript'>alert ('数据不存在!');window.close();</script>");
return;
}
if (dt.Rows[0]["txtTitle"] != null)
titleId.InnerHtml = dt.Rows[0]["txtTitle"].ToString();
if (dt.Rows[0]["txtTitle"] != null)
titleId.InnerHtml = dt.Rows[0]["txtTitle"].ToString();
}
}
/// <summary>
/// 读取列表数据
/// </summary>
/// <returns></returns>
public static System.Data.DataTable ArticleDt()
{
Wis.Toolkit.DataProvider dataProvider = new Wis.Toolkit.DataProvider(Setting.ConnectionString);
dataProvider.Open();
try
{
System.Data.DataTable dt = dataProvider.ExecuteDataset(labelEntity.CommandText).Tables[0];
dataProvider.Close();
return dt;
}
catch
{
if(!dataProvider.IsClosed) dataProvider.Close();
return null;
}
}
string newsstr()
{
string ParentId = Request.QueryString["ParentId"];
string liststr = string.Empty;
if (string.IsNullOrEmpty(ParentId))
ParentId = "0";
Wis.Toolkit.DataProvider dataProvider = new Wis.Toolkit.DataProvider(Website.Setting.ConnectionString);
dataProvider.Open();
//Guid parentGuid;
//if (!Wis.Toolkit.Validator.IsGuid(ParentId))
// ParentId = Guid.Empty.ToString();
string commandText;
if (ParentId=="0")
commandText = string.Format("select * from Category where ParentGuid = '{0}' ", Guid.Empty);
else
commandText= string.Format("select * from Category where ParentGuid in (select CategoryGuid from Category where CategoryId ={0}) ", ParentId);
System.Data.DataTable dt = dataProvider.ExecuteDataset(commandText).Tables[0];
foreach(System.Data.DataRow drow in dt.Rows)
{
commandText = string.Format("select count(CategoryId) from Category where ParentGuid = '{0}'", drow["CategoryGuid"].ToString());
int o = (int)dataProvider.ExecuteScalar(commandText);
if (o > 0 )
{
liststr += "<div><img src=\"../../sysImages/normal/b.gif\" alt=\"点击展开子栏目\" border=\"0\" class=\"LableItem\" onClick=\"javascript:SwitchImg(this,'" + drow["CategoryId"] + "');\" /> <span id=\"" + drow["CategoryGuid"] + "\" class=\"LableItem\" ondblclick=\"ReturnValue();\" onClick=\"SelectLable(this);sFiles('" + drow["CategoryGuid"] + "','" + drow["CategoryName"] + "');\">" + drow["CategoryName"] + "</span><div id=\"Parent" + drow["CategoryId"] + "\" class=\"SubItem\" HasSub=\"True\" style=\"height:100%;display:none;\"></div></div>";
}
else
{
liststr += "<div><img src=\"../../sysImages/normal/s.gif\" alt=\"没有子栏目\" border=\"0\" class=\"LableItem\" /> <span id=\"" + drow["CategoryGuid"] + "\" class=\"LableItem\" ondblclick=\"ReturnValue();\" onClick=\"SelectLable(this);sFiles('" + drow["CategoryGuid"] + "','" + drow["CategoryName"] + "');\">" + drow["CategoryName"] + "</span></div>";
}
}
dataProvider.Close();
if (liststr != string.Empty)
liststr = "Succee|||" + ParentId + "|||" + liststr;
else
liststr = "Fail|||" + ParentId + "|||";
return liststr;
}
public void MeetingInfo(HttpContext context)
{
context.Response.ContentType = "text/xml";
context.Response.ContentEncoding = System.Text.Encoding.UTF8;
context.Response.Write("<?xml version=\"1.0\" encoding=\"utf-8\"?>");
string eformsn = context.Request["eformsn"];
if(!Wis.Toolkit.Validator.IsInt(eformsn))
{
context.Response.Write(0);
return;
}
Wis.Toolkit.DataProvider dataProvider = new Wis.Toolkit.DataProvider(Website.Setting.MeetingConnectionString);
dataProvider.Open();
string commandText = string.Format("update wd_75 set Hits = Hits + 1 where eformsn ={0}", eformsn);
dataProvider.ExecuteNonQuery(commandText);
commandText = string.Format("select * from wd_75 where eformsn ={0}", eformsn);
System.Data.DataTable dt = dataProvider.ExecuteDataset(commandText).Tables[0];
dataProvider.Close();
if (dt.Rows.Count < 1)
{
context.Response.Write(0);
return;
}
using (StringWriter sw = new StringWriter())
{
XmlTextWriter xtw = new XmlTextWriter(sw);
xtw.Formatting = Formatting.Indented;
// xtw.WriteStartDocument();
xtw.WriteStartElement("L"); // League -> L
xtw.WriteStartElement("A");
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append(dt.Rows[0]["eformsn"].ToString());
sb.Append(";"); //
sb.Append(dt.Rows[0]["txtZhuChi"].ToString().Replace(";", ","));//主持人
sb.Append(";"); //
sb.Append(dt.Rows[0]["txtEndDate"].ToString() + " " + dt.Rows[0]["txtEndTime"].ToString());//会议结束日期
sb.Append(";"); //
sb.Append(dt.Rows[0]["txtRenShu"].ToString().Replace(";", ","));//参会人数
sb.Append(";"); //
sb.Append(dt.Rows[0]["txtDate"].ToString() + " " + dt.Rows[0]["txtTime"].ToString());//会议开始日期
sb.Append(";"); //
sb.Append(dt.Rows[0]["txtAddress"].ToString().Replace(";", ","));//会议地点
sb.Append(";"); //
sb.Append(dt.Rows[0]["txtTitle"].ToString().Replace(";", ","));//会议名称
sb.Append(";"); //
sb.Append(dt.Rows[0]["txtshenqingren"].ToString().Replace(";", ","));//申请人
sb.Append(";"); //
sb.Append(dt.Rows[0]["deptName"].ToString().Replace(";", ","));//预定部门
sb.Append(";"); //
sb.Append(dt.Rows[0]["txtYuHuiRY"].ToString().Replace(";", ","));//与会人员
sb.Append(";"); //
sb.Append(dt.Rows[0]["RichTextBox1"].ToString().Replace(";", ","));//内容
sb.Append(";"); //
sb.Append(dt.Rows[0]["Hits"].ToString());//浏览次数
sb.Append(";"); //
sb.Append(dt.Rows[0]["Comments"].ToString());//评论条数
sb.Append(";"); //
xtw.WriteAttributeString("V", sb.ToString());
xtw.WriteEndElement();// ActiveMatch -> A
//commandText = string.Format("select * from webflowAttach where eformsn ={0} and eformID =75", eformsn);
//System.Data.DataTable dt1 = dataProvider.ExecuteDataset(commandText).Tables[0];
//foreach(System.Data.DataRow drow in dt1.Rows)
//{
// xtw.WriteStartElement("F");
// System.Text.StringBuilder sb1 = new System.Text.StringBuilder();
// xtw.WriteAttributeString("V", sb1.ToString());
// xtw.WriteEndElement();// ActiveMatch -> A
//}
xtw.WriteEndElement();// Live -> L
//xtw.WriteEndDocument();
context.Response.Write(sw.ToString());
}
}
public static bool linkhtml()
{
Wis.Toolkit.DataProvider dataProvider = new Wis.Toolkit.DataProvider(Setting.ConnectionString);
dataProvider.Open();
string commandtext = string.Format("select * from Category where CategoryId = 37");
System.Data.DataTable dt = dataProvider.ExecuteDataset(commandtext).Tables[0];
tempcontent = ReadHtml(dt.Rows[0]["TemplatePath"].ToString());
ReplacelistLabels();
WriteHtmls(tempcontent, System.Web.HttpContext.Current.Request.PhysicalApplicationPath + dt.Rows[0]["ReleasePath"].ToString());
return true;
}
/// <summary>
/// 生成关联页面
/// </summary>
/// <param name="categoryId"></param>
/// <returns></returns>
public static bool GetTemplateHtml(int categoryId)
{
Wis.Toolkit.DataProvider dataProvider = new Wis.Toolkit.DataProvider(Setting.ConnectionString);
dataProvider.Open();
string CommandText = string.Format("select * from Template where CategoryId ={0}", categoryId);
try
{
System.Data.DataTable dt = dataProvider.ExecuteDataset(CommandText).Tables[0];
dataProvider.Close();
for (int i = 0; i < dt.Rows.Count; i++)
{
tempcontent = ReadHtml(dt.Rows[i]["TemplatePath"].ToString());
ReplacelistLabels();
WriteHtmls(tempcontent, System.Web.HttpContext.Current.Request.PhysicalApplicationPath + dt.Rows[i]["ReleasePath"].ToString());
}
return true;
}
catch
{
if (!dataProvider.IsClosed) dataProvider.Close();
return false;
}
}