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.drpim = new DataRowPowerItemDal();
this.drpim.PK = str;
this.drpim.Delete(this.dbo);
this.ShowData("");
Const.ShowMessage("删除成功！", this.Page);
}
catch (Exception exception)
{
Const.OpenErrorPage("删除失败！" + exception.Message, this.Page);
}
finally
{
this.dbo.Close();
}
}
protected void btDo_Click(object sender, EventArgs e)
{
try
{
this.dbo = new DB_OPT();
this.dbo.Open();
this.drpim = new DataRowPowerItemDal();
this.drpim.Name = this.txtname.Text.Trim();
this.drpim.PowerCode = this.txtpowercode.Text.Trim();
this.drpim.TableName = this.ddltablename.SelectedValue;
string qxlist = "";
string strwhere = "";
this.GetStrWhere(out qxlist, out strwhere);
this.drpim.Discription = this.txtDiscription.Text.Trim();
this.drpim.QXList = qxlist;
this.drpim.strWhere = strwhere;
if (this.ifadd.Value == "0")
{
this.drpim.PK = this.pk.Value;
this.drpim.Update(this.dbo);
Const.DoSuccessOpen("修改成功！", this.Page);
}
else
{
this.drpim.Add(this.dbo);
Const.DoSuccessOpen("添加成功！", this.Page);
}
}
catch (Exception exception)
{
Const.OpenErrorPage("操作失败！" + exception.Message, this.Page);
}
}
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.drpim = new DataRowPowerItemDal();
this.drpim.PK = this.pk.Value;
this.drpim.GetModel(this.dbo);
this.SetValue(sender, e);
}
else
{
this.ddltablename_SelectedIndexChanged(sender, e);
}
}
catch (Exception exception)
{
Const.OpenErrorPage("获取数据失败，请联系管理员！" + exception.Message, this.Page);
}
finally
{
this.dbo.Close();
}
}
}
private void ShowData(string str)
{
try
{
this.dbo = new DB_OPT();
this.dbo.Open();
this.drpim = new DataRowPowerItemDal();
DataSet set = this.pagesize.pagesize("*", "DataRowPowerItem", 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();
}
}
public override DataRowPowerItemModel[] GetModels(DB_OPT dbo)
{
DataRowPowerItemModel[] modelArray = null;
StringBuilder builder = new StringBuilder();
builder.Append("select ");
builder.Append(" PK,Name,PowerCode,TableName,ColumnName,QXList,strWhere,ShowTJ,Discription ");
builder.Append(" from db_DataRowPowerItem ");
builder.Append(" where TableName='" + base.TableName + "'");
DataSet set = dbo.BackDataSet(builder.ToString(), null);
if (set.Tables[0].Rows.Count > 0)
{
modelArray = new DataRowPowerItemModel[set.Tables[0].Rows.Count];
for (int i = 0; i < set.Tables[0].Rows.Count; i++)
{
modelArray[i] = new DataRowPowerItemModel();
modelArray[i].Name = set.Tables[0].Rows[i]["Name"].ToString();
modelArray[i].PowerCode = set.Tables[0].Rows[i]["PowerCode"].ToString();
modelArray[i].TableName = set.Tables[0].Rows[i]["TableName"].ToString();
modelArray[i].ColumnName = set.Tables[0].Rows[i]["ColumnName"].ToString();
modelArray[i].ColumnName = set.Tables[0].Rows[i]["QXList"].ToString();
modelArray[i].strWhere = set.Tables[0].Rows[i]["strWhere"].ToString();
modelArray[i].ShowTJ = set.Tables[0].Rows[i]["ShowTJ"].ToString();
modelArray[i].Discription = set.Tables[0].Rows[i]["Discription"].ToString();
}
}
return modelArray;
}
