protected void btnSave_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(Request.QueryString["rCode"]))
{
string rCode = Request.QueryString["rCode"];
Maticsoft.BLL.tRoleMenu BLLtt = new Maticsoft.BLL.tRoleMenu();
BLLtt.Delete(int.Parse(rCode));
FineUIPro.TreeNode[] nodes = TreeDpt.GetCheckedNodes();
if (nodes.Length > 0)
{
Maticsoft.Model.tRoleMenu m = new Maticsoft.Model.tRoleMenu();
Maticsoft.BLL.tRoleMenu BLL = new Maticsoft.BLL.tRoleMenu();
foreach (FineUIPro.TreeNode node in nodes)
{
m.rCode = int.Parse(rCode);
m.mCode = int.Parse(node.NodeID);
BLL.Add(m);
}
PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference());
}
else
{
Alert.ShowInTop("操作失败！");
}
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.tRoleMenu DataRowToModel(DataRow row)
{
Maticsoft.Model.tRoleMenu model=new Maticsoft.Model.tRoleMenu();
if (row != null)
{
if(row["rCode"]!=null && row["rCode"].ToString()!="")
{
model.rCode=int.Parse(row["rCode"].ToString());
}
if(row["mCode"]!=null && row["mCode"].ToString()!="")
{
model.mCode=int.Parse(row["mCode"].ToString());
}
}
return model;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.tRoleMenu GetModel()
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 rCode,mCode from tRoleMenu ");
strSql.Append(" where ");
SqlParameter[] parameters = {
};
Maticsoft.Model.tRoleMenu model=new Maticsoft.Model.tRoleMenu();
DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.tRoleMenu model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update tRoleMenu set ");
strSql.Append("rCode=@rCode,");
strSql.Append("mCode=@mCode");
strSql.Append(" where ");
SqlParameter[] parameters = {
new SqlParameter("@rCode", SqlDbType.Int,4),
new SqlParameter("@mCode", SqlDbType.Int,4)};
parameters[0].Value = model.rCode;
parameters[1].Value = model.mCode;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Maticsoft.Model.tRoleMenu model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into tRoleMenu(");
strSql.Append("rCode,mCode)");
strSql.Append(" values (");
strSql.Append("@rCode,@mCode)");
SqlParameter[] parameters = {
new SqlParameter("@rCode", SqlDbType.Int,4),
new SqlParameter("@mCode", SqlDbType.Int,4)};
parameters[0].Value = model.rCode;
parameters[1].Value = model.mCode;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
