public string Add(HttpContext context) { string formName = context.Request.Params["form_name"].Trim(); string formType = context.Request.Params["form_type"].Trim(); string isVal = context.Request.Params["hval"].Trim(); string remark = context.Request.Params["remark"].Trim(); string content = context.Server.HtmlEncode(context.Request.Params["content1"].Trim()); Model.request_form model = new Model.request_form(); model.form_name = formName; model.rft_sid = int.Parse(formType); model.rf_status = int.Parse(isVal); model.remark = remark; model.content_str = content; return(new BLL.request_form().Add(model)); }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { type = Request["action"] != null ? Request["action"].Trim() : ""; sid = Request["sid"] != null ? Request["sid"].Trim() : ""; if (type != "add") { formModel = new BLL.request_form().GetModel(int.Parse(sid)); content1.Value = Server.HtmlDecode(formModel == null ? "" : formModel.content_str); content = formModel == null ? "" : formModel.content_str;//Server.HtmlDecode(formModel == null ? "" : formModel.content_str); } //SDLX.Common.PublicMethod.CheckSession(); //设置条件字段列表为空 //SDLX.Common.PublicMethod.SetSessionValue("TiaoJiaoList", ""); //SDLX.Common.PublicMethod.BindDDL(this.DropDownList3, SDLX.DBUtility.DbHelperSQL.GetSHSL("select top 1 FormTypeList from ERPFormType")); //绑定表单类别 } }
/* * /// <summary> * /// 分页获取数据列表 * /// </summary> * public DataSet GetList(int PageSize,int PageIndex,string strWhere) * { * SqlParameter[] parameters = { * new SqlParameter("@tblName", SqlDbType.VarChar, 255), * new SqlParameter("@fldName", SqlDbType.VarChar, 255), * new SqlParameter("@PageSize", SqlDbType.Int), * new SqlParameter("@PageIndex", SqlDbType.Int), * new SqlParameter("@IsReCount", SqlDbType.Bit), * new SqlParameter("@OrderType", SqlDbType.Bit), * new SqlParameter("@strWhere", SqlDbType.VarChar,1000), * }; * parameters[0].Value = "request_form"; * parameters[1].Value = "sid"; * parameters[2].Value = PageSize; * parameters[3].Value = PageIndex; * parameters[4].Value = 0; * parameters[5].Value = 0; * parameters[6].Value = strWhere; * return DbHelperSQL.RunProcedure("UP_GetRecordByPage",parameters,"ds"); * }*/ #endregion BasicMethod #region ExtensionMethod #region fu20130713 public bool Edit(List <Model.request_form> insertList, List <Model.request_form> updateList, List <Model.request_form> delList) { ArrayList al = new ArrayList(); StringBuilder sbSql = new StringBuilder(); //删除 for (int i = 0; i < delList.Count; i++) { sbSql = new StringBuilder(); Model.request_form model = delList[i]; sbSql.Append("delete from request_form where sid=" + model.sid); al.Add(sbSql.ToString()); } //修改 for (int i = 0; i < updateList.Count; i++) { sbSql = new StringBuilder(); Model.request_form model = updateList[i]; sbSql.Append("update request_form set form_name = '" + model.form_name.Trim() + "',"); sbSql.Append("rft_sid = '" + model.rft_sid.ToString().Trim() + "',"); sbSql.Append("url = '" + model.url.ToString().Trim() + "',"); sbSql.Append("rf_status = '" + model.rf_status.ToString().Trim() + "'"); sbSql.Append(" where sid = '" + model.sid.ToString().Trim() + "'"); al.Add(sbSql.ToString()); } //添加 for (int i = 0; i < insertList.Count; i++) { sbSql = new StringBuilder(); Model.request_form model = insertList[i]; sbSql.Append("insert into request_form(form_name, rft_sid,url,rf_status"); sbSql.Append(")values("); sbSql.Append("'" + model.form_name.Trim() + "','" + model.rft_sid.ToString().Trim() + "','" + model.url.ToString().Trim() + "','" + model.rf_status.ToString().Trim() + "'"); sbSql.Append(")"); al.Add(sbSql.ToString()); } DbHelperSQL.ExecuteSqlTran(al); return(true); }