public static SelectResult <VehicleTypeEditModel> GetVehicleTypeID(int id) { List <SqlParameter> paras = new List <SqlParameter>() { new SqlParameter("@Code", SqlDbType.TinyInt), }; paras[0].Value = id; string sql = @"SELECT Code ,Name ,CAST(ParentCode AS nvarchar(10))as ParentCode FROM dbo.VehicleTypes WHERE Code=@Code"; List <VehicleTypeEditModel> list = ConvertToList <VehicleTypeEditModel> .Convert(MSSQLHelper.ExecuteDataTable(CommandType.Text, sql, paras.ToArray())); VehicleTypeEditModel data = null; string msg = string.Empty; if (list == null) { msg = PromptInformation.DBError; } else if (list.Count == 0) { msg = PromptInformation.NotExists; } else { data = list[0]; } return(new SelectResult <VehicleTypeEditModel>() { DataResult = data, Message = msg }); }
public ActionResult EditVehicleTypes(VehicleTypeEditModel model) { if (ModelState.IsValid) { var result = VehicleMaintainBLL.EditVehicleType(model, base.UserIDForLog); base.DoLog(OperationTypeEnum.Edit, result, "Code:" + model.Code); return(Json(result)); } else { return(PartialView("_EditVehicleTypes", model)); } }
public static OperationResult EditVehicleType(VehicleTypeEditModel model, int EditUserID) { List <SqlParameter> paras = new List <SqlParameter>() { new SqlParameter("@Code", SqlDbType.TinyInt), new SqlParameter("@Name", SqlDbType.VarChar, 13), new SqlParameter("@ID", SqlDbType.TinyInt), new SqlParameter("@EditTime", SqlDbType.DateTime), new SqlParameter("@EditUserID", SqlDbType.Int) }; paras[0].Value = model.Code; paras[1].Value = model.Name.Trim(); paras[2].Value = model.ID; paras[3].Value = DateTime.Now; paras[4].Value = EditUserID; #region SQL string sql; #endregion if (!string.IsNullOrWhiteSpace(model.ParentCode)) { paras.Add(new SqlParameter("@ParentCode", SqlDbType.TinyInt)); paras[3].Value = model.ParentCode; sql = @"UPDATE dbo.VehicleTypes SET Code = @ID ,Name=@Name, ParentCode = @ParentCode,EditUserID=@EditUserID,EditTime=@EditTime WHERE Code = @ID"; } else { sql = @"UPDATE dbo.VehicleTypes SET Code = @ID ,Name=@Name,EditUserID=@EditUserID,EditTime=@EditTime WHERE Code = @ID"; } int result = MSSQLHelper.ExecuteNonQuery(CommandType.Text, sql, paras.ToArray()); string msg = string.Empty; switch (result) { case 1: msg = PromptInformation.OperationSuccess; break; case 0: msg = PromptInformation.NotExists; break; case -1: msg = PromptInformation.DBError; break; } return(new OperationResult() { Success = result > 0, Message = msg }); }