/// <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"); }