/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Entity.BASE_AUTHORITYDIR entity)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Base_AuthorityDir(");
strSql.Append("AuthorityName,AuthorityTag,AuthorityDescription,AuthorityOrder");
strSql.Append(") values (");
strSql.Append("@AuthorityName,@AuthorityTag,@AuthorityDescription,@AuthorityOrder");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@AuthorityName", SqlDbType.NVarChar, 30),
new SqlParameter("@AuthorityTag", SqlDbType.NVarChar, 50),
new SqlParameter("@AuthorityDescription", SqlDbType.NVarChar, 50),
new SqlParameter("@AuthorityOrder", SqlDbType.Int, 4)
};
parameters[0].Value = entity.AuthorityName;
parameters[1].Value = entity.AuthorityTag;
parameters[2].Value = entity.AuthorityDescription;
parameters[3].Value = entity.AuthorityOrder;
object obj = SqlServerHelper.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 添加数据
/// </summary>
protected void btn_add_Click(object sender, EventArgs e)
{
if (txt_Name.Text.Trim() != "" || txt_Tag.Text.Trim() != "" || txt_order.Text.Trim() != "" || Smart.Utility.TypeParse.IsUnsign(txt_order.Text.Trim()))
{
Entity.BASE_AUTHORITYDIR model = new Entity.BASE_AUTHORITYDIR();
model.AuthorityName = txt_Name.Text.Trim();
model.AuthorityTag = txt_Tag.Text.Trim().ToUpper();
model.AuthorityDescription = txt_Description.Text.Trim();
model.AuthorityOrder = int.Parse(txt_order.Text.Trim());
if (!bll.Exists(txt_Tag.Text.Trim()))
{
if (bll.CreateAuthority(model))
{
txt_Name.Text = "";
txt_Tag.Text = "";
txt_Description.Text = "";
txt_order.Text = "";
BindOrder();
}
else
{
strinfo.InnerHtml = Smart.Utility.JScript.errinfo("新增操作失败!");
strinfo.Visible = true;
}
}
else
{
strinfo.InnerHtml = Smart.Utility.JScript.errinfo("标识已经存在，请更换后重试!");
strinfo.Visible = true;
}
}
}
/// <summary>
/// 更新指定的权限
/// </summary>
/// <param name="model">权限实体类</param>
/// <returns></returns>
public bool UpdateAuthority(Entity.BASE_AUTHORITYDIR model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Base_AuthorityDir set ");
strSql.Append("AuthorityName=@AuthorityName,");
strSql.Append("AuthorityTag=@AuthorityTag,");
strSql.Append("AuthorityDescription=@AuthorityDescription,");
strSql.Append("AuthorityOrder=@AuthorityOrder");
strSql.Append(" where AuthorityID=@AuthorityID ");
SqlParameter[] parameters =
{
new SqlParameter("@AuthorityID", SqlDbType.Int, 4),
new SqlParameter("@AuthorityName", SqlDbType.NVarChar, 30),
new SqlParameter("@AuthorityTag", SqlDbType.NVarChar, 50),
new SqlParameter("@AuthorityDescription", SqlDbType.NVarChar, 50),
new SqlParameter("@AuthorityOrder", SqlDbType.Int, 4)
};
parameters[0].Value = model.AuthorityID;
parameters[1].Value = model.AuthorityName;
parameters[2].Value = model.AuthorityTag;
parameters[3].Value = model.AuthorityDescription;
parameters[4].Value = model.AuthorityOrder;
if (SqlServerHelper.ExecuteSql(strSql.ToString(), parameters) >= 1)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一个权限
/// </summary>
/// <param name="model">权限实体类</param>
/// <returns></returns>
public bool CreateAuthority(Entity.BASE_AUTHORITYDIR model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Base_AuthorityDir(");
strSql.Append("AuthorityName,AuthorityTag,AuthorityDescription,AuthorityOrder)");
strSql.Append(" values (");
strSql.Append("@AuthorityName,@AuthorityTag,@AuthorityDescription,@AuthorityOrder)");
SqlParameter[] parameters =
{
new SqlParameter("@AuthorityName", SqlDbType.NVarChar, 30),
new SqlParameter("@AuthorityTag", SqlDbType.NVarChar, 50),
new SqlParameter("@AuthorityDescription", SqlDbType.NVarChar, 50),
new SqlParameter("@AuthorityOrder", SqlDbType.Int, 4)
};
parameters[0].Value = model.AuthorityName;
parameters[1].Value = model.AuthorityTag;
parameters[2].Value = model.AuthorityDescription;
parameters[3].Value = model.AuthorityOrder;
if (SqlServerHelper.ExecuteSql(strSql.ToString(), parameters) >= 1)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新数据
/// </summary>
protected void AuthorityLists_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
Entity.BASE_AUTHORITYDIR model = new Entity.BASE_AUTHORITYDIR();
model.AuthorityID = int.Parse(AuthorityLists.DataKeys[e.RowIndex].Values[0].ToString());
model.AuthorityName = ((TextBox)AuthorityLists.Rows[e.RowIndex].FindControl("txt_name")).Text.Trim();
model.AuthorityTag = ((TextBox)AuthorityLists.Rows[e.RowIndex].FindControl("txt_tag")).Text.Trim().ToUpper();
model.AuthorityDescription = ((TextBox)AuthorityLists.Rows[e.RowIndex].FindControl("txt_Description")).Text.Trim();
model.AuthorityOrder = int.Parse(((TextBox)AuthorityLists.Rows[e.RowIndex].FindControl("txt_order")).Text);
if (!bll.UpdateAuthority(model))
{
strinfo.InnerHtml = Smart.Utility.JScript.errinfo("记录更新失败!");
strinfo.Visible = true;
}
//返回浏览狀態
AuthorityLists.EditIndex = -1;
BindOrder();
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Entity.BASE_AUTHORITYDIR GetEntity(int AuthorityID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select AuthorityID, AuthorityName, AuthorityTag, AuthorityDescription, AuthorityOrder ");
strSql.Append(" from Base_AuthorityDir ");
strSql.Append(" where AuthorityID=@AuthorityID");
SqlParameter[] parameters =
{
new SqlParameter("@AuthorityID", SqlDbType.Int, 4)
};
parameters[0].Value = AuthorityID;
Entity.BASE_AUTHORITYDIR entity = new Entity.BASE_AUTHORITYDIR();
DataSet ds = SqlServerHelper.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["AuthorityID"].ToString() != "")
{
entity.AuthorityID = int.Parse(ds.Tables[0].Rows[0]["AuthorityID"].ToString());
}
entity.AuthorityName = ds.Tables[0].Rows[0]["AuthorityName"].ToString();
entity.AuthorityTag = ds.Tables[0].Rows[0]["AuthorityTag"].ToString();
entity.AuthorityDescription = ds.Tables[0].Rows[0]["AuthorityDescription"].ToString();
if (ds.Tables[0].Rows[0]["AuthorityOrder"].ToString() != "")
{
entity.AuthorityOrder = int.Parse(ds.Tables[0].Rows[0]["AuthorityOrder"].ToString());
}
return(entity);
}
else
{
return(null);
}
}
/// <summary>
/// 更新指定的权限
/// </summary>
/// <param name="model">权限实体类</param>
/// <returns></returns>
public bool UpdateAuthority(Entity.BASE_AUTHORITYDIR model)
{
return(dal.UpdateAuthority(model));
}
