protected void btDo_Click(object sender, EventArgs e) { try { this.dbo = new DB_OPT(); this.dbo.Open(); this.drpm = new DataRowPowerDal(); this.drpm.Name = this.txtname.Text.Trim(); this.drpm.PowerCode = this.txtpowercode.Text.Trim(); this.drpm.TableName = this.ddltablename.SelectedValue; this.drpm.ColumnName = this.ddlColumnName.SelectedValue.Split(new char[] { '|' })[0]; this.drpm.TJType = this.ddlColumnName.SelectedValue.Split(new char[] { '|' })[1]; this.drpm.strWhere = this.GetStrWhere(); this.drpm.Discription = this.txtDiscription.Text.Trim(); if (this.ifadd.Value == "0") { this.drpm.PK = this.pk.Value; this.drpm.Update(this.dbo); Const.DoSuccessOpen("修改成功!", this.Page); } else { this.drpm.Add(this.dbo); Const.DoSuccessOpen("添加成功!", this.Page); } } catch (Exception exception) { Const.ShowMessage("操作失败!" + exception.Message, this.Page); } }
protected void gvResult_RowDeleting(object sender, GridViewDeleteEventArgs e) { try { this.dbo = new DB_OPT(); this.dbo.Open(); string str = this.gvResult.DataKeys[e.RowIndex].Value.ToString(); this.drpm = new DataRowPowerDal(); this.drpm.PK = str; this.drpm.Delete(this.dbo); this.ShowData(""); Const.ShowMessage("删除成功!", this.Page); } catch (Exception exception) { Const.OpenErrorPage("删除失败!" + exception.Message, this.Page); } finally { this.dbo.Close(); } }
public override DataRowPowerModel[] GetModels(DB_OPT dbo) { DataRowPowerModel[] modelArray = null; StringBuilder builder = new StringBuilder(); builder.Append("select "); builder.Append(" PK,Name,PowerCode,TJType,TableName,ColumnName,strWhere,Discription "); builder.Append(" from DataRowPower "); builder.Append(" where TableName='" + base.TableName + "'"); DataSet set = dbo.BackDataSet(builder.ToString(), null); if (set.Tables[0].Rows.Count > 0) { modelArray = new DataRowPowerModel[set.Tables[0].Rows.Count]; for (int i = 0; i < set.Tables[0].Rows.Count; i++) { modelArray[i] = new DataRowPowerModel(); modelArray[i].Name = set.Tables[0].Rows[i]["Name"].ToString(); modelArray[i].PowerCode = set.Tables[0].Rows[i]["PowerCode"].ToString(); modelArray[i].TJType = set.Tables[0].Rows[i]["TJType"].ToString(); modelArray[i].TableName = set.Tables[0].Rows[i]["TableName"].ToString(); modelArray[i].ColumnName = set.Tables[0].Rows[i]["ColumnName"].ToString(); modelArray[i].strWhere = set.Tables[0].Rows[i]["strWhere"].ToString(); modelArray[i].Discription = set.Tables[0].Rows[i]["Discription"].ToString(); modelArray[i].CodeAndWhere = set.Tables[0].Rows[i]["PowerCode"].ToString() + "|" + set.Tables[0].Rows[i]["strWhere"].ToString(); } } return modelArray; }
protected void ddltablename_SelectedIndexChanged(object sender, EventArgs e) { try { this.lballqxxx.Items.Clear(); this.lbxzqx.Items.Clear(); this.dbo = new DB_OPT(); this.dbo.Open(); this.drpm = new DataRowPowerDal(); this.drpm.TableName = this.ddltablename.SelectedValue; DataRowPowerModel[] models = this.drpm.GetModels(this.dbo); if (models != null) { this.lballqxxx.DataSource = models; this.lballqxxx.DataTextField = "Name"; this.lballqxxx.DataValueField = "CodeAndWhere"; this.lballqxxx.DataBind(); } } catch (Exception) { } }
private void ShowData(string str) { try { this.dbo = new DB_OPT(); this.dbo.Open(); this.drpm = new DataRowPowerDal(); DataSet set = this.pagesize.pagesize("*", "DataRowPower", str, "PK", " order by PowerCode ", this.pageind, 10, out this.count); if (set != null) { this.gvResult.DataSource = set.Tables[0].DefaultView; this.gvResult.DataBind(); } } catch (Exception exception) { Const.OpenErrorPage("获取数据失败,请联系管理员!" + exception.Message, this.Page); } finally { this.dbo.Close(); } }
protected void Page_Load(object sender, EventArgs e) { if (!this.Page.IsPostBack) { try { this.dbo = new DB_OPT(); this.dbo.Open(); this.ShowZDData(); if ((base.Request.QueryString["type"] != null) && (base.Request.QueryString["type"].ToString() == "Update")) { this.ifadd.Value = "0"; this.btDo.Text = "修改"; this.pk.Value = base.Request.QueryString["PK"].ToString(); this.drpm = new DataRowPowerDal(); this.drpm.PK = this.pk.Value; this.drpm.GetModel(this.dbo); this.SetValue(); } else { this.ddltablename_SelectedIndexChanged(sender, e); this.ddlColumnName_SelectedIndexChanged(sender, e); } } catch (Exception exception) { Const.OpenErrorPage("获取数据失败,请联系管理员!" + exception.Message, this.Page); } finally { this.dbo.Close(); } } }