/// <summary>
/// 由一行数据得到一个实体
/// </summary>
private EmsModel.Role GetEmsModel(DbDataReader dr)
{
EmsModel.Role EmsModel = new EmsModel.Role();
DbDataReaderToModel(EmsModel, dr);
return(EmsModel);
}
public void AddRole(HttpContext context)
{
string callback = context.Request["jsoncallback"];
string name = context.Request["name"];
int result;
if (new EmsBLL.Role().IsNameExists(name))
{
result = -1;
}
else
{
string useridcard = context.Request["useridcard"];
EmsModel.Role role = new EmsModel.Role();
role.Name = name;
role.Creator = useridcard;
role.CreateTime = DateTime.Now;
role.IsDelete = 0;
result = new EmsBLL.Role().Add(role);
}
//输出Json
HttpContext.Current.Response.Write(callback +
"({\"result\":" + result + "})");
HttpContext.Current.Response.End();
}
public void GetData(HttpContext context)
{
string callback = context.Request["jsoncallback"];
string rolename = context.Request["rolename"];
EmsModel.Role role = new EmsModel.Role();
if (!string.IsNullOrEmpty(rolename))
{
role.Name = rolename;
}
//序列化
System.Web.Script.Serialization.JavaScriptSerializer jss = new System.Web.Script.Serialization.JavaScriptSerializer();
EmsModel.JsonModel mod = new EmsBLL.Role().GetJsonModel(role);
//输出Json
HttpContext.Current.Response.Write(callback + "({\"result\":" + jss.Serialize(mod) + "})");
HttpContext.Current.Response.End();
}
/// <summary>
/// 获取泛型数据列表
/// </summary>
public List <EmsModel.Role> GetList(EmsModel.Role role)
{
StringBuilder sbSql4org;
DbParameter[] parms4org;
sbSql4org = new StringBuilder();
sbSql4org.Append("SELECT * FROM Role where IsDelete=0 ");
if (!string.IsNullOrEmpty(role.Name))
{
sbSql4org.Append(" and Name like '%'+@Name+'%'");
}
sbSql4org.Append(" order by CreateTime desc");
parms4org = new DbParameter[] {
dbHelper.CreateInDbParameter("@Name", DbType.String, role.Name)
};
using (DbDataReader dr = dbHelper.ExecuteReader(CommandType.Text, sbSql4org.ToString(), parms4org))
{
List <EmsModel.Role> lst = GetList(dr);
return(lst);
}
}
