/// <summary>
/// 保存管理员信息
/// </summary>
protected void UserSave()
{
mU.UserName = this.UserName.Text;
mU.UserPwd = Encryp.DESEncrypt(this.UserPwd.Text);
mField mF = new mField();
bField bF = new bField();
mF.TableName = mm.TableName;
DataSet ds = bF.FieldList(mF);
string Field = "", Val = "";
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Field += ds.Tables[0].Rows[i]["Field"].ToString() + ",";
Val += HXD.ModelField.Common.FieldType.FormatField(ds.Tables[0].Rows[i]["Type"].ToString(), ds.Tables[0].Rows[i]["Field"].ToString()) + "{$split$}";
}
if (mU.Id == 0)
{
Field += "Id";
Val += bU.UserInsert(mU).ToString();
bm.ModelInsert(mm.TableName, Field, Val);
}
else
{
Field += "1";
Val += "1";
bU.UserUpdate(mU);
bm.ModelUpdate(mm.Id, mm.TableName, Field.Trim(','), Val.Trim(','));
}
StringDeal.Alter("保存完成！", "User_Manage.aspx?GroupId=" + mU.GroupId + "");
}
/// <summUry>
/// 批量删除
/// </summUry>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Button1_Click(object sender, EventArgs e)
{
strm = Request["Id"];
if (String.IsNullOrEmpty(strm))
{
StringDeal.Alter("请选择要审核的对象！");
}
else
{
string[] sArray = strm.Split(',');
foreach (string i in sArray)
{
string sql2 = "SELECT IsLock from tb_User where id='" + i + "'";
bool stra = bool.Parse(HXD.DBUtility.SQLHelper.ExecuteScalar(sql2).ToString());
if (stra == true)
{
string sql = "UPDATE tb_User set IsLock=0 where id='" + i + "'";
HXD.DBUtility.SQLHelper.ExecuteScalar(sql);
}
else
{
string sql = "UPDATE tb_User set IsLock=1 where id='" + i + "'";
HXD.DBUtility.SQLHelper.ExecuteScalar(sql);
}
}
Response.Redirect("Font_list2.aspx", true);
}
}
protected void Page_Load(object sender, EventArgs e)
{
LoginCheck.AdminManage();
AdminSetting.isPermissions("2", "5");
string Action = Request.QueryString["Action"];
int Id = StringDeal.ToInt(Request.QueryString["Id"]);
if (Action == "del")
{
AdminSetting.isPermissions("2", "3");
string Result = bC.ChannelDel(Id).ToString();
if (Result == "1")
{
StringDeal.Alter("此频道下存在子频道，请先删除子频道！");
}
}
else if (Action == "lock")
{
bC.ChannelLock(Id);
}
else if (Action == "down" || Action == "up")
{
bC.ChannelMove(Id, Action);
}
dsList = (DataSet)bC.ChannelList(-1);
}
protected void Page_Load(object sender, EventArgs e)
{
LoginCheck.AdminManage();
if (!IsPostBack)
{
bTable bT = new bTable();
string Action = Request.QueryString["Action"];
if (Action == "del")
{
mTable mT = new mTable();
mT.Id = StringDeal.ToInt(Request.QueryString["Id"]);
if (bT.GetIsSystem(mT))
{
StringDeal.Alter("此模型为系统模型禁止删除！");
}
mT.TableName = bT.GetTableName(mT.Id);
bT.TableDel(mT);
HXD.ModelField.BLL.Table bt = new HXD.ModelField.BLL.Table();
bt.DeleteXml(mT);
}
DBList.DataSource = bT.TableList();
DBList.DataBind();
}
}
/// <summary>
/// 保存频道修改/添加
/// </summary>
protected void ChannelSave(object sender, EventArgs e)
{
mC.Title = this.Title.Text;
mC.Url = this.Url.Text;
mC.Target = this.Target.Text;
mC.Note = this.Note.Text;
mC.ParentId = StringDeal.ToInt(this.ParentId.Text);
for (int s = 0; s < this.Setting.Items.Count; s++)
{
if (this.Setting.Items[s].Selected)
{
mC.Setting += this.Setting.Items[s].Value + ",";
}
}
if (!String.IsNullOrEmpty(mC.Setting))
{
mC.Setting = mC.Setting.Trim(',');
}
else
{
mC.Setting = "";
}
if (mC.Id > 0)
{
if (bC.ChannelUpdate(mC) == 1)
{
StringDeal.Alter("父级菜单不能是其本身！");
}
}
else
{
bC.ChannelInsert(mC);
}
StringDeal.Alter("保存完成！", "Channel_Manage.aspx");
}
/// <summary>
/// 保存频道修改/添加
/// </summary>
protected void UserGroupSave()
{
mUG.Title = this.Title.Text;
mUG.ParentId = StringDeal.ToInt(this.ParentId.Text);
mUG.Note = this.Note.Text;
mUG.Model = StringDeal.ToInt(this.Model.Text);
mUG.RegIntegral = StringDeal.ToInt(this.RegIntegral.Text);
mUG.LoginIntegral = StringDeal.ToInt(this.LoginIntegral.Text);
mUG.Collection = StringDeal.ToInt(this.Collection.Text);
mUG.Invite = StringDeal.ToInt(this.Invite.Text);
mUG.RegState = StringDeal.ToBool(this.RegState.Text);
mUG.GroupSetting = StringDeal.StrFormat(Request.Form["GroupSetting"]);
if (mUG.Id > 0)
{
if (bUG.UserGroupUpdate(mUG) == 1)
{
StringDeal.Alter("父级用户组不能为其本身！");
}
}
else
{
bUG.UserGroupInsert(mUG);
}
StringDeal.Alter("保存完成！", "UserGroup_Manage.aspx");
}
protected void getztOperation()
{
if (Request.QueryString["cid"] != null)
{
string clssid = Request.QueryString["cid"].ToString();
int icd = StringDeal.ToInt(Request.QueryString["Id"]);
if (icd > 0)
{
string Action = Request.QueryString["Action"];
if (Action == "del")
{
string sqll = "select COUNT(id) from tb_U_schoolfl where ClassId=" + icd;
int ma = int.Parse(HXD.DBUtility.SQLHelper.ExecuteScalar(sqll).ToString());
if (ma == 0)
{
string sql = "delete from tb_U_schoolfl where ID='" + icd + "';";
HXD.DBUtility.SQLHelper.ExecuteScalar(sql);
}
else
{
StringDeal.Alter("请先删除下级！");
}
}
Response.Redirect("sc_fl.aspx?cid=" + clssid, true);
}
}
}
/// <summary>
/// 对栏目的操作（删除，锁定，置顶，排序）
/// </summary>
protected void Operation()
{
mM.Id = StringDeal.ToInt(Request.QueryString["Id"]);
if (mM.Id > 0)
{
string Action = Request.QueryString["Action"];
if (Action == "del")
{
string Result = bM.MenuDel(mM).ToString();
if (Result == "1")
{
StringDeal.Alter("此栏目下存在子栏目，请先删除子栏目！");
}
}
else if (Action == "lock")
{
bM.MenuLock(mM);
}
else if (Action == "top")
{
bM.MenuTop(mM);
}
else if (Action == "down" || Action == "up")
{
bM.MenuMove(mM, Action);
}
Response.Redirect("Menu_Manage.aspx?MenuId=" + MenuId + "", true);
}
}
protected void Page_Load(object sender, EventArgs e)
{
LoginCheck.AdManage();
getztOperation();
if (!IsPostBack)
{
string MenuId = Session["userid"].ToString();
string sql_group = "select GroupId from tb_User where id=" + MenuId;
int groupid = int.Parse(HXD.DBUtility.SQLHelper.ExecuteScalar(sql_group).ToString());
if (groupid == 7)
{
//string sql_mid = "select Classid from tb_User where id=" + MenuId;
//int scholl_id = int.Parse(HXD.DBUtility.SQLHelper.ExecuteScalar(sql_mid).ToString());
string sql = "select * from tb_U_school order by id";
Repeater1.DataSource = HXD.DBUtility.SQLHelper.ExecuteDataset(sql);
Repeater1.DataBind();
}
else
{
StringDeal.Alter("您没有这个权限！");
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
//string MenuId= Request.QueryString["MenuId"].ToString();
string MenuId = LoginCheck.getadminid();
string username = this.txtAdminName.Value.Trim();
string userpwd = Encryp.DESEncrypt(this.TextBox2.Text.Trim());
string email = this.TextBox4.Text.Trim();
string tell = this.TextBox5.Text.Trim();
string dw_name = this.TextBox6.Text.Trim();
string sqls = "select * from tb_User where UserName='******'";
DataSet ds = HXD.DBUtility.SQLHelper.ExecuteDataset(sqls);
if (ds.Tables[0].Rows.Count == 0)
{
string sql = "insert into tb_User(UserName,UserPwd,GroupId,classid,islock)values('" + username + "','" + userpwd + "',6,'" + MenuId + "',0)";
HXD.DBUtility.SQLHelper.ExecuteScalar(sql);
System.Threading.Thread.Sleep(1000);
string sql2 = "select id from tb_User where UserName='******' ";
string icd = HXD.DBUtility.SQLHelper.ExecuteScalar(sql2).ToString();
string sql3 = "insert into tb_U_User (Id,Tel,msn,name,sc_id)values('" + icd + "','" + tell + "','" + email + "','" + dw_name + "','" + MenuId + "')";
HXD.DBUtility.SQLHelper.ExecuteScalar(sql3);
Response.Redirect("user/");
}
else
{
StringDeal.Alter("用户名已存在");
}
}
/// <summUry>
/// 批量审核
/// </summUry>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Button1_Click(object sender, EventArgs e)
{
String[] readerId = Request.Form.GetValues("Select1");
Session["readerIds"] = readerId;
strm = this.Select1.Value;
if (strm == "0")
{
StringDeal.Alter("请选择要测评的量表！");
}
else
{
//string sqlset = "select usersetting from tb_user where id=" + Session["userid"].ToString();
//string setting = HXD.DBUtility.SQLHelper.ExecuteScalar(sqlset).ToString();
//int i = 0, ii = 0;
////string str = "1,2,3,4,39,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,90,91,93,94,0,5,6,7,8,9,11,13,18,19,20,21,22,23,24,25,27,28,29,31,40,41,42,44,53,54,55,58,59,62,63,64,65,67,68,69,88,89,92,95,96";
//string lbid = Request.QueryString["lbid"].ToString();
//if (lbid == "2")
//{
// i = setting.IndexOf(",0,");
// setting = setting.Substring(0, i);//,0 后的字符串
// strm = setting + ",0," + strm;
//}
//if (lbid == "1")
//{
// ii = setting.IndexOf(",0,");
// setting = setting.Substring(i);//0， 前面的字符串
// strm = strm + setting;
//}
//string stra = str.Substring(i);//0， 后面的字符串
//string strb = setting.Substring(0,ii);//,0 前的字符串
//string sql = "update tb_user set usersetting='" + strm + "' where ID=" + Session["userid"].ToString();
//HXD.DBUtility.SQLHelper.ExecuteScalar(sql);
//string[] sArray = strm.Split(',');
//foreach (string i in sArray)
//{
// string sql2 = "SELECT IsLock from tb_User where id='" + i + "'";
// bool stra = bool.Parse(HXD.DBUtility.SQLHelper.ExecuteScalar(sql2).ToString());
// if (stra == true)
// {
// string sql = "UPDATE tb_User set IsLock=0 where id='" + i + "'";
// HXD.DBUtility.SQLHelper.ExecuteScalar(sql);
// }
// else
// {
// string sql = "UPDATE tb_User set IsLock=1 where id='" + i + "'";
// HXD.DBUtility.SQLHelper.ExecuteScalar(sql);
// }
//}
Response.Redirect("add_cp2.aspx?lbid=" + strm, true);
}
}
protected void Button2_Click(object sender, EventArgs e)
{
string MenuId = Request.QueryString["MenuId"].ToString();
string username = this.username.Text.Trim();
string userpwd = Encryp.DESEncrypt(this.userpwd.Text.Trim());
string tell = this.Texttell.Text.Trim();
string xname = this.Textname.Text.Trim();
string sqls = "select * from tb_User where UserName='******'";
DataSet ds = HXD.DBUtility.SQLHelper.ExecuteDataset(sqls);
if (ds.Tables[0].Rows.Count == 0)
{
string sql = "insert into tb_User(UserName,UserPwd,GroupId,classid,islock)values('" + username + "','" + userpwd + "',6,'" + MenuId + "',1)";
HXD.DBUtility.SQLHelper.ExecuteScalar(sql);
//Session["AdminManage"] = username;
System.Threading.Thread.Sleep(1000);
string sql2 = "select id from tb_User where UserName='******' and datediff(mi,RegTime,getdate())<=1";
string icd = HXD.DBUtility.SQLHelper.ExecuteScalar(sql2).ToString();
//Session["userid"] = icd;
string sql3 = "insert into tb_U_User (Id,Tel,name)values('" + icd + "','" + tell + "','" + xname + "')";
HXD.DBUtility.SQLHelper.ExecuteScalar(sql3);
StringDeal.Alter("添加成功！");
}
else
{
Response.Write("用户名已存在");
}
}
/// <summUry>
/// 批量删除
/// </summUry>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void DelBut_Click(object sender, EventArgs e)
{
if (String.IsNullOrEmpty(mU.Temp))
{
StringDeal.Alter("请选择要删除的对象！");
}
bU.UserDel(mU);
Response.Redirect("User_Manage.aspx?GroupId=" + mU.GroupId + "&Page=" + Pages);
}
protected void Button1_Click(object sender, EventArgs e)
{
string psw = Encryp.DESEncrypt("123456");
int id = int.Parse(Request.QueryString["id"].ToString());
string sql = "update tb_user set UserPwd='" + psw + "' where Id=" + id;
HXD.DBUtility.SQLHelper.ExecuteScalar(sql);
StringDeal.Alter("密码初始化成功 - 默认密码：123456");
}
/// <summary>
/// 批量删除
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void DelBut_Click(object sender, EventArgs e)
{
if (String.IsNullOrEmpty(mA.Temp))
{
StringDeal.Alter("请选择要删除的对象！");
}
bA.AdminDel(mA);
Response.Redirect("Admin_Manage.aspx?Page=" + Pages);
}
/// <summary>
/// 批量取消热门
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void unHotBut_Click(object sender, EventArgs e)
{
if (String.IsNullOrEmpty(mm.Temp))
{
StringDeal.Alter("请选择要取消热门的对象！");
}
mm.IsHot = false;
bm.ModelHot(mm);
Response.Redirect("Model_Manage.aspx?MenuId=" + MenuId, true);
}
protected void Button1_Click(object sender, EventArgs e)
{
string cid = Request.QueryString["cid"].ToString();
string sql = "update tb_U_Message set Replay='" + container.Value + "',state=1 where id=" + cid;
HXD.DBUtility.SQLHelper.ExecuteScalar(sql);
StringDeal.Alter("回复成功", "fd_gt.aspx");
}
/// <summary>
/// 批量锁定
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void LockBut_Click(object sender, EventArgs e)
{
if (String.IsNullOrEmpty(mA.Temp))
{
StringDeal.Alter("请选择要锁定的对象！");
}
mA.IsLock = true;
bA.AdminLock(mA);
Response.Redirect("Admin_Manage.aspx?Page=" + Pages);
}
protected void Button2_Click(object sender, EventArgs e)
{
string userid = Session["userid"].ToString();
string xx_name = this.TextBox1.Text;
string xx_note = Encryp.DESEncrypt(this.TextBox2.Text.Trim());
string sql_u = "update tb_user set userpwd ='" + xx_note + "' where id=" + userid;
HXD.DBUtility.SQLHelper.ExecuteScalar(sql_u);
StringDeal.Alter("密码更新成功！");
}
/// <summUry>
/// 批量解锁
/// </summUry>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void unLockBut_Click(object sender, EventArgs e)
{
if (String.IsNullOrEmpty(mU.Temp))
{
StringDeal.Alter("请选择要解锁的对象！");
}
mU.IsLock = false;
bU.UserLock(mU);
Response.Redirect("User_Manage.aspx?GroupId=" + mU.GroupId + "&Page=" + Pages);
}
/// <summary>
/// 批量推荐
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void EliteBut_Click(object sender, EventArgs e)
{
if (String.IsNullOrEmpty(mm.Temp))
{
StringDeal.Alter("请选择要推荐的对象！");
}
mm.IsElite = true;
bm.ModelElite(mm);
Response.Redirect("Model_Manage.aspx?MenuId=" + MenuId, true);
}
/// <summary>
/// 批量删除
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void DelBut_Click(object sender, EventArgs e)
{
if (String.IsNullOrEmpty(mm.Temp))
{
StringDeal.Alter("请选择要删除的对象！");
}
else
{
bm.ModelDelete(mm);
Response.Redirect("Model_Manage.aspx?MenuId=" + MenuId, true);
}
}
protected void Button2_Click(object sender, EventArgs e)
{
strm = Request["Id"];
if (String.IsNullOrEmpty(strm))
{
StringDeal.Alter("请选择要测评的量表！");
}
else
{
Response.Redirect("add_cp3.aspx?lbid=" + strm, true);
}
}
protected void Button2_Click(object sender, EventArgs e)
{
strm = this.Select1.Value;
if (strm == "0")
{
StringDeal.Alter("请选择要测评的量表！");
}
else
{
Response.Redirect("add_cp3.aspx?lbid=" + strm, true);
}
}
protected void Button2_Click(object sender, EventArgs e)
{
string userid = Session["userid"].ToString();
string sqlcl = "select Classid from tb_user where id=" + userid;
string id = HXD.DBUtility.SQLHelper.ExecuteScalar(sqlcl).ToString();
string xx_name = this.TextBox1.Text.Replace("'", "/'").Replace("\"", "/\"");
string xx_note = this.TextBox2.Text.Replace("'", "/'").Replace("\"", "/\"");
string sql_u = "update tb_U_school set s_name='" + xx_name + "',note ='" + xx_note + "' where id=" + id;
HXD.DBUtility.SQLHelper.ExecuteScalar(sql_u);
StringDeal.Alter("提交成功！", "../edumaste/form_info.aspx");
}
/// <summary>
/// 保存栏目信息
/// </summary>
protected void MenuSave(object sender, EventArgs e)
{
GetFiledId();
string Field = "Model,", Val = this.Model.SelectedValue + "{$split$}";
DataSet ds = bMF.MenuFieldList(mMF);//获取此栏目的模型字段
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Field += ds.Tables[0].Rows[i][1].ToString() + ",";
Val += FieldType.FormatField(ds.Tables[0].Rows[i][4].ToString(), ds.Tables[0].Rows[i][1].ToString()) + "{$split$}";
}
//
string mcSetting = "";
for (int s = 0; s < this.Setting.Items.Count; s++)
{
if (this.Setting.Items[s].Selected)
{
mcSetting += this.Setting.Items[s].Value + ",";
}
}
if (!String.IsNullOrEmpty(mcSetting))
{
mcSetting = "'" + mcSetting.Trim(',') + "'";
}
else
{
mcSetting = "''";
}
Val += mcSetting + "{$split$}";
Field += "Sitting,";
////////
if (mM.Id == 0)
{
//Response.Write(Val.ToString());
bM.MenuInsert(mM.ParentId, Field, Val);
}
else
{
bM.MenuUpdate(mM.Id, mM.ParentId, Field, Val);
}
if (Action == "info")
{
StringDeal.Alter("保存完成！", "Menu_Edit.aspx?Id=" + mM.Id + "&MenuId=" + MenuId + "&Action=info");
}
else
{
StringDeal.Alter("保存完成！", "Menu_Manage.aspx?MenuId=" + MenuId);
}
}
protected void Button2_Click(object sender, EventArgs e)
{
string userid = Session["userid"].ToString();
//string xx_name = this.TextBox1.Text;
//string xx_note = this.TextBox2.Text;
string xx_name = this.TextBox1.Text.Replace("'", "/'").Replace("\"", "/\"");
string xx_note = this.TextBox2.Text.Replace("'", "/'").Replace("\"", "/\"");
string sql_u = "update tb_u_user set name='" + xx_name + "',tel ='" + xx_note + "' where id=" + userid;
HXD.DBUtility.SQLHelper.ExecuteScalar(sql_u);
StringDeal.Alter("更新成功！");
}
protected void Button2_Click(object sender, EventArgs e)
{
string idc = Request.QueryString["wzid"].ToString();
string title = this.TextBox1.Text.Trim();
string note = this.TextBox2.Text.Trim();
//string tag = this.TextBox3.Text.Trim();
string content = this.container.Value.Trim();
string str_se = "1";
string sql = "update tb_U_info set title='" + title + "',note='" + note + "',Content='" + content + "',ClassId='" + str_se + "' where id=" + idc;
HXD.DBUtility.SQLHelper.ExecuteNonQuery(sql);
StringDeal.Alter("更新成功！", "fd_tt.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
LoginCheck.AdminManage();
if (IsPostBack)
{
mAdmin mA = new mAdmin();
bAdmin bA = new bAdmin();
mA.UserName = Session["AdminManage"].ToString();
mA.UserPwd = Encryp.DESEncrypt(this.UserPwd.Text);
if (bA.AdminPwdEdit(mA))
{
StringDeal.Alter("修改完成！");
}
}
}
protected void Button2_Click(object sender, EventArgs e)
{
int id = int.Parse(Request.QueryString["id"].ToString());
string str_Textxh = this.Textxh.Text;
string str_Textname = this.Textname.Text;
//string str_excl_sex = this.excl_sex.Text;
string str_Textmz = this.Textmz.Text;
string str_Textnj = this.Textnj.Text;
string str_TextBbj = this.TextBbj.Text;
string sql = "update tb_u_user set Name='" + str_Textname + "',nationality='" + str_Textmz + "',banji='" + str_Textnj + "',nianji='" + str_TextBbj + "' where Id='" + id + "'";
HXD.DBUtility.SQLHelper.ExecuteScalar(sql);
StringDeal.Alter("个人数据更新成功！", "info.aspx?id=" + id + "&Action=lock");
}
