public ActionResult AddTerminalManufacturer(TerminalManufacturerAddModel model) { if (ModelState.IsValid) { var result = TerminalManufacturerBLL.AddTerminalManufacturer(model, base.UserIDForLog); base.DoLog(OperationTypeEnum.Add, result, "TerminalManufacturerName:" + model.ManufacturerName); return(Json(result)); } else { return(PartialView("_AddTerminalManufacturer", model)); } }
public static OperationResult AddTerminalManufacturer(TerminalManufacturerAddModel model, int CreateUserID) { List <SqlParameter> paras = new List <SqlParameter>() { new SqlParameter("@ManufacturerName", SqlDbType.NVarChar, 200), new SqlParameter("@ManufacturerCode", SqlDbType.Char, 5), new SqlParameter("@Nationality", SqlDbType.Char, 6), new SqlParameter("@CreateUserID", SqlDbType.Int) }; paras[0].Value = model.ManufacturerName.Trim(); paras[1].Value = model.ManufacturerCode.Trim(); paras[2].Value = model.Nationality.Trim(); paras[3].Value = CreateUserID; #region SQL string sql = @"INSERT INTO dbo.TerminalManufacturer ( ManufacturerName , ManufacturerCode , Nationality, CreateUserID ) VALUES ( @ManufacturerName , -- ManufacturerName - nvarchar(20) @ManufacturerCode, -- ManufacturerCode - char(5) @Nationality, -- Nationality - char(6) @CreateUserID )"; #endregion bool result = MSSQLHelper.ExecuteNonQuery(CommandType.Text, sql, paras.ToArray()) > 0; return(new OperationResult() { Success = result, Message = result ? PromptInformation.OperationSuccess : PromptInformation.DBError }); }
public ActionResult AddTerminalManufacturer() { TerminalManufacturerAddModel model = new TerminalManufacturerAddModel(); return(PartialView("_AddTerminalManufacturer", model)); }