protected void btnSave_Click(object sender, EventArgs e) { model.flag_name = KillSqlIn.Form_ReplaceByString(Request.Form["txtTitle"], 200); //string BackUrl = "CategoryTree.aspx"; if (_id != "0") { model.flag_id = _id; bll.Update(model); ClientScript.RegisterStartupScript(this.GetType(), "js", "<script>alert('修改成功!');layer_close_refresh();</script>"); //JSUtility.AlertAndRedirect("修改成功!", BackUrl); /*日志归档*/ //string sql1 = @"select Title as title from dbo.T_Category where CategoryId = (" + _ACid + ")"; //string function = "修改"; //PubFunction.InsertLog1("文章类别管理", sql1, function); } else { model.if_use = 1; model.flag_id = IdCreator.CreateId("T_Base_Flag", "flag_id"); bll.Add(model); JSUtility.AlertAndRedirect("添加成功,请继续添加!", Request.RawUrl.ToString()); /*日志归档*/ //string sql1 = @"select Title as title from dbo.T_Category where CategoryId = (select top 1 CategoryId from T_Category order by CategoryId desc)"; //string function = "添加"; //PubFunction.InsertLog1("文章类别管理", sql1, function); } }
protected void btnSave_Click(object sender, EventArgs e) { FillFeild(); if (_id != "0") { bll.Update(model); ClientScript.RegisterStartupScript(this.GetType(), "js", "<script>alert('修改成功!');layer_close_refresh();</script>"); //JSUtility.AlertAndRedirect("修改成功!", BackUrl); /*日志归档*/ //string sql1 = @"select Title as title from dbo.T_Category where CategoryId = (" + _ACid + ")"; //string function = "修改"; //PubFunction.InsertLog1("文章类别管理", sql1, function); } else { bll.Add(model); JSUtility.AlertAndRedirect("添加成功,请继续添加!", Request.RawUrl.ToString()); /*日志归档*/ //string sql1 = @"select Title as title from dbo.T_Category where CategoryId = (select top 1 CategoryId from T_Category order by CategoryId desc)"; //string function = "添加"; //PubFunction.InsertLog1("文章类别管理", sql1, function); } }
/// <summary> /// 确定提交 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSubmit_Click(object sender, EventArgs e) { model = GetModel(); if (_Pid != "SysError") { if (!_Pid.Equals(model.area_id)) { bll.UpdateId(model.area_id, _Pid); //先更新编号 } if (bll.Update(model)) { adohelper.ExecuteSqlNonQuery("update T_Base_Area set ishot=" + (this.cbHot.Checked ? "1" : "0") + " where area_id='" + model.area_id + "'"); this.ClientScript.RegisterStartupScript(this.GetType(), "close", "<script>alert('修改成功');layer_close_refresh();</script>"); } } else { model.area_id = IdCreator.CreateId("T_Base_Area", "area_id"); if (bll.Add(model)) { adohelper.ExecuteSqlNonQuery("update T_Base_Area set ishot=" + (this.cbHot.Checked ? "1" : "0") + " where area_id='" + model.area_id + "'"); JSUtility.AlertAndRedirect("添加成功,请继续添加!", Request.RawUrl.ToString()); } } }
/// <summary> /// 确定提交 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSubmit_Click(object sender, EventArgs e) { model.Title = KillSqlIn.Form_ReplaceByString(this.txtTitle.Text, 100); model.DisplayMode = Convert.ToInt32(this.RadioButtonList1.SelectedValue); model.CategoryId = Convert.ToInt32(this.DrCategory.SelectedValue); model.Link = KillSqlIn.Form_ReplaceByString(this.txtLink.Text.Trim(), 100); model.sort = Convert.ToInt32(KillSqlIn.Form_ReplaceByString(this.txtSort.Text, 10)); model.StartTime = !string.IsNullOrEmpty(this.txtStartTime.Text) ? Convert.ToDateTime(this.txtStartTime.Text) : System.DateTime.Now; model.EndTime = !string.IsNullOrEmpty(this.txtEndTime.Text) ? Convert.ToDateTime(this.txtEndTime.Text) : System.DateTime.Now.AddDays(7); #region 保存图片 if (!this.picUpload.Value.Equals("")) { string FileTZM = this.picUpload.PostedFile.FileName.Substring(this.picUpload.PostedFile.FileName.LastIndexOf(".") + 1);//得到文件的扩展名 if (!IsPic(FileTZM.ToLower())) { JSUtility.Alert("上传图片格式不正确!"); return; } if (this.picUpload.PostedFile.ContentLength > 1048576) { JSUtility.Alert("上传图片过大!"); return; } Random rnd = new Random(); string UpLoadFileTime = DateTime.Now.ToString("HHmmss") + rnd.Next(9999).ToString("0000"); //生成一个新的数图片名称 string fileName = UpLoadFileTime + "." + FileTZM; //产生上传图片的名称 if (!Directory.Exists(Request.MapPath("~/upload/Link/"))) { Directory.CreateDirectory(Request.MapPath("~/upload/Link/")); } string Url = Request.MapPath("~/upload/Link/" + fileName); picUpload.PostedFile.SaveAs(Url); model.Image = "/upload/Link/" + fileName; } else { model.Image = ViewState["Image"] == null ? "" : ViewState["Image"].ToString(); } #endregion if (_Pid != "SysError") { model.AdId = Convert.ToInt32(_Pid); if (bll.Update(model)) { this.ClientScript.RegisterStartupScript(this.GetType(), "close", "<script>alert('修改成功');layer_close_refresh();</script>"); } } else { if (bll.Add(model) != 0) { JSUtility.AlertAndRedirect("添加成功,请继续添加!", Request.RawUrl.ToString()); } } }
/// <summary> /// 确定提交 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSubmit_Click(object sender, EventArgs e) { model = GetModel(); if (_Pid != "SysError") { if (bll.Update(model)) { this.ClientScript.RegisterStartupScript(this.GetType(), "close", "<script>alert('修改成功');layer_close_refresh();</script>"); } } else { if (bll.Add(model) != null) { JSUtility.AlertAndRedirect("添加成功,请继续添加!", Request.RawUrl.ToString()); } } }
/// <summary> /// 确定提交 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSubmit_Click(object sender, EventArgs e) { string strError = Validates(); if (strError != "") { this.ClientScript.RegisterStartupScript(this.GetType(), "msg", "<script>alert('" + strError + "');</script>"); return; } model.CategoryId = Convert.ToInt32(this.ddlType.SelectedValue); model.Titie = SafeRequest.GetFormString("txtTitle"); model.ReleaseDate = Convert.ToDateTime(this.txtReleaseDate.Text.Trim()); model.AddedDate = System.DateTime.Now; model.ExpireDate = System.DateTime.Now; model.Body = SafeRequest.GetFormString("fckBody"); model.Approved = SafeRequest.GetFormInt("radioApproved", 0); model.AddedUserId = Convert.ToInt32(this.UserId);//默认登录进来人的编号 if (_Pid != "") { model.ArticleId = Convert.ToInt32(_Pid); if (bll.Update(model)) { this.ClientScript.RegisterStartupScript(this.GetType(), "close", "<script>alert('修改成功');layer_close_refresh();</script>"); } } else { int ret = bll.Add(model); if (ret == -2) { this.ClientScript.RegisterStartupScript(this.GetType(), "msg", "<Script>alert('该类别只允许添加1篇文章,请到列表中查找然后修改!');</Script>"); } else { if (ret > 0) { JSUtility.AlertAndRedirect("添加成功,请继续添加!", Request.RawUrl.ToString()); } } } }
protected void btnSubmit_Click(object sender, EventArgs e) { DataSet ds = new MemberInfoBLL().GetList("memberName='" + this.txtMemberId.Value + "'"); int id = 0; if (ds.Tables[0].Rows.Count > 0) { id = Convert.ToInt32(ds.Tables[0].Rows[0]["memberId"].ToString()); } model.memberId = id;// Convert.ToInt32(KillSqlIn.Form_ReplaceByString(this.txtMemberId.Value, 10)); model.money = Convert.ToDecimal(KillSqlIn.Form_ReplaceByString(this.txtMoney.Text, 10)); model.moneyType = KillSqlIn.Form_ReplaceByString(this.ddlMoneyType.SelectedValue, 20); model.remarks = KillSqlIn.Form_ReplaceByString(this.txtRemarks.Text, 200); model.addPerson = KillSqlIn.Form_ReplaceByString(this.txtAddPerson.Text, 20); model.addTime = Convert.ToDateTime(this.txtReleaseDate.Value.Trim()); model.shFlag = 0; string BackUrl = "MemberCZRecordList.aspx?PageIndex=" + PageIndex + ""; if (_mid != "") { model.sysnumber = _mid; bll.Update(model); /*日志归档*/ string sql = @"select l.memberId as title from T_Member_AccountRecord l where sysnumber='" + this._mid + "'"; PubFunction.InsertLog("业务管理", "会员列表", "会员充值列表", "修改", sql, _mid); JSUtility.AlertAndRedirect("修改成功!", BackUrl); } else { int i = bll.Add(model); /*日志归档*/ string sql = @"select l.memberId as title from T_Member_AccountRecord l where sysnumber='" + i.ToString() + "'"; PubFunction.InsertLog("业务管理", "会员列表", "会员充值列表", "添加", sql, i.ToString()); JSUtility.AlertAndRedirect("添加成功,请继续添加!", Request.RawUrl.ToString()); } }
/// <summary> /// 确定提交 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSubmit_Click(object sender, EventArgs e) { model = GetModel(); if (_Pid != "SysError") { if (!_Pid.Equals(model.Market_id)) { bll.UpdateId(model.Market_id, _Pid); //先更新编号 } if (bll.Update(model)) { this.ClientScript.RegisterStartupScript(this.GetType(), "close", "<script>alert('修改成功');layer_close_refresh();</script>"); } } else { model.Market_id = IdCreator.CreateId("T_Base_Market", "Market_id"); if (bll.Add(model)) { JSUtility.AlertAndRedirect("添加成功,请继续添加!", Request.RawUrl.ToString()); } } }
protected void btnSave_Click(object sender, EventArgs e) { model.CategoryName = KillSqlIn.Form_ReplaceByString(Request.Form["txtTitle"], 200); model.Sort = Convert.ToInt32(KillSqlIn.Form_ReplaceByNumber(Request.Form["txtSort"], 4)); model.AddedUserId = Convert.ToInt32(_userId); model.AddedDate = Convert.ToDateTime(this.txtAddDate.Text); model.ParentCategoryId = Convert.ToInt32(this.ddlParentCategory.SelectedValue); model.Type = 0;//0:文章 1:新闻 //string BackUrl = "CategoryTree.aspx"; if (_ACid != "0") { model.CategoryId = Convert.ToInt32(_ACid); bll.Update(model); ClientScript.RegisterStartupScript(this.GetType(), "js", "<script>alert('修改成功!');layer_close_refresh();</script>"); //JSUtility.AlertAndRedirect("修改成功!", BackUrl); /*日志归档*/ //string sql1 = @"select Title as title from dbo.T_Category where CategoryId = (" + _ACid + ")"; //string function = "修改"; //PubFunction.InsertLog1("文章类别管理", sql1, function); } else { model.AddedDate = DateTime.Now; int id = bll.Add(model); bll.UpdateCategoryPermission(id.ToString()); JSUtility.AlertAndRedirect("添加成功,请继续添加!", Request.RawUrl.ToString()); /*日志归档*/ //string sql1 = @"select Title as title from dbo.T_Category where CategoryId = (select top 1 CategoryId from T_Category order by CategoryId desc)"; //string function = "添加"; //PubFunction.InsertLog1("文章类别管理", sql1, function); } }
/// <summary> /// 确定提交 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSubmit_Click(object sender, EventArgs e) { model = GetModel(); if (_Pid != "SysError") { if (!this.hidBuildingsId.Value.Equals(ViewState["Building_id"].ToString())) //修改了小区 { if (this.hidBuildingsId.Value.Contains("|")) //修改为多个小区,实为添加 { string[] ids = this.hidBuildingsId.Value.Split('|'); foreach (string s in ids) { if (bll.GetList(" Building_id = '" + s + "' and Market_id = '" + model.Market_id + "' ").Tables[0].Rows.Count <= 0) { model.BuildingToMarket_id = System.Guid.NewGuid().ToString(); model.Building_id = s; if (bll.Add(model)) { this.ClientScript.RegisterStartupScript(this.GetType(), "close", "<script>alert('修改成功');layer_close_refresh();</script>"); } } } } else//修改为一个小区 { if (bll.GetList(" Building_id = '" + this.hidBuildingsId.Value + "' and Market_id = '" + model.Market_id + "' ").Tables[0].Rows.Count <= 0) {//修改的新关系不存在 model.BuildingToMarket_id = ViewState["id"].ToString(); model.Building_id = this.hidBuildingsId.Value; if (bll.Update(model)) { this.ClientScript.RegisterStartupScript(this.GetType(), "close", "<script>alert('修改成功');layer_close_refresh();</script>"); } } else { this.ClientScript.RegisterStartupScript(this.GetType(), "close", "<script>alert('该关系已经存在!');</script>"); } } } else { model.BuildingToMarket_id = ViewState["id"].ToString(); model.Building_id = this.hidBuildingsId.Value; if (bll.Update(model)) { this.ClientScript.RegisterStartupScript(this.GetType(), "close", "<script>alert('修改成功');layer_close_refresh();</script>"); } } } else { string BuildingsId = this.hidBuildingsId.Value; if (BuildingsId.Contains("|")) { string[] ids = BuildingsId.Split('|'); foreach (string s in ids) { if (bll.GetList(" Building_id = '" + s + "' and Market_id = '" + model.Market_id + "' ").Tables[0].Rows.Count <= 0) { model.BuildingToMarket_id = System.Guid.NewGuid().ToString(); model.Building_id = s; if (bll.Add(model)) { JSUtility.AlertAndRedirect("添加成功,请继续添加!", Request.RawUrl.ToString()); } } } } else { model.BuildingToMarket_id = System.Guid.NewGuid().ToString(); model.Building_id = BuildingsId; if (bll.Add(model)) { JSUtility.AlertAndRedirect("添加成功,请继续添加!", Request.RawUrl.ToString()); } } } }
/// <summary> /// 确定提交 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSubmit_Click(object sender, EventArgs e) { string strError = Validates(); if (!string.IsNullOrEmpty(strError)) { this.ClientScript.RegisterStartupScript(this.GetType(), "msg", "<script>alert('" + strError + "');</script>"); return; } model.CategoryId = Convert.ToInt32(this.ddlType.SelectedValue); model.Title = SafeRequest.GetFormString("txtTitle"); model.SubHead = SafeRequest.GetFormString("txtSubHead"); model.PublicationUnit = SafeRequest.GetFormString("txtUnit"); model.FromSource = SafeRequest.GetFormString("txtFromSouce"); // model.KeyWord = SafeRequest.GetFormString("txtKeyWord"); model.ReleaseDate = !string.IsNullOrEmpty(this.txtReleaseDate.Text.Trim()) ? Convert.ToDateTime(this.txtReleaseDate.Text.Trim()) : System.DateTime.Now; model.IsTop = 0; //SafeRequest.GetFormInt("radioTopList", 0); model.IndexCommend = 0; //SafeRequest.GetFormInt("radioIndexCommentList", 0); model.HotPic = SafeRequest.GetFormString("radioHotList"); model.HotDays = SafeRequest.GetFormInt("txtHotDays", 3); //model.ArticleType = SafeRequest.GetFormInt("radioArticleTypeList", 0); model.Body = this.fckBody.Text; //追加底部 if (cbFooter.Checked) { if (model.Body.IndexOf("start_auto_footer") == -1 && model.Body.IndexOf("end_auto_footer") == -1) { string autoFooter = "<!--start_auto_footer-->" + this.fckBodyFooter.Text + "<!--end_auto_footer-->"; model.Body = model.Body + autoFooter; } //写入缓存 NG.CachHelper.Redis.RedisHelper redis = new NG.CachHelper.Redis.RedisHelper(); redis.SetStringCash("News_Footer", this.fckBodyFooter.Text); redis.Close(); } // model.IsComment = 0;// SafeRequest.GetFormInt("radioIsComment", 0); model.Approved = SafeRequest.GetFormInt("radioApproved", 0); model.Sort = SafeRequest.GetFormInt("txtSort", 99); model.AddedDate = System.DateTime.Now; model.ExpireDate = System.DateTime.Now; model.ViewCount = 0; // model.IsScrool = 0; // model.AddedUserId = Convert.ToInt32(_userId);//默认登录进来人的编号 model.AddedUserId = 1; //~/upload/News/ #region 保存图片 if (!this.picUpload.Value.Equals("") && this.picUpload.PostedFile.ContentLength > 10) { string FileTZM = this.picUpload.PostedFile.FileName.Substring(this.picUpload.PostedFile.FileName.LastIndexOf(".") + 1);//得到文件的扩展名 if (!IsPic(FileTZM.ToLower())) { JSUtility.Alert("上传图片格式不正确!"); return; } if (this.picUpload.PostedFile.ContentLength > 1048576) { JSUtility.Alert("上传图片过大!"); return; } Random rnd = new Random(); string UpLoadFileTime = DateTime.Now.ToString("yyMMddHHmmss") + rnd.Next(9999).ToString("0000"); //生成一个新的数图片名称 string fileName = UpLoadFileTime + "." + FileTZM; //产生上传图片的名称 if (!Directory.Exists(Request.MapPath("~/upload/News/"))) { Directory.CreateDirectory(Request.MapPath("~/upload/News/")); } string Url = Request.MapPath("~/upload/News/" + fileName); picUpload.PostedFile.SaveAs(Url); model.ImgLink = "/upload/News/" + fileName; } else { model.ImgLink = ViewState["ImgLink"].ToString(); } #endregion if (_Pid != "") { model.NewsID = _Pid; if (bll.Update(model)) { this.ClientScript.RegisterStartupScript(this.GetType(), "close", "<script>alert('修改成功');layer_close_refresh();</script>"); } } else { model.NewsID = IdCreator.CreateId("T_News", "NewsId"); if (bll.Add(model)) { JSUtility.AlertAndRedirect("添加成功,请继续添加!", Request.RawUrl.ToString()); } } }
//保存 protected void LinkButton1_Click(object sender, EventArgs e) { model.Title = SafeRequest.GetFormString("txtTitle"); model.DisplayMode = SafeRequest.GetFormInt("RadioButtonList1", 0); model.CategoryId = SafeRequest.GetFormInt("DrCategory", 0); model.Link = txtLink.Text.Trim(); model.Sort = SafeRequest.GetFormInt("txtSort", 0); #region 保存图片 if (!this.picUpload.Value.Equals("")) { string UploadFileLastName = this.picUpload.PostedFile.FileName.Substring(this.picUpload.PostedFile.FileName.LastIndexOf(".") + 1);//得到文件的扩展名 if (!PubFunction.IsPic(UploadFileLastName)) { JSUtility.Alert("上传图片格式不正确!"); return; } Random rnd = new Random(); string UpLoadFileTime = DateTime.Now.ToString("HHmmss") + rnd.Next(9999).ToString("0000"); //生成一个新的数图片名称 string fileName = UpLoadFileTime + "." + UploadFileLastName; //产生上传图片的名称 string SaveFile = DateTime.Now.ToString("yyyy/MM/dd/").Replace("-", "/"); #region 设置保存的路径 string SevedDirectory = System.Web.VirtualPathUtility.Combine(mainPath, SaveFile); string phydic = MapPath(SevedDirectory); if (!System.IO.Directory.Exists(phydic)) { System.IO.Directory.CreateDirectory(phydic); } #endregion this.picUpload.PostedFile.SaveAs(phydic + "" + fileName); string fckimg = string.Empty; string source = string.Empty; fckimg = "<a href='" + this.ResolveUrl(SevedDirectory + fileName) + "' target='_blank' id='upannexx'>" + fileName + "</a>"; source = this.ResolveUrl(SevedDirectory + fileName); model.Image = SaveFile + fileName; } else { model.Image = ViewState["ImgLink"].ToString(); } #endregion string BackUrl = "LinkList.aspx?PageIndex=" + PageIndex; if (_Lid != "0") { model.LinkId = Convert.ToInt32(_Lid); bll.Update(model); ClientScript.RegisterStartupScript(this.GetType(), "close", "<script>alert('修改成功');layer_close_refresh();</script>"); //状态 if (Session["LinkStatus_Hashtable"] != null) { Hashtable hTable = (Hashtable)Session["LinkStatus_Hashtable"]; hTable["ReadSessionStatus"] = "1"; Session["LinkStatus_Hashtable"] = hTable; } /*日志归档*/ string sql = @"select l.title from T_link l where linkid=" + this._Lid + ""; PubFunction.InsertLog("其它管理", "友情链接", "友情链接列表", "修改", sql, _Lid); } else { int i = bll.Add(model); JSUtility.AlertAndRedirect("添加成功,请继续添加!", Request.RawUrl.ToString()); /*日志归档*/ string sql = @"select l.title from T_link l where linkid=" + i.ToString() + ""; PubFunction.InsertLog("其它管理", "友情链接", "友情链接列表", "添加", sql, i.ToString()); } }