public ActionResult AddVehicleTypes(VehicleTypeAddModel model) { if (ModelState.IsValid) { var result = VehicleMaintainBLL.AddVehicleType(model, base.UserIDForLog); base.DoLog(OperationTypeEnum.Add, result, "VehicleTCode:" + model.Code); return(Json(result)); } else { return(PartialView("_AddVehicleTypeGrid", model)); } }
public static OperationResult AddVehicleType(VehicleTypeAddModel model, int CreateUserID) { List <SqlParameter> paras = new List <SqlParameter>() { new SqlParameter("@Code", SqlDbType.TinyInt), new SqlParameter("@Name", SqlDbType.NVarChar, 30), new SqlParameter("@CreateUserID", SqlDbType.Int) }; paras[0].Value = model.Code; paras[1].Value = model.Name.Trim(); paras[2].Value = CreateUserID; #region SQL string sql; #endregion if (!string.IsNullOrWhiteSpace(model.HigheNumber.ToString())) { paras.Add(new SqlParameter("@Number", SqlDbType.TinyInt)); paras[3].Value = model.HigheNumber; sql = @"INSERT INTO dbo.VehicleTypes (Code,Name,ParentCode,CreateUserID) VALUES (@Code,@Name,@Number,@CreateUserID)"; } else { sql = @"INSERT INTO dbo.VehicleTypes (Code,Name,CreateUserID) VALUES (@Code,@Name,@CreateUserID)"; } bool result = MSSQLHelper.ExecuteNonQuery(CommandType.Text, sql, paras.ToArray()) > 0; return(new OperationResult() { Success = result, Message = result ? PromptInformation.OperationSuccess : PromptInformation.DBError }); }