<%@ Page Language="C#" MasterPageFile="Main.Master" AutoEventWireup="true" CodeFile="DataViews.aspx.cs" Inherits="eFrameWork.Manage.DataViews" %>
<%@ Register Src="GroupMenu.ascx" TagPrefix="uc1" TagName="GroupMenu" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
<uc1:GroupMenu runat="server" ID="GroupMenu" />
<div class="nav">您当前位置：<a href="Default.aspx">首页</a> -> 动态数据<a id="btn_add" style="<%=(act == "" ? "" : "display:none;" )%>" class="button" href="<%=edt.getAddURL()%>"><span><i class="add">添加</i></span></a></div>
<div style="margin:6px;line-height:25px;font-size:13px;">
    <div class="tips" style="margin-bottom:6px;"><b>提示</b><br>在此进行定义,通过容器模块或aspx里eDataView控件进行调用。示例地址：Examples/eDataView.aspx</div>
<%if (eRegisterInfo.Base == 0 && eRegisterInfo.Loaded)
  { %>
    
<div class="tips" style="margin-bottom:6px;"><b>未授权提示</b><br><a href="http://frame.eketeam.com/getSerialNumber.html" style="color:#ff0000;" target="_blank">申请临时授权</a>,享更多功能。</div>
 <%} %>
</div>
<style>
.divd4q a{display:inline-block;margin-right:25px;}
</style>
<%
    if (act == "edit" || act == "add" || act == "view")
{
%>
<div style="margin:6px;">
 <asp:PlaceHolder ID="eFormControlGroup" runat="server">
	<form name="frmaddoredit" id="frmaddoredit" method="post" action="<%=edt.getSaveURL()%>">
	<input name="id" type="hidden" id="id" value="<%=id%>">
    <input name="act" type="hidden" id="act" value="save">  
	<input name="fromurl" type="hidden" id="fromurl" value="<%=edt.FromURL%>">  
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="eDataView">
      <tr>
        <td width="126" class="title">视图名称：</td>
        <td class="content"><span class="eform">
		 <ev:eFormControl ID="f1" Field="mc" width="300" FieldName="名称" HtmlEncode="false" runat="server" />
		 </span></td>
      </tr>
    <tr>
          <td class="title">数据源：</td>
          <td class="content"><span class="eform">
		  <ev:eFormControl ID="f14" FieldName="数据源" ControlType="select" Field="DataSourceID" FieldType="uniqueidentifier" BindObject="a_eke_sysDataSources" BindValue="DataSourceID" BindText="MC" BindCondition="delTag=0" Attributes="onchange=&quot;getTables();&quot;" Options="[{text:主库,value:NULL}]" DefaultValue="NULL" BindOrderBy="addTime desc" runat="server" />
		   </span></td>
        </tr>
	   <tr>
          <td class="title">说明：</td>
          <td class="content"><span class="eform">
		   <ev:eFormControl ID="f7" ControlType="textarea" Field="SM" FieldName="说明" width="600" height="50" HtmlEncode="false" runat="server" />
		   </span></td>
        </tr>
     <tr>
          <td class="title">模型：</td>
          <td class="content"><span class="eform">
		  <ev:eFormControl ID="f15" FieldName="模型" ControlType="select" Field="ModelID" FieldType="uniqueidentifier" BindObject="a_eke_sysModels" BindValue="ModelID" BindText="MC" BindCondition="delTag=0 and WebModel=1" DefaultValue="NULL" BindOrderBy="addTime desc" runat="server" />
		   </span></td>
        </tr>
	  <tr>
	     <td class="title">自定义SQL语句：</td>
	     <td class="content"><span class="eform">
		 <ev:eFormControl ID="f2" ControlType="textarea" Field="sql" FieldName="SQL语句" width="800" height="120" HtmlEncode="false" htmlTag="true" runat="server" />
		 </span></td>
	     </tr>
       <tr>
          <td class="title">前几行：</td>
          <td class="content"><span class="eform">
		  <ev:eFormControl ID="f16" Field="TopRows" FieldName="行" width="300" HtmlEncode="false" htmlTag="false" DefaultValue="0" Unit="使用自定义SQL语句时无需填写" runat="server" />
		  </span></td>
        </tr>
     <tr>
          <td class="title">固定条件：</td>
          <td class="content"><span class="eform">
		  <ev:eFormControl ID="f17" Field="CustomCondition" FieldName="固定条件" width="300" HtmlEncode="false" htmlTag="true" Unit="使用自定义SQL语句时无需填写" runat="server" />
		  </span></td>
        </tr>
        <tr>
          <td class="title">动态条件：</td>
          <td class="content"><span class="eform">
		  <ev:eFormControl ID="f10" Field="Condition" FieldName="条件" width="300" HtmlEncode="false" htmlTag="true" Unit="使用自定义SQL语句时无需填写" runat="server" />
		  </span></td>
        </tr>
        <tr>
          <td class="title">分组：</td>
          <td class="content"><span class="eform">
		  <ev:eFormControl ID="f11" Field="GroupBy" FieldName="分组" width="300" HtmlEncode="false" Unit="使用自定义SQL语句时无需填写" runat="server" />
		  </span></td>
        </tr>
        <tr>
          <td class="title">排序：</td>
          <td class="content"><span class="eform">
		  <ev:eFormControl ID="f12" Field="OrderBy" FieldName="排序" width="300" HtmlEncode="false" Unit="使用自定义SQL语句时无需填写" runat="server" />
		  </span></td>
        </tr>
        <tr>
          <td class="title">数据头：</td>
          <td class="content"><span class="eform">
		    <ev:eFormControl ID="f3" ControlType="textarea" Field="HeaderTemplate" FieldName="数据头" width="600" height="60" HtmlEncode="true" htmlTag="true" runat="server" /></span></td>
        </tr>
        <tr>
          <td class="title">数据项：</td>
          <td class="content"><span class="eform">
		   <ev:eFormControl ID="f4" ControlType="textarea" Field="ItemTemplate" FieldName="数据项" width="600" height="60" HtmlEncode="true" htmlTag="true" runat="server" /></span></td>
        </tr>
        <tr>
          <td class="title">间格：</td>
          <td class="content"><span class="eform">
		   <ev:eFormControl ID="f5" ControlType="textarea" Field="SplitTemplate" FieldName="间格" width="600" height="60" HtmlEncode="true" htmlTag="true" runat="server" /></span></td>
        </tr>
        <tr>
          <td class="title">数据尾：</td>
          <td class="content"><span class="eform">
		   <ev:eFormControl ID="f6" ControlType="textarea" Field="FooterTemplate" FieldName="数据尾" width="600" height="60" HtmlEncode="true" htmlTag="true" runat="server" /></span></td>
        </tr>		
		 <tr>
          <td class="title">分页方式： </td>
          <td class="content"><span class="eform"><ev:eFormControl ID="f13" Name="f13" ControlType="radio" Field="PageMode" FieldName="分页方式" Options="[{text:PC端,value:pc},{text:手机端,value:mobile}]" DefaultValue="pc" runat="server" /></span></td>
        </tr>
        <tr>
          <td class="title">分页大小： </td>
          <td class="content"><span class="eform">
		   <ev:eFormControl ID="f8" Field="Pagesize" FieldName="分页大小" width="160" DefaultValue="0" runat="server" />
		   </span></td>
        </tr>
        <tr>
          <td class="title">页码数量：</td>
          <td class="content"><span class="eform">
		   <ev:eFormControl ID="f9" Field="PageNum" FieldName="页码数量" width="160" DefaultValue="0" runat="server" />
		   </span></td>
        </tr>
        <tr>
       <td colspan="2" class="title"  style="text-align:left;padding-left:100px;padding-top:10px;padding-bottom:10px;">		
		 <a class="button" href="javascript:;" onclick="if(frmaddoredit.onsubmit()!=false){frmaddoredit.submit();}" style="display:none;"><span><i class="save">保存</i></span></a>
		<a class="button" href="javascript:;" onclick="ajaxSubmit(frmaddoredit);" style="<% =(act == "view" ? "display:none;" : "")%>"><span><i class="save">保存</i></span></a>
		<a class="button" href="javascript:;" style="margin-left:30px;" onclick="history.back();"><span><i class="back">返回</i></span></a>
		</td>
	   </tr>
	 
    </table>
	 </form>
	  </asp:PlaceHolder>
	 </div>
	<%}else{%>   
<div style="margin:6px;overflow-x:auto;overflow-y:hidden;">
<dl id="eSearchBox" class="ePanel">
<dt><h1 onclick="showPanel(this);" class="search"><a href="javascript:;" class="cur" onfocus="this.blur();"></a>搜索</h1></dt>
<dd style="display:none;">
<asp:PlaceHolder ID="eSearchControlGroup" runat="server">
<form id="frmsearch" name="frmsearch" method="post" onsubmit="return goSearch(this);" action="<%=elist.getSearchURL()%>">
<table width="100%" border="0" cellpadding="0" cellspacing="0" class="eDataView">
<colgroup>
<col width="120" />
<col />
</colgroup>
<tr>
<td class="title">名称：</td>
<td class="content"><span class="eform"><ev:eSearchControl ID="s1" Name="s1" ControlType="text" Field="MC" Operator="like" FieldName="名称" DataType="string" Width="300px" runat="server" /></span></td>
<td class="title">编号：</td>
<td class="content"><span class="eform"><ev:eSearchControl ID="s2" Name="s2" ControlType="text" Field="DataViewID" Operator="like" FieldName="编号" DataType="string" Width="300px" runat="server" /></span></td>
</tr>
<tr>
<td colspan="4" class="title" style="text-align:left;padding-left:125px;"><a class="button" href="javascript:;" onclick="if(frmsearch.onsubmit()!=false){frmsearch.submit();}"><span><i class="search">搜索</i></span></a></td>
</tr>
</table>
</form>
</asp:PlaceHolder>
</dd>
</dl>
<%}%>
<asp:Repeater id="Rep" runat="server">
<headertemplate>
<%#
"<table id=\"eDataTable\" class=\"eDataTable\" border=\"0\" cellpadding=\"0\" cellspacing=\"1\" width=\"100%\">\r\n" +
"<thead>\r\n" +
"<tr bgcolor=\"#f2f2f2\">\r\n" +
"<td width=\"260\">编号</td>\r\n" +
"<td>名称</td>\r\n" +
"<td>说明</td>\r\n" +
"<td width=\"80\">添加时间</td>\r\n" +
"<td width=\"120\">操作</td>\r\n" +
"</tr>\r\n" +
"</thead>\r\n"
%>
</headertemplate>
<itemtemplate>
<%#
"<tr" + ((Container.ItemIndex+1) % 2 == 0 ? " class=\"alternating\" eclass=\"alternating\"" : " eclass=\"\"") + ">\r\n" +
"<td height=\"32\"><a class=\"copy\" href=\"javascript:;\" data-clipboard-action=\"copy\" data-clipboard-text=\"" + Eval("DataViewID") + "\"></a>" + Eval("DataViewID") + "</td>\r\n" +
"<td>"+ Eval("MC").ToString()+"</td>\r\n" +
"<td>"+ Eval("SM").ToString()+"</td>\r\n" +
"<td>"+ Eval("addTime","{0:yyyy-MM-dd}")+"</td>\r\n" +
"<td>"+
"<a href=\""+ edt.getActionURL("copy",Eval("DataViewID").ToString())  +"\" onclick=\"javascript:return confirm('确认要复制吗？');\">复制</a>"+
"<a href=\"" + edt.getActionURL("edit",Eval("DataViewID").ToString())  + "\">修改</a>"+
"<a href=\""+ edt.getActionURL("del",Eval("DataViewID").ToString()) +"\" onclick=\"javascript:return confirm('确认要删除吗？');\">删除</a>"+
"</td>\r\n" +
"</tr>\r\n" 
%>
</itemtemplate>
<footertemplate><%#"</table>\r\n"%></footertemplate>
</asp:Repeater>
</div>
<div style="margin:6px;"><ev:ePageControl ID="ePageControl1" PageSize="20" PageNum="9" runat="server" /></div>
<asp:Literal id="litTip" runat="server" />
<iframe style="display:none;" width="500" height="500" id="fra" src="about:blank" name="fra"></iframe>
</asp:Content>