public void update() { if (this.TextBox1.Text.Trim() == string.Empty) { Jscript.Alert("投票信息标题不能为空!", this.Page); } else if (this.Text1.Value.Trim() == string.Empty) { Jscript.Alert("到期时间不能为空!", this.Page); } else { HXD.SQLServerDAL.tb_U_TouPiao toupiaodal = new HXD.SQLServerDAL.tb_U_TouPiao(); //投票操作类 HXD.Model.tb_U_TouPiao toupiaomodel = new HXD.Model.tb_U_TouPiao(); //投票属性类 toupiaomodel.id = id; toupiaomodel.title = this.TextBox1.Text.Trim(); toupiaomodel.is_Examine = this.CheckBox1.Checked ? 1 : 0; //是否审核 toupiaomodel.is_Recommendation = this.CheckBox2.Checked ? 1 : 0; //是否推荐 toupiaomodel.end_time = Convert.ToDateTime(this.Text1.Value); toupiaomodel.VoteType = this.RadioButton1.Checked ? 1 : 2; if (toupiaodal.Update(toupiaomodel)) { Jscript.AlertAndRedirect("投票信息修改成功!", "TouPiaoList.aspx?Page=" + Pages); } else { Jscript.Alert("投票信息修改失败!", Page); return; } } }
/// <summary> /// 保存信息 /// </summary> protected void ModelSave() { string Field = "ClassId,", Val = this.ClassId.SelectedValue + "{$split$}"; mField mF = new mField(); bField bF = new bField(); mF.TableName = mm.TableName; DataSet ds = bF.FieldList(mF); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { string ValTemp = System.Web.HttpContext.Current.Request.Form[ds.Tables[0].Rows[i]["Field"].ToString()]; if (ValTemp != string.Empty && ValTemp != null) { 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 (mm.Id == 0) { bm.ModelInsert(mm.TableName, Field, Val); } else { bm.ModelUpdate(mm.Id, mm.TableName, Field, Val); } if (MenuId == 0) { Jscript.Alert("保存成功!", this.Page); binder(); } else { Response.Redirect("Model_Manage.aspx?MenuId=" + MenuId); } }
/// <summary> /// 批量删除 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Button2_Click(object sender, EventArgs e) { string ids = selInfo(); int num = 0; if (ids.Length == 0) { Jscript.Alert("请选择要删除的记录!", this.Page); return; } string[] arr = ids.TrimEnd(',').Split(','); for (int i = 0; i < arr.Length; i++) { if (AdminUserService.Delete(Convert.ToInt32(arr[i])) > 0) { num++; } } ScriptManager.RegisterStartupScript(this.UpdatePanel1, this.GetType(), "", "alert('成功删除" + num + "条记录!');", true); DataSet ds = AdminUserService.GetList(""); if (ds.Tables[0].Rows.Count > 0) { this.repInfo.DataSource = ds; repInfo.DataBind(); } }
protected void Button1_Click(object sender, EventArgs e) { if (Page.IsValid) { try { string lei = this.TextBox1.Text; string leishu = this.TextBox3.Text; int count = int.Parse(da.GetSingeData("select count(*) from tm_path where myParent = 0 and (cn_name ='" + lei + "' or id=" + leishu + ")").ToString()); if (count > 0) { Jscript.Alert("该名称或基准ID已被使用,请重试!"); } else { da.RunSql("insert into tm_path (cn_name,id,barid,myparent,visible,ntype,realid,sequence,zlevel,showinleft,showintop) " + "values ('" + lei + "','" + leishu + "','" + leishu + "','0',1,'SinglePage',NULL," + leishu + "*10,1,1,1)"); this.Label1.Text = "<div class=\"boxdiv\">提交成功!</div>"; this.TextBox1.Text = null; Bind(); } //string sql = "insert into smn_lanmu_type (lei,leishu)values('" + lei + "','" + leishu + "')"; //da.RunSql(sql); } catch { this.Label1.Text = "<div class=\"boxdiv\">提交失败!</div>"; } finally { } } }
protected void rp_main_ItemCommand(object source, RepeaterCommandEventArgs e) { SHUniversity.KPI.Model.Users currUser = Session["SHUUser"] as SHUniversity.KPI.Model.Users; string parma = e.CommandArgument.ToString(); //0未提交1正在审核2审核通过3退回 if (e.CommandName == "pass") { bool r = kpiBll.ChangeStatus(parma, 2, currUser.Name, currUser.WorkID); if (r) { Jscript.Alert("审核成功"); } else { Jscript.Alert("审核失败,稍后再试"); } } if (e.CommandName == "back") { bool r = kpiBll.ChangeStatus(parma, 3, currUser.Name, currUser.WorkID); if (r) { Jscript.Alert("审核成功"); } else { Jscript.Alert("审核失败,稍后再试"); } } }
protected void DataList1_ItemCommand(object source, RepeaterCommandEventArgs e) { string id = e.CommandArgument.ToString(); if (e.CommandName == "edit") { Response.Redirect("PathConfig.aspx?id=" + id); } else if (e.CommandName == "Add") { Response.Redirect("Article_lanmu2_add.aspx?id=" + id); } else if (e.CommandName == "SetFirst") { Response.Redirect("Article_setfirst.aspx?type=" + id); } else if (e.CommandName == "Delete") { int count = int.Parse(da.GetSingeData("select count(*) from tm_path where myparent=" + id).ToString()); if (count > 0) { Jscript.Alert("该分类存在子类,不能被删除!"); } else { string sql = "delete from tm_path where id=" + id; da.RunSql(sql); Bind(); } //Response.Redirect("Article_setfirst.aspx?type=" + id); } }
protected void butSava_Click(object sender, EventArgs e) { FNEWS_TYPE dalNewsType = new FNEWS_TYPE(); string id = Request.QueryString["id"]; ENEWSType eNewsType = dalNewsType.GetDAL().GetModel(Convert.ToInt32(Hid.Value)); eNewsType.TypeName = txtTypeName.Text.Trim(); eNewsType.ParentID = Convert.ToInt32(DD_Type.SelectedValue); if (isfabu.Checked == true) { eNewsType.ISFabu = 1; } else { eNewsType.ISFabu = 0; } if (islimit.Checked == true) //0全访问1会员访问 { eNewsType.ISLimit = 1; } else { eNewsType.ISLimit = 0; } bool count = dalNewsType.GetDAL().Update(eNewsType); if (count) { Jscript.RedirectToFrames("Admin_NewsType.aspx"); } else { Jscript.Alert("异常错误,请重试!"); } }
/// <summary> /// 修改 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void butSava_Click(object sender, EventArgs e) { SHUniversity.KPI.Model.Users u = new SHUniversity.KPI.Model.Users(); u.ID = int.Parse(hidid.Value); u.BrithDay = SHUniversity.KPI.Common.ConvertDatetime(txt_birthday.Text.Trim()); u.CreatDate = DateTime.Now; u.Email = txt_email.Text.Trim(); u.InDate = Common.ConvertDatetime(txt_indate.Text.Trim()); u.Moblie = txt_moblie.Text.Trim(); u.Name = txt_name.Text.Trim(); u.Password = txt_pwd.Text.Trim(); u.Ramerk = txt_common.Text.Trim(); u.Satat = 1; u.Sex = int.Parse(rb_sex.SelectedValue); u.Tel = txt_tell.Text.Trim(); u.UserType = int.Parse(rb_usertype.SelectedValue); u.WorkID = txt_workID.Text.Trim(); u.Xueli = txt_xueli.Text.Trim(); u.Xuexiao = txt_xuexiao.Text.Trim(); u.Zhiwu = txt_zhiwu.Text.Trim(); bool result = uBll.Update(u); if (result) { Jscript.RedirectToFrames("UserManage.aspx"); } else { Jscript.Alert("修改异常,请重试"); Jscript.RedirectToFrames("UserManage.aspx"); } }
/// <summary> /// 批量删除 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnDel_Click(object sender, EventArgs e) { string ids = selInfo(); int num = 0; if (ids.Length == 0) { Jscript.Alert("请选择要删除的记录!", this.Page); return; } string[] arr = ids.TrimEnd(',').Split(','); int newsId = 0; for (int i = 0; i < arr.Length; i++) { int id = Convert.ToInt32(arr[i]); newsId = TopNewsService.GetModel(id).newsId; if (TopNewsService.Delete(id) > 0) { NewsService.UpdateTop(newsId, 0); num++; } } ScriptManager.RegisterStartupScript(this.UpdatePanel1, this.GetType(), "", "alert('成功删除" + num + "条记录!');", true); sp.InitBindData(Repeater1, pager1, "TopNews", "id", sear()); }
protected void Button1_Click(object sender, EventArgs e) { if (this.TextBox1.Text.Trim() == string.Empty) { Jscript.Alert("投票信息标题不能为空!", this.Page); } else if (this.Text1.Value.Trim() == string.Empty) { Jscript.Alert("到期时间不能为空!", this.Page); } else { HXD.SQLServerDAL.tb_U_TouPiao toupiaodal = new HXD.SQLServerDAL.tb_U_TouPiao(); //投票操作类 HXD.Model.tb_U_TouPiao toupiaomodel = new HXD.Model.tb_U_TouPiao(); //投票属性类 toupiaomodel.title = this.TextBox1.Text.Trim(); toupiaomodel.is_Examine = this.CheckBox1.Checked ? 1 : 0; toupiaomodel.is_Recommendation = this.CheckBox2.Checked ? 1 : 0; toupiaomodel.end_time = Convert.ToDateTime(this.Text1.Value); toupiaomodel.VoteType = this.RadioButton1.Checked ? 1 : 2; if (toupiaodal.Add(toupiaomodel)) { Jscript.AlertAndRedirect("投票信息添加成功!", "TouPiaoList.aspx?Page=" + Pages); } else { Jscript.Alert("投票信息添加失败!", this.Page); } } }
protected void btn_CreatTable_Click(object sender, EventArgs e) { SHUniversity.KPI.Model.Users u = (SHUniversity.KPI.Model.Users)Session["SHUUser"]; //lb_msg bool r = kpiBll.Exists(u.WorkID, DateTime.Now.Year); if (r) { Jscript.Alert("本年度已经创建了考核表,不能重复创建"); } else { SHUniversity.KPI.Model.UserKPI kpi = new SHUniversity.KPI.Model.UserKPI(); kpi.CreatDate = DateTime.Now; kpi.Creator = u.Name; kpi.KPINumber = SHUniversity.KPI.Common.CreatRandom(); kpi.KPIYear = DateTime.Now.Year; kpi.Status = 0;//0未审核1正在审核2审核通过3退回 kpi.WorkID = u.WorkID; int result = kpiBll.Add(kpi); if (result > 0) { Jscript.AlertAndRedirect("建表成功", "/Home.aspx"); } else { } } }
protected void Button1_Click(object sender, EventArgs e) { DataAccess da = new DataAccess(); string username = UserName.Text; if (username == "") { Jscript.Alert("用户名不能为空"); return; } string realname = RealName.Text; if (realname == "") { Jscript.Alert("姓名不能为空"); return; } string password = pwd.Text; password = StringUtil.EncryptPassword(password, "MD5"); string youxiao = Youxiao.Checked ? "1" : "0"; string superType = Superman.Checked ? "1" : "0"; string quan = "," + Request.Form["innerc"] + ","; if (ViewState["editmode"] != null) { da.RunSql("update tm_Admin set realname='" + realname + "',AdminPurview='" + quan + "',isused=" + youxiao + ",supertype=" + superType + " where username='******'"); if (pwd.Text.Trim() != "") { da.RunSql("update tm_Admin set pwd='" + password + "' where username='******'"); } } else { da.RunSql("insert into tm_Admin(username,realname,pwd,AdminPurview,isUsed,supertype) values('" + username + "','" + realname + "','" + password + "','" + quan + "'," + youxiao + "," + superType + ")"); } Jscript.AlertAndRedirect("成功新增管理员!", "Adminlist.aspx"); }
protected void Button1_Click(object sender, EventArgs e) { if (this.TextBox1.Text.Trim() == "") { Jscript.Alert("请填写广告名称!", this.Page); } else { insert(); } }
/// <summary> /// 更新指定分类 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Button3_Click(object sender, EventArgs e) { if (this.ClassId.SelectedValue == "-1") { HXD.Common.HtmlDal.WToHtmlNewsUpData("", "html"); } else { HXD.Common.HtmlDal.WToHtmlNewsUpData("where ClassId=" + this.ClassId.SelectedValue, "html"); } Jscript.Alert("生成完毕", this.Page); }
protected void btnCreateQR_Click(object sender, EventArgs e) { this.txtQRUrl.Text = string.Empty; this.ImageQR.ImageUrl = ""; if (this.txtPassword.Text.Equals("createQRAdministrator")) { if (string.IsNullOrEmpty(this.txtSourceFrom.Text.Trim()) || this.txtSourceFrom.Text.Trim().Length > 59) { JavaScript.Alert("推广渠道填写错误,最多60个字,不能空白"); } #region 先判断以前有没有,有就直接返回 const string querySql = "select * from [dbo].[WXQRInfos] where sourceFrom =@sourceFrom order by AddDate desc "; var param = new DynamicParameters(); param.Add("@SourceFrom", this.txtSourceFrom.Text.Trim()); var wxQrInfos =PublicConn.QueryActivityBySql<WXQRInfo>(querySql,ref param); if (wxQrInfos.Count >=1) { this.txtQRUrl.Text = wxQrInfos.FirstOrDefault().QrUrl; this.ImageQR.ImageUrl = "http://s.jiathis.com/qrcode.php?url=" + wxQrInfos.FirstOrDefault().QrUrl; JavaScript.Alert("已经生成过这样的推广二维码了哦!"); return; } #endregion #region 调用接口获取 ThirdLoginSDK sdk = new ThirdLoginSDK(); sdk.InitSDK(ThirdLoginSDK.ThirdLoginType.WeiXin); var wxQr = sdk.GetWXQrInfoBy(this.txtSourceFrom.Text); if (wxQr != null) { this.txtQRUrl.Text = wxQr.url; const string insertSql = @"insert into [dbo].[WXQRInfos]([Id],[SourceFrom],[AddDate],[QrUrl],[Ticket]) values (@Id,@SourceFrom,@AddDate,@QrUrl,@Ticket)"; var param2 = new DynamicParameters(); param2.Add("@Id", Guid.NewGuid()); param2.Add("@SourceFrom", this.txtSourceFrom.Text); param2.Add("@AddDate", DateTime.Now); param2.Add("@QrUrl", wxQr.url); param2.Add("@Ticket", wxQr.ticket); PublicConn.ExecuteActivity(insertSql,ref param2); this.ImageQR.ImageUrl = "http://s.jiathis.com/qrcode.php?url=" + wxQr.url; } #endregion } else { Jscript.Alert("请输入正确的管理员密码"); } }
/// <summary> /// 保存 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void butSava_Click(object sender, EventArgs e) { EPROType model = new EPROType(); if (con == "edit") { model = fpt.GetDAL().GetModel(Convert.ToInt32(id)); } model.TypeName = txtProTypeName.Text.Trim(); model.ParentID = Convert.ToInt32(DD_Type.SelectedValue); if (CB_ispub.Checked == true) { model.ISPub = "1"; } else { model.ISPub = "0"; } if (CB_isLimit.Checked == true) //0全访问1会员访问 { model.ISLimit = "1"; } else { model.ISLimit = "0"; } bool result; if (con == "add") { result = fpt.GetDAL().Add(model); } else { result = fpt.GetDAL().Update(model); } if (result) { Jscript.RedirectToFrames("Admin_PROTYPE.aspx"); } else { Jscript.Alert("异常错误,请重试!"); } }
/// <summary> /// 删除图片 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Button8_Click(object sender, EventArgs e) { if (ViewState["mod"] != null) { int id = Convert.ToInt32(ViewState["mod"]); if (System.IO.File.Exists(Server.MapPath(lblUrl3.Text))) { System.IO.File.Delete(Server.MapPath(lblUrl3.Text)); } if (ProductTypeService.DeleteTypeImg(id, 3)) { Jscript.Alert("操作成功"); } } sp.InitBindData(repInfo, this.pager1, "ProductType", "id", sear()); }
/// <summary> /// 保存顺序 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void OrderBy_Click(object sender, EventArgs e) { for (int i = 0; i < this.RP_con.Items.Count; i++) { string id = ((RP_con.Items[i].FindControl("HiddenField_")) as HiddenField).Value; string orderby = ((RP_con.Items[i].FindControl("txtOrderBy")) as TextBox).Text; if (SITED.COMMON.PageValidate.IsNumber(orderby)) { EPRO epo = bll_fpo.GetDAL().GetModel(Convert.ToInt32(id)); epo.OrderBy = Convert.ToInt32(orderby); bll_fpo.GetDAL().Update(epo); } else { Jscript.Alert("顺序只能为数字!"); } } Jscript.RedirectToFrames("Admin_PRO.aspx"); }
protected void LinkButton1_Click(object sender, EventArgs e) { string ids = selInfo(); int num = 0; if (ids.Length == 0) { Jscript.Alert("请选择要Delete的记录!", this.Page); return; } string[] arr = ids.TrimEnd(',').Split(','); for (int i = 0; i < arr.Length; i++) { if (CartTempService.Delete(Convert.ToInt32(arr[i]))) { num++; } } BindData(); }
protected void butSava_Click(object sender, EventArgs e) { try { if (ubll.Exists(txt_workID.Text.Trim())) { Jscript.Alert("已经存在的工号"); return; } //添加用户 SHUniversity.KPI.Model.Users u = new SHUniversity.KPI.Model.Users(); u.BrithDay = SHUniversity.KPI.Common.ConvertDatetime(txt_birthday.Text.Trim()); u.CreatDate = DateTime.Now; u.Email = txt_email.Text.Trim(); u.InDate = Common.ConvertDatetime(txt_indate.Text.Trim()); u.Moblie = txt_moblie.Text.Trim(); u.Name = txt_name.Text.Trim(); u.Password = txt_pwd.Text.Trim(); u.Ramerk = txt_common.Text.Trim(); u.Satat = 1; u.Sex = int.Parse(rb_sex.SelectedValue); u.Tel = txt_tell.Text.Trim(); u.UserType = int.Parse(rb_usertype.SelectedValue); u.WorkID = txt_workID.Text.Trim(); u.Xueli = txt_xueli.Text.Trim(); u.Xuexiao = txt_xuexiao.Text.Trim(); u.Zhiwu = txt_zhiwu.Text.Trim(); if (ubll.Add(u) > 0) { Jscript.AlertAndRedirect("添加成功!", "AddUser.aspx"); } else { Jscript.Alert("添加失败请重试"); } } catch (Exception ex) { Jscript.Alert("异常信息:" + ex.Message); } }
/// <summary> /// 热门新闻设置 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSetHot_Click(object sender, EventArgs e) { string ids = selInfo(); int num = 0; if (ids.Length == 0) { Jscript.Alert("请选择要设置的记录!", this.Page); return; } string[] arr = ids.TrimEnd(',').Split(','); for (int i = 0; i < arr.Length; i++) { if (NewsService.UpdateOrderNum(Convert.ToInt32(arr[i])) > 0) { num++; } } ScriptManager.RegisterStartupScript(this.UpdatePanel1, this.GetType(), "", "alert('成功设置" + num + "条记录!');", true); sp.InitBindData(Repeater1, pager1, "news", "id", sear()); }
protected void rp_table_ItemCommand(object source, RepeaterCommandEventArgs e) { SHUniversity.KPI.Model.UserKPI kpi = kpiBll.GetModel(int.Parse(e.CommandArgument.ToString())); if (kpi.Status != 0) { Jscript.Alert("当前状态不可以提交"); return; } if (e.CommandName == "apply") { bool r = kpiBll.ChangeStatus(e.CommandArgument.ToString(), 1, u.Name, u.WorkID); if (r) { Jscript.Alert("提交成功"); } else { Jscript.Alert("提交失败"); } } }
/// <summary> /// 删除所选项 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void LB_DelSelect_Click(object sender, EventArgs e) { string sb = string.Empty; for (int i = 0; i < this.RP_con.Items.Count; i++) { CheckBox cb = (RP_con.Items[i].FindControl("CheckBox1_")) as CheckBox; if (cb.Checked == true) { string dd = ((RP_con.Items[i].FindControl("HiddenField_")) as HiddenField).Value; sb += dd + ","; } } if (ubll.DeleteList(sb)) { Jscript.RedirectToFrames("UserManage.aspx"); } else { Jscript.Alert("删除失败,请重试!!"); } }
/// <summary> /// 批量删除 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnDel_Click(object sender, EventArgs e) { string ids = selInfo(); int num = 0; if (ids.Length == 0) { Jscript.Alert("请选择要删除的记录!", this.Page); return; } string[] arr = ids.TrimEnd(',').Split(','); for (int i = 0; i < arr.Length; i++) { if (SearchKeyWordService.Delete(Convert.ToInt32(arr[i]))) { num++; } } ScriptManager.RegisterStartupScript(this.UpdatePanel1, this.GetType(), "", "alert('成功删除" + num + "条记录!');", true); sp.InitBindData(this.repInfo, pager1, "SearchKeyWord", "id", sear()); }
protected void Button1_Click(object sender, EventArgs e) { string name = this.txtUserName.Text.Trim(); string pass = this.txtPassWord.Text.Trim(); if (name.Length == 0 || pass.Length == 0) { Jscript.Alert("各项不能为空"); return; } AdminUser item = AdminUserService.GetModel(name, pass); if (item != null && item.status == 1) { Session["loginUser"] = item; Response.Redirect("inok.aspx"); } else { Jscript.AlertAndRedirect("无此账号或已被停用,请联系超级管理员!", this.Request.RawUrl); } }
protected void Button1_Click(object sender, EventArgs e) { if (this.TextBox1.Text.Trim() == string.Empty) { Jscript.Alert("标签说明不能为空!", this.Page); } else if (this.TextBox2.Text.Trim() == string.Empty) { Jscript.Alert("标签名称不能为空!", this.Page); } else if (this.TextBox3.Text.Trim() == string.Empty) { Jscript.Alert("文件名称不能为空!", this.Page); } else if (this.Content.Value.Trim() == string.Empty) { Jscript.Alert("标签内容不能为空!", this.Page); } else { HXD.SQLServerDAL.tb_U_Template_Label DAL = new HXD.SQLServerDAL.tb_U_Template_Label(); HXD.Model.tb_U_Template_Label Model = new HXD.Model.tb_U_Template_Label(); Model.id = id; Model.labelHelp = this.TextBox1.Text.Trim(); Model.labelname = this.TextBox2.Text.Trim(); Model.labelfile = this.TextBox3.Text.Trim(); Model.counts = this.Content.Value.Trim(); if (DAL.Update(Model)) { HXD.Common.FilesManage.ReplaceFileNewContent("~/" + Model.labelfile, Model.labelname, Model.counts, Web.Model.PublicModel.EncodingUTF8); Jscript.AlertAndRedirect("标签修改成功!", "TemplateLabelList.aspx?Page=" + Pages); } else { Jscript.Alert("标签修改失败!", this.Page); } } }
protected void Button1_Click(object sender, EventArgs e) { if (this.TextBox1.Text.Trim() == string.Empty) { Jscript.Alert("标签说明不能为空!", this.Page); } else if (this.TextBox2.Text.Trim() == string.Empty) { Jscript.Alert("标签名称不能为空!", this.Page); } else if (this.TextBox3.Text.Trim() == string.Empty) { Jscript.Alert("文件名称不能为空!", this.Page); } else if (this.Content.Value.Trim() == string.Empty) { Jscript.Alert("标签内容不能为空!", this.Page); } else { HXD.SQLServerDAL.tb_U_Template_Label DAL = new HXD.SQLServerDAL.tb_U_Template_Label(); HXD.Model.tb_U_Template_Label Model = new HXD.Model.tb_U_Template_Label(); Model.labelHelp = this.TextBox1.Text.Trim(); Model.labelname = this.TextBox2.Text.Trim(); Model.labelfile = this.TextBox3.Text.Trim(); Model.counts = this.Content.Value.Trim(); if (DAL.Add(Model)) { //FilesManage.ReplaceFileNewContent(Server.MapPath("~/" + Model.labelfile), Model.labelname, Model.counts);//更新文件 Jscript.AlertAndRedirect("标签添加成功!", "TemplateLabelList.aspx?Page=" + Pages); } else { Jscript.Alert("标签添加失败!", this.Page); } } }
/// <summary> /// 保存 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void butSava_Click(object sender, EventArgs e) { FNEWS_TYPE news_type = new FNEWS_TYPE(); ENEWSType Enewtype = new ENEWSType(); Enewtype.TypeName = Request.Form["newstypename"]; Enewtype.ParentID = Convert.ToInt32(DD_Type.SelectedValue); if (Request.Form["isfabu"] == "on") { Enewtype.ISFabu = 1; } else { Enewtype.ISFabu = 0; } if (Request.Form["islimit"] == "on") //0全访问1会员访问 { Enewtype.ISLimit = 1; } else { Enewtype.ISLimit = 0; } Enewtype.Lang = language; bool result = news_type.GetDAL().Add(Enewtype); if (result) { Jscript.RedirectToFrames("Admin_NewsType.aspx"); } else { Jscript.Alert("异常错误,请重试!"); } }
protected void Page_Load(object sender, EventArgs e) { //CheckAuthority("|52,"); if (!IsPostBack) { string StrSQL = "select a.id,b.cn_name + '-' + a.cn_name as lei from tm_path a left join tm_path b on a.myparent=b.id where a.ntype='PhotoList-more' and a.myparent>0 and (a.id in (-1" + Session["AdminPurview"].ToString() + "-1) or a.myParent in (-1" + Session["AdminPurview"].ToString() + "-1)) order by a.sequence"; DataTable dt = da.GetTable(StrSQL); if (dt == null || dt.Rows.Count == 0) { Jscript.Alert("对不起,目前系统没有配置教师分类,请先联系管理员"); Response.End(); } DropDownList1.DataSource = dt; DropDownList1.DataTextField = "lei"; DropDownList1.DataValueField = "ID"; DropDownList1.DataBind(); //修改页面复用 string id = QueryString.GetId; if (id != null) { string sql = "select * from tm_teacher where id=" + id; dt = da.GetTable(sql); if (dt == null || dt.Rows.Count == 0) { Jscript.Alert("请检查该ID合法性!"); Response.End(); } DropDownList1.Items.FindByValue(dt.Rows[0]["pathid"].ToString()).Selected = true; Name_Cn.Text = dt.Rows[0]["Name_Cn"].ToString(); Name_En.Text = dt.Rows[0]["Name_En"].ToString(); Title_cn.Text = dt.Rows[0]["Title_cn"].ToString(); Title_en.Text = dt.Rows[0]["Title_en"].ToString(); Zy_Cn.Text = dt.Rows[0]["Zy_Cn"].ToString(); Zy_en.Text = dt.Rows[0]["Zy_en"].ToString(); Research_cn.Text = dt.Rows[0]["Research_cn"].ToString(); Research_en.Text = dt.Rows[0]["Research_en"].ToString(); Sequence.Text = dt.Rows[0]["Sequence"].ToString(); Editor1.Value = dt.Rows[0]["intro_cn"].ToString(); Editor2.Value = dt.Rows[0]["intro_en"].ToString(); User_name.Text = dt.Rows[0]["User_name"].ToString(); Photo.Text = dt.Rows[0]["Photo"].ToString(); if (dt.Rows[0]["Photo"] == null || dt.Rows[0]["Photo"].ToString() == "") { this.Image1.ImageUrl = "include/images/nonebig.gif"; } else { this.Image1.ImageUrl = Photo.Text; } //Name_Cn.Text = dt.Rows[0]["Name_Cn"].ToString(); } else { string typeid = QueryString.GetTypeid; if (typeid != null) { DropDownList1.Items.FindByValue(id).Selected = true; } } } }
protected void btnImport_ServerClick(object sender, EventArgs e) { if (!fileImport.HasFile || fileImport.FileContent.Length == 0) { Jscript.Alert("请上传填写好内容的模板文件"); return; } string fileName = "~/uploads/file/" + DateTime.Now.ToString("yyyy-MM-ddHHmmss") + ".xls"; try { fileImport.SaveAs(Server.MapPath(fileName)); } catch (Exception ex) { Response.Write("上传文件失败:" + ex.Message); } try { DataSet ds = TFXK.Common.ExcelImport.ExcelToDS(Server.MapPath(fileName)); if (ds != null && ds.Tables[0] != null && ds.Tables[0].Rows != null && ds.Tables[0].Rows.Count > 0) { int recordCount = 0; foreach (DataRow dr in ds.Tables[0].Rows) { TFXK.Model.TestingStudent model = new TFXK.Model.TestingStudent(); model.UserName = dr[0].ToString(); model.UserNamePinyin = dr[1].ToString(); model.Sex = dr[2].ToString().Equals("男") ? 0 : 1; model.IDNumber = dr[3].ToString(); DateTime birthday; DateTime.TryParse(dr[4] + "", out birthday); model.Birthday = birthday; var cmodel = bllCategory.GetModelByName(dr[5] + ""); if (cmodel == null) { continue; } model.ClassID = cmodel.id; model.LevelNum = dr[6] + ""; model.OrgLevel = dr[7] + ""; var countryModel = bllCategory.GetModelByName(dr[8] + ""); if (countryModel == null) { continue; } model.Country = countryModel.id + ""; var EthnicGroupModel = bllCategory.GetModelByName(dr[9] + ""); if (EthnicGroupModel == null) { continue; } model.EthnicGroup = EthnicGroupModel.id + ""; model.CreateTime = DateTime.Now; model.IsPass = 0; model.PlanID = Int32.Parse(Request.QueryString["id"]); model.Score = 0; model.UserHeadImage = ""; model.UserWorkImage = ""; recordCount++; bllTestingStudent.Add(model); } Jscript.Alert("已提交数据" + recordCount + "条"); } else { Jscript.Alert("没有读取到数据"); } } catch (Exception ex) { Jscript.Alert("读取导入数据错误:" + ex.Message); } }