/// <summary>
/// 由一行数据得到一个实体
/// </summary>
private EmsModel.RoleOfUser GetEmsModel(DbDataReader dr)
{
EmsModel.RoleOfUser EmsModel = new EmsModel.RoleOfUser();
DbDataReaderToModel(EmsModel, dr);
return(EmsModel);
}
public void DeleteUserRelation(HttpContext context)
{
string callback = context.Request["jsoncallback"];
int roleid = Convert.ToInt32(context.Request["roleid"]);
string useridcard = context.Request["useridcard"];
int result;
EmsModel.RoleOfUser roleu = new EmsModel.RoleOfUser();
roleu.RoleId = roleid;
roleu.LoginName = useridcard;
result = new EmsBLL.RoleOfUser().DeleteUserRelation(roleu);
//输出Json
HttpContext.Current.Response.Write(callback +
"({\"result\":" + result + "})");
HttpContext.Current.Response.End();
}
/// <summary>
/// 删除关系数据， 删单条
/// </summary>
public int DeleteUserRelation(EmsModel.RoleOfUser roleu)
{
try
{
StringBuilder sbSql;
DbParameter[] parms;
sbSql = new StringBuilder();
sbSql.Append("DELETE FROM RoleOfUser");
sbSql.Append(" WHERE RoleId=@RoleId and LoginName=@LoginName");
parms = new DbParameter[] {
dbHelper.CreateInDbParameter("@RoleId", DbType.Int32, roleu.RoleId), dbHelper.CreateInDbParameter("@LoginName", DbType.String, roleu.LoginName)
};
return(dbHelper.ExecuteNonQuery(CommandType.Text, sbSql.ToString(), parms));
}
catch (Exception)
{
//写入日志
//throw;
return(0);
}
}
