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