/// <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)); }