public ActionResult AddSensorTypes(SensorAddModel model) { if (ModelState.IsValid) { var result = SensorBLL.AddSensorType(model, base.UserIDForLog); base.DoLog(OperationTypeEnum.Add, result, "SensorCode:" + model.SensorCode); return(Json(result)); } else { return(PartialView("_AddSensorType", model)); } }
public static OperationResult AddSensorType(SensorAddModel model, int CreateUserID) { List <SqlParameter> paras = new List <SqlParameter>() { new SqlParameter("@SensorName", SqlDbType.NVarChar, 30), new SqlParameter("@TValue", SqlDbType.Bit), new SqlParameter("@FValue", SqlDbType.Bit), new SqlParameter("@Remark", SqlDbType.NVarChar, 200), new SqlParameter("@CreateUserID", SqlDbType.Int), new SqlParameter("@SensorCode", SqlDbType.Int), new SqlParameter("@TypeCode", SqlDbType.NVarChar) }; paras[0].Value = model.SensorName.Trim(); paras[1].Value = model.Value1; paras[2].Value = model.Value2; if (string.IsNullOrWhiteSpace(model.Remark)) { paras[3].Value = DBNull.Value; } else { paras[3].Value = model.Remark; } paras[4].Value = CreateUserID; paras[5].Value = model.SensorCode; paras[6].Value = model.TypeCode.Trim(); #region SQL string sql; #endregion sql = @"INSERT INTO dbo.SensorList(SensorName,Value1,Value2,Remark,Status,CreateUserID,SensorCode,TypeCode) VALUES (@SensorName,@TValue,@FValue,@Remark,'0',@CreateUserID,@SensorCode,@TypeCode)"; bool result = MSSQLHelper.ExecuteNonQuery(CommandType.Text, sql, paras.ToArray()) > 0; return(new OperationResult() { Success = result, Message = result ? PromptInformation.OperationSuccess : PromptInformation.DBError }); }