internal void Export(XmlWriter writer)
{
writer.WriteStartElement("Worksheet");
writer.WriteAttributeString("ss", "Name", null, Name);
ParentBook.ExportNamedRanges(writer, this);
writer.WriteStartElement("Table");
writer.WriteAttributeString("ss", "FullColumns", null, "1");
writer.WriteAttributeString("ss", "FullRows", null, "1");
if (!StyleID.IsNullOrEmpty() && StyleID != "Default")
{
writer.WriteAttributeString("ss", "StyleID", null, StyleID);
}
foreach (Column col in _Columns)
{
col.Export(writer);
}
foreach (Row row in _Rows)
{
row.Export(writer);
}
writer.WriteEndElement();
ExportOptions(writer);
if (AutoFilter)
{
string range = GetParentBook().GetAutoFilterRange(this);
writer.WriteStartElement("", "AutoFilter", "urn:schemas-microsoft-com:office:excel");
writer.WriteAttributeString("", "Range", null, range);
writer.WriteEndElement();
}
writer.WriteEndElement();
}
internal void Export(XmlWriter writer)
{
writer.WriteStartElement("Row");
if (!StyleID.IsNullOrEmpty() && ParentSheet.StyleID != StyleID && StyleID != "Default")
{
writer.WriteAttributeString("ss", "StyleID", null, StyleID);
}
if (Height != 0)
{
writer.WriteAttributeString("ss", "AutoFitHeight", null, "0");
writer.WriteAttributeString("ss", "Height", null, Height.ToString(CultureInfo.InvariantCulture));
}
if (Hidden)
{
writer.WriteAttributeString("ss", "Hidden", null, "1");
}
bool printIndex = false;
foreach (Cell cell in _Cells)
{
if (cell.IsEmpty() && !cell.MergeStart)
{
printIndex = true;
}
else
{
cell.Export(writer, printIndex);
printIndex = false;
}
}
writer.WriteEndElement();
}
internal void Export(XmlWriter writer, bool printIndex)
{
if (IsEmpty())
{
return;
}
if (!MergeStart && ParentRow.ParentSheet.IsCellMerged(this))
{
return;
}
writer.WriteStartElement("Cell");
if (!StyleID.IsNullOrEmpty() && ParentRow.StyleID != StyleID && StyleID != "Default")
{
writer.WriteAttributeString("ss", "StyleID", null, StyleID);
}
if (printIndex)
{
writer.WriteAttributeString("ss", "Index", null, (CellIndex + 1).ToString(CultureInfo.InvariantCulture));
}
if (!HRef.IsNullOrEmpty())
{
writer.WriteAttributeString("ss", "HRef", null, HRef.XmlEncode());
}
if (MergeStart)
{
Worksheet ws = ParentRow.ParentSheet;
Range range = ws._MergedCells.Find(rangeToFind => rangeToFind.CellFrom == this);
if (range != null)
{
int rangeCols = range.ColumnCount - 1;
int rangeRows = range.RowCount - 1;
if (rangeCols > 0)
{
writer.WriteAttributeString("ss", "MergeAcross", null, rangeCols.ToString(CultureInfo.InvariantCulture));
}
if (rangeRows > 0)
{
writer.WriteAttributeString("ss", "MergeDown", null, rangeRows.ToString(CultureInfo.InvariantCulture));
}
}
}
ExportContent(writer);
ExportComment(writer);
List <string> namedRanges = GetParentBook().CellInNamedRanges(this);
foreach (string range in namedRanges)
{
writer.WriteStartElement("NamedCell");
writer.WriteAttributeString("ss", "Name", null, range);
writer.WriteEndElement();
}
writer.WriteEndElement();
}
protected void Page_Load(object sender, EventArgs e)
{
sid = DataConverter.CLng(base.Request.QueryString["sid"]);
id = DataConverter.CLng(base.Request.QueryString["id"]);
styleids = DataConverter.CLng(base.Request.QueryString["styleids"]);
PageparentID = DataConverter.CLng(base.Request.QueryString["ParentID"]);
if (!IsPostBack)
{
Call.HideBread(Master);
BindDP();
#region 判断添加、修改
//else if (styleids > 0)
//{
// loadmenulist(UserID);
// int groupid = DataConverter.CLng(tll.Getbyid(styleids).UserGroup);
// string nodename = sll.Getpagestrylebyid(groupid).PageNodeName.ToString();
// Label1_Hid.Value = "<a href=\"PageTemplate.aspx?styleid=" + groupid + "\">[黄页栏目管理]</a><a href=\"PageTemplate.aspx?styleid=" + groupid + "\">样式栏目设置</a>" + nodename;
// Label2_Hid.Value = "修改黄页栏目";
// Label3.Text = "修改黄页栏目";
// Button1.Text = "修改栏目";
// returnurl = "PageTemplate.aspx?styleid=" + groupid + "";
// Tempinfo = tll.Getbyid(styleids);
// PageStyle_DP.SelectedValue = Tempinfo.UserGroup;
// StyleID_Hid.Value = Tempinfo.UserGroup;
//}
if (sid > 0)//修改
{
string nodename = ull.SeachByID(UserID).UserName;
loadmenulist(UserID);
int PageStyleid = 0;
DataTable regdt = mll.SelectTableName("ZL_Pagereg", "TableName like 'ZL_Reg_%' and UserName='******'");
if (regdt != null && regdt.Rows.Count > 0)
{
string PageTableName = regdt.Rows[0]["TableName"].ToString();
DataTable pagetable = mll.SelectTableName(PageTableName, "UserName = '******'");
PageStyleid = DataConverter.CLng(pagetable.Rows[0]["Styleid"]);
UserGroup.Value = PageStyleid.ToString();
Username.Value = nodename;
}
Label1_Hid.Value = "黄页管理 <a href=\"PageManage.aspx\">[黄页用户列表]</a> <a href=\"PageTemplate.aspx?id=" + UserID + "\">" + nodename + "</a> ";
Label2_Hid.Value = "修改自定义用户黄页栏目";
Label3.Text = "修改栏目";
Button1.Text = "修改栏目";
returnurl = "PageTemplate.aspx?id=" + UserID + "";
Tempinfo = tll.Getbyid(sid);
PageStyle_DP.SelectedValue = Tempinfo.UserGroup;
}
else if (StyleID > 0)//从样式列表处跳转
{
M_PageStyle styleinfo = sll.Getpagestrylebyid(StyleID);
string nodename = styleinfo.PageNodeName;
returnurl = "PageTemplate.aspx?styleid=" + StyleID + "";
UserGroup.Value = StyleID.ToString();
loadmenulist(UserID);
if (PageparentID > 0)
{
string snodename = tll.Getbyid(PageparentID).TemplateName;
Label1_Hid.Value = "<a href=\"PageTemplate.aspx?styleid=" + StyleID + "\">[黄页栏目管理]</a><a href=\"PageTemplate.aspx?styleid=" + StyleID + "\">样式栏目设置</a> " + nodename;
Label2_Hid.Value = "添加黄页子栏目";
Label3.Text = "添加黄页子栏目 [" + snodename + "]";
}
else
{
Label1_Hid.Value = "<a href=\"PageTemplate.aspx?styleid=" + StyleID + "\">[黄页栏目管理]</a> <a href=\"PageTemplate.aspx?styleid=" + StyleID + "\">样式栏目设置</a>" + nodename;
Label2_Hid.Value = "添加黄页栏目";
Label3.Text = "添加黄页样式栏目";
}
PageStyle_DP.SelectedValue = StyleID.ToString();
}
else if (id > 0)
{
M_PageReg m_PageReg = regBll.SelReturnModel(DataConverter.CLng(Request["id"]));
string nodename = m_PageReg.UserName;
DataTable cmdtable = mll.SelectTableName("ZL_Pagereg", "TableName like 'ZL_Reg_%' and UserName='******'");
string PageTableName = cmdtable.Rows[0]["TableName"].ToString();
DataTable pagetable = mll.SelectTableName(PageTableName, "UserName = '******'");
int PageStyleid = DataConverter.CLng(pagetable.Rows[0]["Styleid"]);
UserGroup.Value = PageStyleid.ToString();
Username.Value = nodename;
string tempoptionlist = "<select name=\"ParentID\" id=\"ParentID\">";
tempoptionlist = tempoptionlist + "<option value=\"0\">请选择栏目</option>";
loadmenulist(UserID);
Label1_Hid.Value = "黄页管理 <a href=\"PageTemplate.aspx?id=" + id + "\">[黄页用户列表]</a> <a href=\"PageTemplate.aspx?id=" + id + "\">" + nodename + "</a> ";
Label2_Hid.Value = "添加自定义用户黄页栏目";
Label3.Text = "添加自定义用户黄页栏目";
returnurl = "PageTemplate.aspx?id=" + id + "&userid=" + UserID;
Userids.Value = ull.GetUserByName(nodename).UserID.ToString();
}
#endregion
#region 初始化界面默认值
if (sid > 0 || styleids > 0)
{
if (Tempinfo != null)//修改栏目
{
if (!IsPostBack)
{
templateName.Text = Tempinfo.TemplateName; //栏目名称
templateUrl_hid.Value = Tempinfo.TemplateUrl.ToString(); //栏目模板地址
templateType.Text = Tempinfo.TemplateType.ToString(); //栏目类型
OpenType.Text = Tempinfo.OpenType.ToString(); //打开方式
isTrue.Text = Tempinfo.IsTrue.ToString(); //启用状态
identifiers.Text = Tempinfo.Identifiers.ToString(); //标识符
NodeFileEx.Text = Tempinfo.NodeFileEx.ToString(); //栏目扩展名
ContentFileEx.Text = Tempinfo.ContentFileEx; //内容页扩展名
addtime.Text = Tempinfo.Addtime.ToString(); //添加时间
Nodeimgurl.Text = Tempinfo.Nodeimgurl.ToString(); //栏目图片地址
Nodeimgtext.Text = Tempinfo.Nodeimgtext.ToString(); //栏目提示
Pagecontent.Text = Tempinfo.Pagecontent.ToString(); //说明 用于在单页页详细介绍单页信息，支持HTML
PageMetakeyword.Text = Tempinfo.PageMetakeyword.ToString(); //META关键词
PageMetakeyinfo.Text = Tempinfo.PageMetakeyinfo.ToString(); //META网页描述
linkurl.Text = Tempinfo.Linkurl.ToString(); //外部链接地址
linkimg.Text = Tempinfo.Linkimg.ToString(); //外部链接图片地址
linktxt.Text = Tempinfo.Linktxt.ToString(); //外部链接提示
OrderID.Text = Tempinfo.OrderID.ToString(); //排序
TemplateID.Value = Tempinfo.TemplateID.ToString(); //栏目ID
UserGroup.Value = Tempinfo.UserGroup; //所属样式ID
PageStyle_DP.SelectedValue = Tempinfo.UserGroup;
Userids.Value = Tempinfo.UserID.ToString(); //所属用户ID
lblmodelstr.Value = Tempinfo.Modelinfo.ToString();
Username.Value = Tempinfo.Username.ToString();
}
}
}
else //公用添加栏目
{
TemplateID.Value = "0";
addtime.Text = DateTime.Now.ToString();
OpenType.Text = "_blank";
NodeFileEx.Text = "html";
ContentFileEx.Text = "html";
OrderID.Text = "0";
}
#endregion
DataTable dt = mll.SelectTableName("ZL_Model", "TableName like 'ZL_Page_%'");
Repeater1.DataSource = dt;
Repeater1.DataBind();
#region 判断栏目类型
switch (templateType.Text)
{
case "0": //默认为栏目
typenode.Visible = true;
tempurl.Visible = true;
typetxt.Visible = false;
urltype.Visible = false;
nodetype.Visible = true;
SelectModel.Visible = true;
templateType.SelectedValue = "2";
break;
case "1": //单页
typenode.Visible = false;
tempurl.Visible = true;
typetxt.Visible = true;
urltype.Visible = false;
nodetype.Visible = true;
SelectModel.Visible = false;
templateType.SelectedValue = "1";
break;
case "2": //栏目
tempurl.Visible = true;
typenode.Visible = true;
typetxt.Visible = true;
urltype.Visible = false;
nodetype.Visible = true;
SelectModel.Visible = true;
templateType.SelectedValue = "2";
break;
case "3": //url连接
typenode.Visible = false;
tempurl.Visible = false;
typetxt.Visible = false;
urltype.Visible = true;
nodetype.Visible = false;
SelectModel.Visible = false;
templateType.SelectedValue = "3";
break;
case "4": //功能型栏目
typenode.Visible = false;
tempurl.Visible = true;
typetxt.Visible = false;
urltype.Visible = false;
nodetype.Visible = false;
SelectModel.Visible = true;
templateType.SelectedValue = "4";
break;
default: //默认为栏目
tempurl.Visible = true;
typenode.Visible = true;
typetxt.Visible = true;
urltype.Visible = false;
nodetype.Visible = true;
SelectModel.Visible = true;
templateType.SelectedValue = "2";
break;
}
#endregion
}
}
internal void Export(XmlWriter writer, bool printIndex)
{
if (IsEmpty())
{
return;
}
// If no merge starts from this cell, and this cells is in
// a merged range, no output should be done...
if (!MergeStart && ParentRow.ParentSheet.IsCellMerged(this))
{
return;
}
// Start Cell
writer.WriteStartElement("Cell");
// Has style? If yes, we only need to write the style if default line
// style is not same as this one...
if (!StyleID.IsNullOrEmpty() && ParentRow.StyleID != StyleID && StyleID != "Default")
{
writer.WriteAttributeString("ss", "StyleID", null, StyleID);
}
if (printIndex)
{
writer.WriteAttributeString("ss", "Index", null,
(CellIndex + 1).ToString(CultureInfo.InvariantCulture));
}
if (!HRef.IsNullOrEmpty())
{
writer.WriteAttributeString("ss", "HRef", null, HRef.XmlEncode());
}
if (MergeStart)
{
Worksheet ws = ParentRow.ParentSheet;
Range range = ws._MergedCells.Find(rangeToFind => rangeToFind.CellFrom == this);
if (range != null)
{
int rangeCols = range.ColumnCount - 1;
int rangeRows = range.RowCount - 1;
if (rangeCols > 0)
{
writer.WriteAttributeString("ss", "MergeAcross", null,
rangeCols.ToString(CultureInfo.InvariantCulture));
}
if (rangeRows > 0)
{
writer.WriteAttributeString("ss", "MergeDown", null,
rangeRows.ToString(CultureInfo.InvariantCulture));
}
}
}
// Export content
ExportContent(writer);
// Export comment
ExportComment(writer);
// Write named ranges
List <string> namedRanges = GetParentBook().CellInNamedRanges(this);
foreach (string range in namedRanges)
{
writer.WriteStartElement("NamedCell");
writer.WriteAttributeString("ss", "Name", null, range);
writer.WriteEndElement();
}
// End Cell
writer.WriteEndElement();
}
