protected void Page_Load(object sender, EventArgs e)
{
user = new eUser("Mobile");
user.Check();
StringBuilder sb = new StringBuilder();
sb.Append("欢迎登录" + eConfig.getString("systemName") + "!<br>");
sb.Append("用户名：" + user["Name"] + "<br>");
sb.Append("用户ID：" + user.ID + "<br>");
sb.Append("SiteID：" + user["SiteID"] + "<br>");
DataTable tb = eOleDB.getDataTable("select LoginCount,LastLoginTime from a_eke_sysUsers where UserID='" + user["ID"].ToString() + "'");
if (tb.Rows.Count > 0)
{
string logincount = tb.Rows[0]["LoginCount"].ToString();
string lastlt = string.Format("{0:yyyy-MM-dd HH:mm:ss}", tb.Rows[0]["LastLoginTime"]);
sb.Append("登录次数：" + logincount + "<br>");
sb.Append("上次登录时间：" + lastlt + "<br>");
}
sb.Append("默认密码非常不安全,点此<a href=\"ModifyPass.aspx\">修改密码</a>");
litBody.Text = sb.ToString();
}
protected void Page_Load(object sender, EventArgs e)
{
user = new eUser("Manage");
user.Check();
Action = new eAction();
edt = new eForm("a_eke_sysModels", user);
//edt.AutoRedirect = false;
edt.AddControl(f1); //名称
f2.Field = "Code";
edt.AddControl(f2); //编码
edt.AddControl(f3); //简介
edt.AddControl(f4); //文件
edt.AddControl(f5); //自动
edt.AddControl(f6); //类名
f7.Field = "ParentID";
f7.FieldType = "uniqueidentifier";
edt.AddControl(f7); //上级
edt.AddControl(f8); //关系
edt.AddControl(f9); //类型
if (Action.Value == "del")
{
string id = eParameters.QueryString("id");
eOleDB.Execute("delete from a_eke_sysModels where ModelID='" + id + "'");
eOleDB.Execute("delete from a_eke_sysModelItems where ModelID='" + id + "'");
eOleDB.Execute("delete from a_eke_sysModelConditions where ModelID='" + id + "'");
eOleDB.Execute("delete from a_eke_sysModelConditionItems where ModelID='" + id + "'");
eOleDB.Execute("delete from a_eke_sysConditions where ModelID='" + id + "'");
eOleDB.Execute("delete from a_eke_sysPowers where ModelID='" + id + "'");
eOleDB.Execute("delete from a_eke_sysActions where ModelID='" + id + "'");
eOleDB.Execute("delete from a_eke_sysModelTabs where ModelID='" + id + "'");
eOleDB.Execute("delete from a_eke_sysModelPanels where ModelID='" + id + "'");
eOleDB.Execute("delete from a_eke_sysUserCustoms where ModelID='" + id + "'");
eOleDB.Execute("delete from a_eke_sysUserColumns where ModelID='" + id + "'");
eOleDB.Execute("delete from a_eke_sysCheckUps where ModelID='" + id + "'");
if (Request.ServerVariables["HTTP_REFERER"] == null)
{
Response.Redirect("ClearModel.aspx", true);
}
else
{
Response.Redirect(Request.ServerVariables["HTTP_REFERER"].ToString(), true);
}
Response.End();
//Response.Redirect(Request.UrlReferrer.PathAndQuery, true);
}
edt.onChange += new eFormTableEventHandler(edt_onChange);
edt.Handle();
Action.Actioning += new eActionHandler(Action_Actioning);
Action.Listen();
}
protected void Page_Load(object sender, EventArgs e)
{
user = new eUser(UserArea);
user.Check();
model = new eModel(ModelID, user);
Action = new eAction();
Action.Actioning += new eActionHandler(Action_Actioning);
Action.Listen();
}
protected void Page_Load(object sender, EventArgs e)
{
user = new eUser("Manage");
user.Check();
if (act == "settabledescription")
{
eOleDB.Execute("EXEC sys.sp_addextendedproperty N'MS_Description',N'" + value + "','user','dbo','table','" + tbname + "',NULL,NULL");
eOleDB.Execute("EXEC sys.sp_updateextendedproperty N'MS_Description',N'" + value + "','user','dbo','table','" + tbname + "',NULL,NULL");
eBase.End();
}
if (act == "setcolumndescription")
{
string column = Request.QueryString["column"].ToString();
eOleDB.Execute("EXEC sp_addextendedproperty N'MS_Description',N'" + value + "','user','dbo','table','" + tbname + "','column','" + column + "'");
eOleDB.Execute("EXEC sp_updateextendedproperty N'MS_Description',N'" + value + "','user','dbo','table','" + tbname + "','column','" + column + "'");
eBase.End();
}
DataTable tb = eOleDB.getTables();
StringBuilder sb = new StringBuilder();
int i = 1;
foreach (DataRow dr in tb.Rows)
{
sql = "select top 1 value from sys.extended_properties where major_id=(SELECT id from sysobjects where name='" + dr["name"].ToString() + "' and xtype = 'U') and minor_id=0";
sql = "select top 1 value from sys.extended_properties where major_id=" + dr["id"].ToString() + " and minor_id=0";
string sm = eOleDB.getValue(sql);
sb.Append("<div>\r\n");
sb.Append("<span style=\"display:inline-block;width:30px;\">" + i.ToString().PadLeft(3, '0') + "</span>");
sb.Append("<span onclick=\"show(" + i.ToString() + ",this);\" style=\"display:inline-block;width:300px;" + (sm.Length == 0 ? "color:#ff0000;" : "") + "\" class=\"close\">" + dr["name"].ToString());
sb.Append("</span>");
sb.Append("<input type=\"text\" class=\"edit\" value=\"" + sm + "\" onBlur=\"setTableDescription(this,'" + dr["name"].ToString() + "');\" />");
sb.Append(" <a href=\"javascript:;\" style=\"display:inline-block;margin-left:8px;color:#222;\" onclick=\"createModel('" + dr["name"].ToString() + "');\">生成实体</a>");
sb.Append(" <a href=\"javascript:;\" style=\"display:inline-block;margin-left:8px;color:#222;\" onclick=\"createTable('" + dr["name"].ToString() + "');\">生成脚本</a>");
sb.Append("</div>\r\n");
DataTable dt = eOleDB.getColumns(dr["name"].ToString());
sb.Append("<div id=\"div_" + i.ToString() + "\" style=\"display:none;margin-left:80px;\">\r\n");
foreach (DataRow _dr in dt.Rows)
{
sb.Append("<span style=\"display:inline-block;width:270px;_width:250px;" + (_dr["MC"].ToString().Length == 0 ? "color:#ff0000;" : "") + "\">" + _dr["code"].ToString() + "</span>");
sb.Append("<input type=\"text\" class=\"edit\" value=\"" + _dr["MC"].ToString() + "\" onBlur=\"setColumnDescription(this,'" + dr["name"].ToString() + "','" + _dr["code"].ToString() + "');\" /><br>\r\n");
}
sb.Append("</div>\r\n");
i++;
//eBase.PrintDataTable(dt);
}
//eBase.PrintDataTable(tb);
LitBody.Text = sb.ToString();
}
protected void Page_Load(object sender, EventArgs e)
{
user = new eUser("Mobile");
user.Check();
model = new eModel(ModelID, user);
model.Mode = "mobile";
switch (model.Action.Value)
{
case "":
LitBody.Text = model.getListHTML();
break;
case "add":
LitBody.Text = model.getAddHTML();
break;
case "edit":
LitBody.Text = model.getEditHTML();
break;
case "copy":
LitBody.Text = model.getEditHTML();
break;
case "view":
LitBody.Text = model.getViewHTML();
break;
case "save":
model.Save();
break;
case "del":
model.Delete();
break;
case "addsub":
eBase.Write(model.getAddHTML());
eBase.End();
break;
case "viewsub":
eBase.Write(model.getViewHTML());
eBase.End();
break;
}
}
protected void Page_Load(object sender, EventArgs e)
{
eUser user = new eUser("System");
user.Check();//检测用户是否登录,未登录则跳转到登录页
}
protected void Page_Load(object sender, EventArgs e)
{
user = new eUser("System");
user.Check();
}
protected void Page_Load(object sender, EventArgs e)
{
eUser user = new eUser("Manage"); //Manage为设定的登录区域
user.Check(); //检测用户是否登录,未登录则跳转到登录页
}
protected void Page_Load(object sender, EventArgs e)
{
user = new eUser("Mobile");
user.Check();
LitMenu.Text = getMenus("");
}
