public ActionResult AddTerminalType() { TerminalTypeAddModel model = new TerminalTypeAddModel(); model.Filter = true; //默认过滤 model.ACCOFF_Frequency = 180; //默认3分钟 model.ACCON_Frequency = 15; //默认15秒 model.TerminalManufacturerSelectList = new SelectList(TerminalManufacturerBLL.GetTerminalManufacturers(), "ID", "ManufacturerName"); return(PartialView("_AddTerminalType", model)); }
public ActionResult AddTerminalType(TerminalTypeAddModel model) { if (ModelState.IsValid) { var result = TerminalTypeBLL.AddTerminalType(model, base.UserIDForLog); base.DoLog(OperationTypeEnum.Add, result, "TerminalName:" + model.TerminalName); return(Json(result)); } else { model.TerminalManufacturerSelectList = new SelectList(TerminalManufacturerBLL.GetTerminalManufacturers(), "ID", "ManufacturerName"); return(PartialView("_AddTerminalType", model)); } }
public static OperationResult AddTerminalType(TerminalTypeAddModel model, int CreateUserID) { List <SqlParameter> paras = new List <SqlParameter>() { new SqlParameter("@TerminalName", SqlDbType.NVarChar, 200), new SqlParameter("@TerminalManufacturerID", SqlDbType.Int), new SqlParameter("@ACCON_Frequency", SqlDbType.Int), new SqlParameter("@ACCOFF_Frequency", SqlDbType.Int), new SqlParameter("@Filter", SqlDbType.Bit), new SqlParameter("@CommunicationMode", SqlDbType.NVarChar, 50), new SqlParameter("@Remark", SqlDbType.NVarChar, 500), new SqlParameter("@CreateUserID", SqlDbType.Int), }; paras[0].Value = model.TerminalName.Trim(); paras[1].Value = model.TerminalManufacturerID; paras[2].Value = model.ACCON_Frequency; paras[3].Value = model.ACCOFF_Frequency; paras[4].Value = model.Filter; if (string.IsNullOrWhiteSpace(model.CommunicationMode)) { paras[5].Value = DBNull.Value; } else { paras[5].Value = model.CommunicationMode.Trim(); } if (string.IsNullOrWhiteSpace(model.Remark)) { paras[6].Value = DBNull.Value; } else { paras[6].Value = model.Remark.Trim(); } paras[7].Value = CreateUserID; #region SQL string sql = @"INSERT INTO dbo.TerminalTypes ( TerminalName , TerminalManufacturerID , ACCON_Frequency , ACCOFF_Frequency , Filter , CommunicationMode , Remark, CreateUserID ) VALUES ( @TerminalName , -- TerminalName - nvarchar(20) @TerminalManufacturerID , -- TerminalManufacturerID - int @ACCON_Frequency , -- ACCON_Frequency - int @ACCOFF_Frequency , -- ACCOFF_Frequency - int @Filter , -- Filter - bit @CommunicationMode , -- CommunicationMode - nvarchar(50) @Remark, -- Remark - nvarchar(50) @CreateUserID )"; #endregion bool result = MSSQLHelper.ExecuteNonQuery(CommandType.Text, sql, paras.ToArray()) > 0; return(new OperationResult() { Success = result, Message = result ? PromptInformation.OperationSuccess : PromptInformation.DBError }); }