protected void btnDel_Click(object sender, EventArgs e) { bool isOk = true; string id = Page.Request.Form[name + Constants.MYQUERY_SELECTID]; if (!String.IsNullOrEmpty(id)) { try { isOk = Template.DelSubjectData(id, CurrentUser.Id); } catch (Exception ex) { isOk = false; Logger.Error("删除查询方案失败", ex); RedirectError("删除查询方案失败,请稍候再试。原因:" + ex.Message); } if (!isOk) { Alert("您不能删除别人的查询方案"); } } else { isOk = false; Alert("请先选中一个方案,再点[使用]"); } MyInputs1.DataBind(); MyGridView1.DataBind(Template.GetSubjectData(name, MyInputs1.Columns, CurrentUser.Id)); }
protected void btnAdd_Click(object sender, EventArgs e) { bool isOk = true; try { //添加 MySqlParameters mySqlParameters = new MySqlParameters(null); mySqlParameters.Add("name", name, null); mySqlParameters.Add("title", txtName.Text, null); mySqlParameters.Add("userid", ckbPrivate.Checked ? CurrentUser.Id : "public", null); mySqlParameters.Add("creater", CurrentUser.Id, null); isOk = Template.SaveSubjectData(mySqlParameters, MyInputs1.Columns); } catch (Exception ex) { isOk = false; Logger.Error("添加查询方案失败", ex); RedirectError("添加失败,请稍候再试。原因:" + ex.Message); return; } if (isOk) { Close(null, false); } else { MyInputs1.DataBind(); MyGridView1.DataBind(Template.GetSubjectData(name, MyInputs1.Columns, CurrentUser.Id)); } }
/// <summary> /// 使用 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnUse_Click(object sender, EventArgs e) { string id = Page.Request.Form[name + Constants.MYQUERY_SELECTID]; if (!String.IsNullOrEmpty(id)) { try { Template.SetSubjectParameters(sqlParameters, MyInputs1.Columns, id); } catch (Exception ex) { Logger.Error("获取方案条件失败", ex); } Close(null); } else { MyInputs1.DataBind(); MyGridView1.DataBind(Template.GetSubjectData(name, MyInputs1.Columns, CurrentUser.Id)); Alert("请先选中一个方案,再点[使用]"); } }
protected void Page_Load(object sender, EventArgs e) { name = QueryString[Constants.MYQUERY_NAME]; //仅首次加载初始化 if (String.IsNullOrEmpty(name)) { Close("模板运行需要传递n参数,即对应的查询定制xml的名字(不含后缀)"); return; } if (!Page.IsPostBack) { btnUse.Attributes.Add("onclick", "if (getSelectId('" + name + Constants.MYQUERY_SELECTID + "')) {return true;} else {alert('请先选中一个方案,再点[使用]');return false;}"); btnDel.Attributes.Add("onclick", "if (getSelectId('" + name + Constants.MYQUERY_SELECTID + "')) {return true;} else {alert('请先选中一个方案,再点[删除]');return false;}"); } //初始化参数 MyInputs1.InputsType = MyInputsType.Detail; //初始化样式 Template.SetGridViewStyle(MyGridView1); XmlDocument doc = null; //xml获取和基本判断 try { doc = FromXml.GetXml(name); } catch (Exception ex) { Logger.Error("读取xml错误", ex); RedirectError("初始化失败,请稍候再试。原因:" + ex.Message); return; } //开始加载xml XmlNode myquery = XmlHelper.GetNode(doc.DocumentElement, "myquery"); if (myquery == null) { Close("xml文件不是系统提供的定制查询配置文件"); return; } //设置分页属性 FromXml.SetGridViewPage(null, MyGridView1); try { //获得数据来源 DataFrom dataFrom = new DataFrom(myquery, CurrentUser, QueryString); MyGridView1.Columns = FromXml.GetSubjectColumns(myquery, dataFrom, MyInputs1, sqlParameters); MyGridView1.KeyColumnNames = "subject-id"; if (!Page.IsPostBack) { MyGridView1.DataBind(Template.GetSubjectData(name, MyInputs1.Columns, CurrentUser.Id)); MyInputs1.DataBind(); } } catch (Exception ex) { Logger.Error("初始化失败", ex); RedirectError("初始化失败,请稍候再试。原因:" + ex.Message); } }
/// <summary> /// 排序回发事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void MyGridView1_Sorting(object sender, GridViewSortEventArgs e) { MyGridView1.DataSource = Template.GetSubjectData(name, MyInputs1.Columns, CurrentUser.Id); MyInputs1.DataBind(); }
/// <summary> /// 页变更回发事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void MyGridView1_PageIndexChanged(object sender, EventArgs e) { MyGridView1.DataSource = Template.GetSubjectData(name, MyInputs1.Columns, CurrentUser.Id); MyInputs1.DataBind(); }