/// <summary>
/// 添加
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static int Add(OrderAdminInfo model)
{
string strSQL = "INSERT INTO OrderAdmins(UserName,UserPwd,RoleType,IsDeleted,CreateDateTime) VALUES(@UserName,@UserPwd,@RoleType,0,GETDATE());SELECT @@IDENTITY;";
SqlParameter[] parms = ParameterHelper.GetClassSqlParameters(model);
return(Convert.ToInt32(SQLPlus.ExecuteScalar(CommandType.Text, strSQL, parms)));
}
private static OrderAdminInfo Get(DataRow dr)
{
OrderAdminInfo model = new OrderAdminInfo();
ReflectionHelper.Fill(dr, model);
return(model);
}
public static IPageOfList <OrderAdminInfo> List(SearchSetting settings)
{
FastPaging fp = new FastPaging();
fp.PageIndex = settings.PageIndex;
fp.PageSize = settings.PageSize;
fp.TableName = "OrderAdmins";
fp.TableReName = "p";
fp.PrimaryKey = "ID";
fp.QueryFields = "p.*";
fp.OverOrderBy = " CreateDateTime DESC";
IList <OrderAdminInfo> list = new List <OrderAdminInfo>();
OrderAdminInfo model = null;
DataTable dt = SQLPlus.ExecuteDataTable(CommandType.Text, fp.Build2005());
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
model = Get(dr);
if (model != null)
{
list.Add(model);
}
}
}
int count = Count();
return(new PageOfList <OrderAdminInfo>(list, settings.PageIndex, settings.PageSize, count));
}
public ActionResult Add(OrderAdminInfo model, FormCollection fc)
{
bool error = false;
string roleType = fc["ddlRoles"];
if (OrderAdminService.IsExistsUserName(model.UserName))
{
error = true;
ModelState.AddModelError("UserNameExists", "用户名已存在，请选择其他用户名！");
}
if (string.IsNullOrEmpty(roleType))
{
error = true;
ModelState.AddModelError("RoleType", "请选择管理权限！");
}
if (!error && ModelState.IsValid)
{
model.RoleType = (OrderAdminRoleType)Enum.Parse(typeof(OrderAdminRoleType), roleType);
OrderAdminService.Add(model);
ModelState.AddModelError("Success", "添加成功！");
}
return(View());
}
public static int Add(OrderAdminInfo model)
{
model.UserPwd = Controleng.Common.Utils.MD5(model.UserPwd);
return(OrderAdminManage.Add(model));
}
