/// <summary>
/// 批量删除 批量启用 批量禁用
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnDelete_Click(object sender, EventArgs e)
{
List <Int32> list = new List <Int32>();
List <String> links = new List <String>();
foreach (RepeaterItem item in Repeater1.Items)
{
CheckBox chkbox = item.FindControl("id") as CheckBox;
HiddenField linkname = item.FindControl("linkname") as HiddenField;
if (chkbox.Checked)
{
list.Add(Convert.ToInt32(chkbox.Text));
links.Add(linkname.Value);
}
}
if (list.Count > 0)
{
String id = String.Join(",", list.ToArray());
Int32 arg = Convert.ToInt32(Request.Form["__EVENTARGUMENT"]);
if (arg == -1)
{
db.ExecuteCommand(String.Format("DELETE FROM [t_links] WHERE id in ({0})", id));
T_LogsHelper.Append("批量删除友情连接:" + String.Join(",", links.ToArray()), Admin.ID);
}
}
BindData();
}
/// <summary>
/// 会员登录
/// </summary>
/// <param name="membername"></param>
/// <param name="password"></param>
public static String Login(String membername, String password)
{
IJsonResult msg = new IJsonResult {
Status = false, Text = "用户名或密码输入错误！"
};
ExecuteObject obj = new ExecuteObject();
obj.tableName = "T_Members";
obj.cmdtype = CmdType.SELECT;
obj.terms.Add("MemberName", membername);
obj.terms.Add("PassWord", EncryptHelper.MD5Upper32(password));
T_MembersEntity data = db.ExecuteObject <T_MembersEntity>(obj);
if (!String.IsNullOrEmpty(data.MemberName))
{
if (!data.Status)
{
msg.Text = "当前账号无法登录，请与管理员联系！";
T_LogsHelper.Append("会员:" + data.MemberName + "尝试登录会员中心,登录失败!", data.ID);
}
else
{
msg.Text = null;
msg.Status = true;
data.LastSignTime = DateTime.Now;
db.ExecuteCommand <T_MembersEntity>(data, CmdType.UPDATE);
T_LogsHelper.Append("会员:" + data.MemberName + "成功登录会员中心!", data.ID);
Member = data;
}
}
return(JsonConvert.SerializeObject(msg));
}
/// <summary>
/// 批量删除 批量启用 批量禁用
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnDelete_Click(object sender, EventArgs e)
{
Int32 arg = Convert.ToInt32(Request.Form["__EVENTARGUMENT"]);
if (arg == -2)
{
db.ExecuteCommand("DELETE FROM [t_logs]");
T_LogsHelper.Append("清空操作日志.", Admin.ID);
}
else if (arg == -1)
{
List <Int32> list = new List <Int32>();
foreach (RepeaterItem item in Repeater1.Items)
{
CheckBox chkbox = item.FindControl("id") as CheckBox;
if (chkbox.Checked)
{
list.Add(Convert.ToInt32(chkbox.Text));
}
}
if (list.Count > 0)
{
String id = String.Join(",", list.ToArray());
db.ExecuteCommand(String.Format("DELETE FROM [t_logs] WHERE id in ({0})", id));
T_LogsHelper.Append("批量操作日志.", Admin.ID);
}
}
BindData();
}
/// <summary>
/// 列表事件
/// </summary>
/// <param name="source"></param>
/// <param name="e"></param>
protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
{
String ID = ((CheckBox)e.Item.FindControl("ID")).Text;
HiddenField linkname = e.Item.FindControl("linkname") as HiddenField;
if (e.CommandName == "del")
{
db.ExecuteCommand(String.Format("DELETE FROM [t_links] WHERE id in ({0})", ID));
T_LogsHelper.Append("删除友情连接:" + linkname.Value, Admin.ID);
}
BindData();
}
/// <summary>
/// 列表事件
/// </summary>
/// <param name="source"></param>
/// <param name="e"></param>
protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
{
String ID = ((CheckBox)e.Item.FindControl("ID")).Text;
if (e.CommandName == "del")
{
db.ExecuteCommand(String.Format("DELETE FROM [T_Logs] WHERE id in ({0})", ID));
T_LogsHelper.Append("删除操作日志.", Admin.ID);
}
BindData();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
IJsonResult result = new IJsonResult {
Text = "备份失败!", Ico = MessageICO.Failure
};
String basedir = AppDomain.CurrentDomain.BaseDirectory;
FileInfo backfile = new FileInfo(Server.MapPath("/Developer/BackUp/data.bak"));
if (backfile.Exists)
{
backfile.Delete();
}
try
{
String sql = String.Format("BACKUP DATABASE data TO DISK = N'{0}' WITH INIT,NOUNLOAD,NAME = N'数据备份',NOSKIP,STATS = 10,NOFORMAT", backfile.FullName);
db.ExecuteReader(sql);
ProcessStartInfo p = new ProcessStartInfo();
p.FileName = Server.MapPath("/App_Data/Plugins/Rar.exe");
p.Arguments = String.Format(" a {0}.rar -ep {1}", DateTime.Now.ToString("yyyy年MM月dd日"), backfile.FullName);
p.WindowStyle = ProcessWindowStyle.Hidden;
p.WorkingDirectory = Server.MapPath("/Developer/BackUp");
Process process = new Process();
process.StartInfo = p;
process.Start();
process.WaitForExit();
process.Close();
backfile = new FileInfo(Server.MapPath("/Developer/BackUp/data.bak"));
if (backfile.Exists)
{
backfile.Delete();
}
result.Status = true;
result.Text = "备份成功!";
result.Ico = MessageICO.Success;
T_LogsHelper.Append("备份数据库：" + DateTime.Now.ToString("yyyy年MM月dd日") + ".rar", LogsAction.BackUp, Admin.UserData);
}
catch (Exception ex)
{
result.Text = ex.Message;
}
String json = JsonConvert.SerializeObject(result);
Response.Write(json);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
IJsonResult result = new IJsonResult {
Text = "打包失败!", Ico = MessageICO.Failure
};
try
{
int i = 0;
String backfile = "/网站打包[" + DateTime.Now.ToString("yyyy-MM-dd") + "].rar";
while (File.Exists(Server.MapPath(backfile)))
{
i++;
backfile = "/网站打包[" + DateTime.Now.ToString("yyyy-MM-dd") + "]-" + i.ToString("00") + ".rar";
}
String rarfile = Server.MapPath(backfile);
ProcessStartInfo p = new ProcessStartInfo();
p.FileName = Server.MapPath("/App_Data/Plugins/Rar.exe");
p.Arguments = String.Format(" a {0} -r -m5", rarfile);
p.WindowStyle = ProcessWindowStyle.Hidden;
p.WorkingDirectory = Server.MapPath("/");
Process process = new Process();
process.StartInfo = p;
process.Start();
process.WaitForExit();
process.Close();
Thread.Sleep(300);
result.Text = "打包成功,文件已存放在网站根目录下!";
result.Ico = MessageICO.Success;
result.Status = true;
result.Data = backfile;
T_LogsHelper.Append("打包网站：" + backfile, LogsAction.Delete, Admin.UserData);
}
catch (Exception ex)
{
result.Text = ex.Message;
}
Response.Write(JsonConvert.SerializeObject(result));
}
}
/// <summary>
/// 用户登录
/// </summary>
/// <param name="username">用户名</param>
/// <param name="password">登录密码</param>
/// <returns></returns>
public static void LoginUser(String username, String password, ref IJsonResult result)
{
ExecuteObject obj = new ExecuteObject();
obj.tableName = "T_User";
obj.cmdtype = CmdType.SELECT;
obj.terms.Add("UserName", username);
obj.terms.Add("UserPass", password);
T_UserEntity data = db.ExecuteObject <T_UserEntity>(obj);
if (data.ID > 0)
{
if (data.IsLock)
{
result.Text = "当前账号无法登录，请与管理员联系！";
T_LogsHelper.Append("尝试登录管理系统.", LogsAction.Login, data);
}
else
{
result.Status = true;
data.LastSignTime = DateTime.Now;
db.ExecuteCommand <T_UserEntity>(data, CmdType.UPDATE);
T_LogsHelper.Append("成功登录管理系统.", LogsAction.Login, data);
SetUserData(data);
FormsAuthenticationTicket ticket = new FormsAuthenticationTicket(1, "root", DateTime.Now, DateTime.Now.AddMinutes(60), false, data.ID.ToString());
String authticket = FormsAuthentication.Encrypt(ticket);
CookieHelper.AddCookie(FormsAuthentication.FormsCookieName, authticket);
//HttpCookie cookie = new HttpCookie(FormsAuthentication.FormsCookieName, authticket);
//cookie.Expires = DateTime.Now.AddMinutes(60);
//cookie.HttpOnly = false;
//cookie.Path = FormsAuthentication.FormsCookiePath;
//cookie.Secure = FormsAuthentication.RequireSSL;
//cookie.Domain = FormsAuthentication.CookieDomain;
//HttpContext.Current.Response.Cookies.Set(cookie);
//HttpContext.Current.Response.Redirect("/Developer", true);
}
}
}
/// <summary>
/// 保存
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
T_LinksEntity data = (T_LinksEntity)ViewState["data"];
data = this.GetFormValue <T_LinksEntity>(data);
CmdType cmd = IsEdit ? CmdType.UPDATE : CmdType.INSERT;
if (db.ExecuteCommand <T_LinksEntity>(data, cmd))
{
if (!IsEdit)
{
this.ClearFromValue();
T_LogsHelper.Append("添加友情连接:" + data.LinkName, Admin.ID);
}
else
{
T_LogsHelper.Append("编辑友情连接:" + data.LinkName, Admin.ID);
}
Alert(Label1, "保存成功！", "line1px_3");
}
}
/// <summary>
/// 批量删除 批量启用 批量禁用
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnDelete_Click(object sender, EventArgs e)
{
List <Int32> list = new List <Int32>();
List <String> titles = new List <String>();
foreach (RepeaterItem item in Repeater1.Items)
{
CheckBox chk = item.FindControl("id") as CheckBox;
HiddenField title = item.FindControl("title") as HiddenField;
if (chk.Checked)
{
list.Add(Convert.ToInt32(chk.Text));
titles.Add(title.Value);
}
}
if (list.Count > 0)
{
String id = String.Join(",", list.ToArray());
Int32 arguments = Convert.ToInt32(Request.Form["__EVENTARGUMENT"]);
switch (arguments)
{
case 0: //批量未审核
db.ExecuteCommand(String.Format("UPDATE [t_comment] SET audit = 0 WHERE id IN({0})", id));
T_LogsHelper.Append("批量未通过审核:" + String.Join(",", titles.ToArray()), Admin.ID);
break;
case -1: //删除
db.ExecuteCommand(String.Format("DELETE FROM [t_comment] WHERE id in ({0})", id));
T_LogsHelper.Append("批量删除评论:" + String.Join(",", titles.ToArray()), Admin.ID);
break;
case 1: //批量通过审核
db.ExecuteCommand(String.Format("UPDATE [t_comment] SET audit = 1 WHERE id IN({0})", id));
T_LogsHelper.Append("批量通过审核:" + String.Join(",", titles.ToArray()), Admin.ID);
break;
}
}
BindData();
}
/// <summary>
/// 批量删除 批量启用 批量禁用
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnDelete_Click(object sender, EventArgs e)
{
List <Int32> list = new List <Int32>();
List <String> members = new List <String>();
foreach (RepeaterItem item in Repeater1.Items)
{
CheckBox chk = item.FindControl("id") as CheckBox;
HiddenField member = item.FindControl("membername") as HiddenField;
if (chk.Checked)
{
list.Add(Convert.ToInt32(chk.Text));
members.Add(member.Value);
}
}
if (list.Count > 0)
{
String id = String.Join(",", list.ToArray());
Int32 arguments = Convert.ToInt32(Request.Form["__EVENTARGUMENT"]);
switch (arguments)
{
case 0: //禁用
db.ExecuteCommand(String.Format("UPDATE [t_members] SET status = 0 WHERE id IN({0})", id));
T_LogsHelper.Append("批量禁用会员:" + String.Join(",", members.ToArray()), Admin.ID);
break;
case -1: //删除
db.ExecuteCommand(String.Format("DELETE FROM [t_members] WHERE id in ({0})", id));
T_LogsHelper.Append("批量删除会员:" + String.Join(",", members.ToArray()), Admin.ID);
break;
case 1: //启用
db.ExecuteCommand(String.Format("UPDATE [t_members] SET status = 1 WHERE id IN({0})", id));
T_LogsHelper.Append("批量启用会员:" + String.Join(",", members.ToArray()), Admin.ID);
break;
}
}
BindData();
}
/// <summary>
/// 列表事件
/// </summary>
/// <param name="source"></param>
/// <param name="e"></param>
protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
{
String ID = ((CheckBox)e.Item.FindControl("ID")).Text;
HiddenField title = e.Item.FindControl("title") as HiddenField;
switch (e.CommandName)
{
case "del":
db.ExecuteCommand(String.Format("DELETE FROM [t_comment] WHERE id in ({0})", ID));
T_LogsHelper.Append("删除评论:" + title.Value, Admin.ID);
break;
case "audit":
ExecuteObject obj = new ExecuteObject();
obj.cmdtype = CmdType.UPDATE;
obj.tableName = "t_comment";
obj.terms.Add("id", ID);
obj.cells.Add(e.CommandName, !Convert.ToBoolean(e.CommandArgument));
db.ExecuteCommand(obj);
T_LogsHelper.Append("修改评论审核:" + title.Value, Admin.ID);
break;
}
BindData();
}
/// <summary>
/// 记录日志
/// </summary>
/// <param name="text"></param>
/// <param name="action"></param>
protected void AppendLogs(String text, LogsAction action)
{
T_LogsHelper.Append(text, action, Admin.UserData);
}